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...