Issues with Connection Reference
Sudeep GhatakWhat I hate the most is the issue that resolves by itself. Every issue should have a cause. If I can't find the cause it drives me crazy. This is…
How to efficiently achieve looping in your flows
Looping is a powerful feature in Power Automate that allows you to perform repetitive tasks or iterate through a collection of data. However, excessive looping can have a negative impact…
Setting Multi Value columns in SharePoint
Let's start with the People fields. If you want to update a SharePoint list with multi-value People field, you need to provide it with an array of people objects.
Extend Approval Tasks beyond 30 days
I often get asked how to overcome the 30-day limitation in Microsoft flow. As per the design, the flow approval tasks will expire after 30 days and the approver will…
Condition mismatch in Power Automate
I see several posts in the community forum where people struggle to understand why their conditional actions wouldn't work. I keep hearing this a lot "I know there is a…
Query to filter SharePoint List Items by Lookup Fields in Microsoft Flow (Power Automate)
In one of the recent projects, I needed to apply a filter on a lookup field in a document library. Here is what I was trying to achieve. I have…
Updating Hyperlink column in MS Flow (Power Automate)
Recently I came across an issue where I had to update a hyperlink field within SharePoint. I thought how hard could that be? Well, it seems you can't specify Url…
Flow error: The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator.
I was building this simple flow that gets and then updates an item in a SharePoint list. How hard can it be? Well, just as I was about to leave…
“Save as draft” and “Submit” – PowerApps and Flow
Electronic forms are usually long. More than once my customers requested "Save form as draft" feature. In most cases, it is prudent to offer this option to your user. They…
SQL Saturday is kicking off!
If you haven't already heard, SQL Saturday South Island is kicking off on Saturday May 26th. This event is not just for DBAs but for anyone who interacts with data.…