From approval chains to error-handling loops, these five flow patterns will save you hours of debugging and rework.
Whether you're new to Power Automate or you've built dozens of flows, certain patterns come up again and again. Here are five that every developer should have in their toolkit.
Don't just send a single approval - build a chain. If the first approver doesn't respond within 48 hours, escalate to their manager. Use a Do Until loop with a delay and a condition that checks the approval status.
The key insight: set a counter variable and increment it each loop. After 3 escalations, route to a fallback group instead of an individual.
Power Automate doesn't have native try/catch, but you can simulate it. Use Scope actions:
Scope: Try
-> [Your actions here]
Scope: Catch (run after = has failed)
-> Send error notification
-> Log to SharePoint list
Scope: Finally (run after = has succeeded, has failed, has skipped)
-> Clean up temp variables
When you need to process hundreds of items (like syncing records), don't fire one flow per item. Use chunking: split your array into batches of 50, iterate over batches with Apply to Each, and process each batch with concurrent control set to 1.
Hardcoding values in flows is a maintenance headache. Create a SharePoint list or Dataverse table with key-value pairs for your configuration. Your flow reads config at startup. Change behavior without editing the flow.
Cloud flows can sometimes fire twice for the same event. At the start of your flow, check if you've already processed this trigger by looking up a "processed events" list. If found, terminate early. This prevents duplicate emails, duplicate records, and confused users.
Master these five and you'll spend less time debugging and more time building.
Get the latest Power Platform news and tutorials delivered to your inbox.
A step-by-step walkthrough of building a feedback collection agent that routes responses to the right team and tracks sentiment over time.