PowerApps – Notify users of updates to your apps

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…

PowerApps – Creating and assigning CDS Security Roles

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…

SharePoint Cloud Hybrid Search Tips

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…

Flow – Get SharePoint list items by the current date using ODATA

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…

Flow – Send an email action ‘Out of call volume quota’

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…

Office 365 Security & Compliance Admin Center not appearing

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…

SQL instance connection error – ‘A network-related or instance-specific error occurred’

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…

Azure password-less sign-in ‘Something went wrong’ error

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…

Flow – Terminate action with custom status

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…