Microsoft Power Automate Cheat Sheet

Updated 2026-05-17

Next Topic: Microsoft PowerPoint Cheat Sheet

Microsoft Power Automate is a cloud-based automation platform within the Microsoft Power Platform ecosystem that enables users to create automated workflows connecting apps, data, and services. It combines cloud flows for API-driven automation with desktop flows for robotic process automation (RPA), allowing organizations to automate repetitive tasks without extensive coding. Power Automate integrates deeply with Microsoft 365, SharePoint, Dynamics 365, and Dataverse, while also supporting hundreds of third-party connectors. Understanding trigger types (automated, instant, scheduled), control flow logic (conditions, loops, parallel branches), and licensing tiers (standard vs premium connectors) is essential for building efficient, scalable automations that reduce manual work and increase productivity.

What This Cheat Sheet Covers

This topic spans 14 focused tables and 128 indexed concepts. Below is a complete table-by-table outline of this topic, spanning foundational concepts through advanced details.

Table 1: Flow Types and TriggersTable 2: Control Flow and LogicTable 3: Variables and Data OperationsTable 4: Expressions and FunctionsTable 5: Connectors and ActionsTable 6: Approval WorkflowsTable 7: Error Handling and DebuggingTable 8: Desktop Flows (RPA)Table 9: Advanced Flow PatternsTable 10: SharePoint IntegrationTable 11: Microsoft 365 IntegrationTable 12: Solutions and ALMTable 13: Licensing and LimitsTable 14: Best Practices and Optimization

Table 1: Flow Types and Triggers

Power Automate offers three primary flow types distinguished by how they start: automated flows respond to events, instant flows require manual activation, and scheduled flows run on a timer. Each trigger type serves different automation scenarios — automated for event-driven processes, instant for on-demand tasks, and scheduled for recurring operations. Choosing the correct trigger ensures your flow activates exactly when needed.

Type	Example	Description
Automated cloud flow	`When an item is created (SharePoint)` `When a new email arrives (Outlook)`	• Triggered automatically by an event in a connected service • runs without user interaction when the specified condition occurs
Instant cloud flow	`Manually trigger a flow` `For a selected item`	• Started manually by a user through a button in Power Automate mobile app, Power Apps, SharePoint, or Microsoft 365 • also called button flows.
Scheduled cloud flow	`Recurrence: Daily at 9 AM` `Every Monday at 8:00 AM`	• Runs on a fixed schedule defined by recurrence trigger • supports intervals from seconds to months with time zone configuration
Desktop flow	UI automation recording Web scraping actions	Robotic process automation (RPA) that automates repetitive tasks on Windows desktop applications using UI element interaction or image recognition.

Table 1: Flow Types and Triggers

Type	Example	Description
Automated cloud flow	`When an item is created (SharePoint)` `When a new email arrives (Outlook)`	• Triggered automatically by an event in a connected service • runs without user interaction when the specified condition occurs
Instant cloud flow	`Manually trigger a flow` `For a selected item`	• Started manually by a user through a button in Power Automate mobile app, Power Apps, SharePoint, or Microsoft 365 • also called button flows.
Scheduled cloud flow	`Recurrence: Daily at 9 AM` `Every Monday at 8:00 AM`	• Runs on a fixed schedule defined by recurrence trigger • supports intervals from seconds to months with time zone configuration
Desktop flow	UI automation recording Web scraping actions	Robotic process automation (RPA) that automates repetitive tasks on Windows desktop applications using UI element interaction or image recognition.