Setting Multi Value columns in SharePoint
Sudeep GhatakLet'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.…
Conditional check – MS Flow
I am sure you all have had faced issue when your Conditional action evaluates to "False" when you know your conditional logic is correct. I had one such day when…
Use of Cognitive services in tertiary education
Amit and I presented a talk at the Annual Tertiary conference held in Christchurch. Out talk was on how we can make use of Cognitive services in universities and schools.…