Sharing my tips and tricks for Office 365, SharePoint and the Microsoft Cloud.
When importing Flow packages into different tenants, the configuration often needs updating e.g. with a SharePoint trigger you might need to update the URL of the SharePoint site and the name of a list/library. This can be very time consuming, for example if you are deploying the same Flow to multiple customer tenants. Wouldn’t it…
Currently there is no out of the box functionality available in PowerApps to ensure that your users’ are running the latest version of your app. When you publish a new version there is no guarantee that your users’ will get this straight away. This is because the PowerApps IOS/Android apps cache the apps (what a…
I’ve been working with the Common Data Service (CDS) recently while developing a few PowerApps and wanted to share my learnings with Security Roles. This was my first time using CDS so there was a bit of a learning curve but what I can say so far is that it’s awesome and incredibly powerful! I’m…
I recently set up SharePoint 2016 hybrid in a lab environment for customer demos. I thought I would post some quick tips/tricks, specifically for Cloud Hybrid Search based on what I learnt during the configuration – Delete your existing on-prem SSA if you have one configured already. The Cloud SSA which you provision as part…
The built in Flow ‘Get Items’ and ‘Get Files (Properties Only)’ actions are great for retrieving a filtered set of items from SharePoint lists and libraries using an ODATA query except when it comes to working with dates! Sometimes you may wish to query list items/files based on the today’s date e.g. Created, Modified or…
I’m currently working on a document disposition/review Flow for a client (more on that coming soon!) which kept erroring. It was specifically failing in a ‘Do Until’ action and sadly Flow doesn’t give you any details as to what failed inside a Do Until. Inside the Do Until, I had a send an email action…
I recently asked a client to add us to the ‘Compliance Administrator’ role in the Security & Compliance center of their tenancy so I could set up some Labels and Retention policies for them. What we found is when granted the ‘Compliance Administrator’ or even the ‘Organization Management’ role (which should give a greater level…
I was stumped with this error for hours last night while building out some on-premises SharePoint Farms. I was trying to connect to a specific named instance as opposed to the default instance. I thought I would blog about the fix because it’s something I’ve never come across before and it took some googling of…
I recently enabled password-less authentication for our Azure tenant. A number of our staff already used the Authenticator app for MFA sign-in so it made sense to make the move to password-less! If you’re thinking of enabling it – I can confirm – it’s brilliant! but keep in mind it’s still in public preview.However I…
The ‘Terminate’ action provides a useful way to stop/end a flow and specify your own message. One thing to be aware of is that custom ‘Status’ values are not yet supported. In the flow designer the option to enter a custom value is visible for the action, however if you attempt to use it you…