Power Automate: getFutureTime function
Returns the current timestamp plus a number of time units. Always counts from UTC now.
TAG
Problem Solved
Problem Solved is one of my favorite sections, or at least the one I have the most fun writing. This is where I solve a problem that bugged me for a while and hand you the solution, so you do not have to burn time hunting for it. Every post stays within the theme of the site, so do not expect general programming fixes here. I call it Problem Solved because it is my way of saying fixed, let us move ahead. These posts are sporadic, since there is not always something worth publishing. Depending on the subject, I either slot them into the regular Tuesday and Friday schedule when they fit the theme, or give you an extra article that week. I write a new one as soon as I have a fresh fix to share.
Power Automate: convertFromUtc function
Converts a UTC timestamp into a target time zone. Returns a string with no offset or Z marker.
Excel: If Function
Returns one of two values based on whether a condition is true or false.
Batch Operations and Throttling Mitigation in Power Automate
Bundle hundreds of SharePoint writes into a single $batch request to stop hitting throttling limits.
Power Automate: slice Function
Extracts a substring by position. Supports negative indices; endIndex is exclusive.
Power Apps: LookUp Function
Returns the first record that matches a condition, or a single reduced value. Blank if nothing matches.
How to stop an infinite trigger loop in Power Automate?
Stop a flow from re-triggering itself with trigger conditions, flag columns, or a create-only trigger.
Dynamic Content Troubleshooting in Power Automate
How to fix the unexpectedly did not find the new dependency in the package graph
How to fix the "InvalidOpenApiFlow" issue when Enabling an Imported Flow
Why you need the question mark operator in Power Automate expressions
Returns null instead of crashing when a referenced property might not exist.
