Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.


VIDEO – SharePoint Saturday – Upload PowerApps picture with MS Flow

During SharePoint Saturday in Chicago, I attended a great session by Mark Vogt ( to LIVE BUILD a working PowerApp.    Attendees were able to follow along by creating the sample application on their own Office 365 tenant.

The demo video below shows the sample application with PowerApps, MS Flow, and how to leverage the Camera control to take mobile pictures and save to a SharePoint Picture Library.  One of the challenges was to convert format from DataURL (PowerApp Camera control) to Binary (SharePoint File).




Image result for powerapp

Image result for powerapp
Image result for ms flow




MS Flow Code

'SPSat-UploadPicture'.Run("powerapp.jpg", Camera1.Photo)


What’s in that patch? Apr 2018

NOTE – PDF format updated to include both SharePoint 2013 and 2016 notes.

Ever wondered what fixes are inside of a given CU?   Please see attached PDF with full detail. I wanted a new format for easy reading.   Show management and make the business case for why downtime should be taken to apply CUs.  Also posted at

If you found this helpful, please leave a comment.   



What’s in that patch – Apr 2018.PDF

PWA Refresh – Clone Project Server to Lower Env (DEV)

Cloning a project server environment is not a simple procedure.   Wanted to share notes to help others.   Duplicating the SQL databases is a good start.   However, there are internal issues with duplicate GUID (same number already in use) that can create issues.

To resolve that hurdle I coded PowerShell which generates a new GUID and updates Site Collection (SPSite) via TSQL directly.

With a fresh new GUID in place we can follow steps in SharePoint Central Admin, PowerShell, and PWA Settings to bring the new PWA database pairs (SharePoint Content + Project Plans) online for customers.   Word DOC included below with step-by-step detail.   Cheers! 


Download Checklist

PWA Refresh Procedure.DOC



Context Diagram


© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲