TL;DR: Format dates directly with utcNow('your-format') instead of wrapping it in a separate formatDateTime call. 🧰 Free tool: Test your utcNow() / formatDateTime format strings with a live pr...

TL;DR: Hold static parameters in Parse JSON or Compose instead of Initialize Variable to keep flows readable and preserve loop concurrency. 💡 Challenge In many Power Automate flows, you might fin...

TL;DR: Use a browser JSON Viewer extension (or Edge’s built-in formatting) to turn raw Power Automate JSON into readable, structured data. 💡 Challenge Navigating through unformatted JSON data in ...

TL;DR: Turn on Advanced Mode in the Filter Array action to write custom expressions and handle complex filtering in a single step. 💡 Challenge At first glance, the ‘Filter Array’ action in Power ...

TL;DR: Reassign a departed maker’s Power Apps via the CoE Starter Kit admin apps or the Set-AdminPowerAppOwner PowerShell cmdlet for clean, bulk ownership transfer. 💡 Challenge When a maker leave...

TL;DR: Tap the Microsoft Power Platform Community (community.powerplatform.com) for expert answers and ready-made sample apps to speed up your projects. 💡 Challenge Have you ever found yourself s...

How to extract data from an HTML table inside an email body in Power Automate, by parsing the HTML as XML and selecting rows and columns with XPath expressions.

Photo by Sergei Starostin on Pexels.com The most frequently asked question I receive is “How to restore (and create) a backup from a flow to restore earlier versions?” Unfortunately, there is no ...

Often, data is not stored in just one place, but you need a combination of multiple data sources. While you could solve this with multiple collections, this is not always the most practical approac...

Short answer: Respond to a Power App or flow cannot return an array directly, only flat outputs such as text, number or yes/no. The workaround is to turn the array into one text output in the flow ...