Guides · 119
What are you trying to do?
Fix a problem
12The error or symptom in front of you, and the fix.Power Automate
Change a Power Automate flow's owner when someone leaves
Change the owner of a Power Automate flow when someone leaves, in or out of a solution, and recover orphaned flows whose owner's account is gone. Also covers the leaver's connections, licences, service principal owners and flows made with personal accounts.
Power Automate
List rows present in a table only returns 256 rows? Fix it, plus dates and filters
The Excel action List rows present in a table only returns 256 rows by default, shows dates as numbers like 45567, and rejects most filters. Here's how to get every row, real dates and filters that work, and when to stop using Excel.
Power Automate
Power Automate: send email from a shared mailbox, and fix the permission errors
To make Power Automate send email from a shared mailbox, use the shared mailbox action and give the connection's account Send As. Here's the setup, which permission does what, and the fixes for 'You do not have the permission to send the message on behalf of the specified user'.
Power Automate
502 Bad Gateway and other random failures in Power Automate: retry, wait or report
A flow that worked for months starts failing at random with 502, 500, 503 or 504. How to tell a temporary service problem from your own fault, set retries that actually help, make the flow survive the next outage, and report it with the evidence support needs.
Power Automate
Approvals that don't stall: reminders, escalation and an audit trail
An approval flow with no timeout waits until the run limit kills it, and nobody is told. Here is how to add a deadline, reminders, escalation to a second approver, and a record of every decision.
Power Automate
Desktop flow won't run from the cloud: 'connection not found', session and credential errors fixed
The machine runtime says Connected, but the cloud flow can't run the desktop flow. The checks for machine, connection, session and credentials, and the fix for common error codes such as MachineNotFound, WindowsIdentityIncorrect and AttendedUserSessionNotActive.
Power Automate
Dynamic content missing? Parse JSON, nested arrays and loops explained
Why a field you know exists doesn't appear in the dynamic content picker, why Apply to each appears out of nowhere, and how to read any value from webhook or HTTP JSON with Parse JSON or a safe expression.
Power Automate
Files and attachments in flows: email attachments, Forms uploads and list attachments to SharePoint
Save email attachments, Microsoft Forms uploads and SharePoint list attachments into a library folder. The trigger settings that matter, how to skip signature images, why .msg attachments don't show up, and the fixes for empty files and 400 Bad Request.
Power Automate
Get more than 5,000 SharePoint items in Power Automate
Why Get items returns 100 rows, stops at 5,000 or fails with 'exceeds the list view threshold', and the four fixes in order: Top Count, pagination, indexed columns, and a loop for lists beyond 100,000 items.
Power Automate
Move a cloud flow into a solution, and fix 'missing dependencies' on import
Why flows belong in solutions, how to add existing flows (one at a time or in bulk), what to set up so they deploy cleanly, and how to read and fix 'Import failed due to missing dependencies'.
Power Automate
Restore a deleted flow in Power Automate (cloud and desktop flows)
Deleted a cloud flow by mistake? You have 21 days. How an admin gets it back with a button flow or PowerShell, what to do after it's restored, how to recover a deleted desktop flow, and how to make sure you never need to.
Power Automate
Why didn't my flow trigger? A checklist that finds the cause
Your Power Automate flow is on, the item was created, nothing ran. Ten checks in the order that finds the cause fastest: flow status, run history, trigger conditions, polling delays, connections, data policies, admin mode, licences and suspension rules.
Choose a tool
2Decide before you build.Power Automate
Cloud flow, agent flow or desktop flow? Which one to build
Three kinds of flow, three ways to pay. What each is for, how it's licensed or billed, what it can't do, and a quick way to pick: connectors and APIs, an agent's tools, or clicking through an app that has no API.
Power Automate
Cloud flows or Azure Logic Apps?
Power Automate and Azure Logic Apps share a designer and many connectors, but they're built for different owners, scales and controls. How to choose, and when to move a flow across.
Design patterns
4Structures that hold up as things grow.Power Automate
Child flows that fail well: inputs, results, errors and connections
Child flow error handling that works: split a big flow without losing track of failures. Set up the child so it always reports back, let the parent decide what to do, avoid the 'child workflows only support embedded connections' error, and license it correctly.
Power Automate
Reminder emails for items due soon: a daily flow that gets dates right
Send a reminder a set number of days before a SharePoint due date. A daily scheduled flow that works in your time zone, filters the list efficiently, avoids double-sending, and can send one digest per person instead of a flood of emails.
Power Automate
Try, catch and finally: error handling with scopes
In Power Automate, a failed action just stops the flow by default, and the owner may never hear about it. The try-catch-finally pattern with scopes makes every failure visible, logged and handled.
Power Automate
UI elements that survive changes: robust selectors for desktop flows
UI element not found in a Power Automate desktop flow after an app update, a new window title or a different screen? Make selectors that keep working: find what changes, remove the dynamic parts, add fallback selectors, wait for the screen, and repair quickly when it does break.
Measure
1Know whether it's working.Power Automate
Flow health KPIs: success rate, failure causes and hours saved
A flow that fails quietly costs more than no flow at all. Five KPIs that show whether your automations are healthy and paying off, where to get each number, and the traps in the built-in reports.
Quick reference
5Error codes, limits and cheat sheets to keep open.Power Automate
Power Automate interview questions (2026): answers, expressions and scenarios
Power Automate interview questions with answers you could give out loud, the reasoning behind them and the likely follow-up. Covers triggers, expressions, loops and limits, error handling, approvals, solutions, desktop flows, scenarios and 2026 changes.
Power Automate
Power Automate licensing explained: Premium, Process, and what Microsoft 365 includes
Which licence a flow actually runs under — the user's seed, Premium, or a Process licence on the flow itself — plus the RPA bot entitlements and the legacy plans to stop renewing.
Power Automate
Approval actions compared: start and wait, create plus wait, types, sequential and parallel
Which approval action and approval type to use, what each one waits for, what outputs you get, and the limits that trip people up: attachments, Markdown in Teams, the same approver twice, and flows stuck between create and wait.
Power Automate
Cloud flow error codes: what each one means and how to fix it
Every common Power Automate error, from 401 and 429 to ExpressionEvaluationFailed and FlowRunQuotaExceeded: what it means, how to confirm the cause in run history, the fix, and how to stop it happening again.
Power Automate
OData filter query cheat sheet for SharePoint, Dataverse and SQL Server
Copy-ready filter queries for Get items (SharePoint), List rows (Dataverse) and Get rows (SQL Server): operators, text, dates, lookups and choices, what each source doesn't support, and the errors that mean your syntax is off.