With default environment routing and generation of Developer environments, I kept forgetting to add a service principal for delegated Power Platform Pipelines deployment. Instead of manually doing it each time, I created an automated solution using Power Automate. The plan? Set up a daily flow that checks for any new Developer environments and automatically grants permissions to the service principal.
If you’re like me, you like to keep a site register for your users so they can see who the site owners are. Of course, this information is available for SharePoint Online administrators in the SharePoint administration center, but there…
Including an image as part of the body of an email is not as straight forward as you might like when you’re dealing with Power Automate. Including the image as an attachment to an email is an easy workaround, but,…
I came across an instance where I wanted to filter a REST API call on a SharePoint hyperlink field. However, this cannot be done using your traditional Odata filter. Therefore, I had to filter my query using CAML query. CAML…
When you create a new environment, you may expect your approval flows to work right out of the gate in Power Automate. However, approvals are connected to the Microsoft Flow Approvals and Microsoft Flow Approvals Core Solution solutions which need…
There are many cases where you might need a user with read permissions to start a Power Automate flow from a SharePoint list or library. However, if the user has anything below contribute permissions on that list/library, they won’t see…
I have to thank the Power Apps guru Shane Young for the inspiration behind this post. If you haven’t watched any of Shane’s videos on YouTube, I urge you to check him out. He is full of great tips for…
I covered how to update properties of a file or list item in SharePoint without affecting the version history in a previous post, however, I received a 502 Bad Gateway error when the file was in a major version and…
My last post, Capturing a reassigned approval flow from the Common Data Service (CDS), detailed how you can find a reassigned approval request in the Common Data Service, however, I did not detail how you get the user details. Last…
There have been instances where I like to keep logs of approval workflows in a SharePoint list so the business team can see who has approved each approval flow. As we know, only flows that are assigned to you, are…