Another 'hidden' gotcha that I figured I'd share in the SharePoint / Power Automate world .... I created a Power Automate recently, which needed go through all items in a SharePoint list where a particular Checkbox field was ticked. Should be simple, right? Just put a wee Filter Query in the 'Get Items' action in Power Automate - easy, right? NO! I tried: CheckboxField eq true ❌ CheckboxField eq 'true' ❌ CheckboxField eq Yes ❌ sigh .... none of the above would work! I

A quirky one I came across recently that I figured I'd share! I have a Power App that uses a SharePoint list, which in turn uses a field which is a lookup into a second SharePoint list. I wanted to clear the values from the lookup field in SharePoint using Power Automate, i.e., removing any lookup value and leaving it empty. Should be easy, right? Famous last words ... 😊 In Power Automate SharePoint lookup fields present like this in the Update Action: Note the 'Id' at the

A while back, I was using PowerAutomate to automate the creation of individual, personalised Calendar Invites to users based on a set of...

I had a requirement recently to remove a single quote from a string in one of my PowerAutomates. Simple enough you might think. Just use...

In this quick video we are going to see how you can use the Otagem Calendar to Timesheet Flow to convert events in your Outlook Calendar...

I was recently asked by a customer using a SharePoint list based Timesheet system if it was possible to populate entries in the Timesheet...

Sometimes, as part of a Flow (PowerAutomate is such a mouthful!), you want to store the date something happened in Field A in SharePoint...

If you use SharePoint to create Document Libraries regularly, you'll know that when you use the "Create document library" screen to...

In this quick video, we're going to see how you can lock down the security on a Document or List Item as soon as it has been created or...

So recently I had a problem with a PowerAutomate (Flow) triggered from a button on a PowerApps form. This Flow just would not fire...

When implementing Approval Workflows using Microsoft Power Automate (aka Flow) and SharePoint Online, a typical requirement is to capture...

Power Automate is great for sending Email Confirmations to specified users. However, sometimes you need to send a confirmation email...

One of the glaring omissions in Power Automate is the ability to rename a file in a SharePoint Document Library. I'd seen a few online...