| Approvals inside Teams and Outlook | Email chains and chasing | Native approval actions with audit trail | This is Power Automate at its strongest. Nothing else integrates with the tools staff already have open. |
| SharePoint document workflows | Manual filing and naming conventions | Triggered on upload or metadata change | Watch list size limits and view thresholds on large libraries, they bite at scale. |
| On-premises system with no cloud API | Manual re-keying | On-premises data gateway, premium licence | Works well, but budget the premium licence and a server for the gateway from the start. |
| Desktop automation of a legacy application | A person clicking through screens | Power Automate Desktop, attended or unattended | Unattended running needs a Power Automate Process licence and a registered machine that stays powered on and reachable. Fragile if the vendor changes their UI. |
| Structured business records with permissions | Sprawling spreadsheets or SharePoint lists | Dataverse tables with row level security | The right tool, and a licensing and capacity commitment. Decide deliberately. |
| Calling an arbitrary third party REST API | Blocked without developer help | HTTP action or custom connector, premium | Entirely possible, but this is where the free assumption dies. Price it before you design it. |
| High volume per-line processing | Batch scripts nobody maintains | Possible, needs careful throttling design | Execution-metered platforms are often cheaper and simpler for heavy loops. We will say so if that is the case. |
| Business runs on Google Workspace | Mixed tooling | Usually the wrong choice | Without the Microsoft identity and governance advantage, Power Automate loses its main reason for existing. |