Microsoft Power Automate Cheat Sheet

Updated 2026-05-17

Next Topic: Microsoft PowerPoint Cheat Sheet

🧠Study flashcards on this topic96 cards · spaced repetition→

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, 96 flashcards. 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

Quick IndexSubscribe to unlock

A jump-to index of every table row in this cheat sheet.

Mind MapSubscribe to unlock

An interactive map of every table and concept in this topic.

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.
When a row is added, modified or deleted	Dataverse trigger Custom table changes	• Dataverse-specific trigger that fires when records change • supports filtering by columns and scope (organization, business unit, user).
When a row is selected	Model-driven app action Selected records in view	• Enables users to select one or more records in a Dataverse view and trigger a flow • appears as an action button in model-driven apps
When an HTTP request is received	Webhook endpoint `POST https://...logic.azure.com/...`	• Creates a webhook URL that external services can call • supports JSON schema for request body validation and returns responses via Response action
HTTP Webhook trigger	Third-party webhook Subscribe/unsubscribe pattern	• Implements the webhook pattern with subscribe and unsubscribe callbacks • used for building custom webhook connectors

Table 2: Control Flow and Logic

Control flow actions determine the execution path of your automation — conditions create branching logic, loops iterate through collections, and switches handle multiple scenarios. Mastering these constructs allows you to build sophisticated workflows that adapt to different data states. Parallel branching enables concurrent execution, while scopes group actions for organization and error handling.

Action	Example	Description
Condition	`If Status equals 'Approved'` Then → Send email Else → Log rejection	• Evaluates an expression and executes If yes or If no branch • supports `and`, `or`, `empty`, `contains`, `equals`, `greater`, `less` operators

The rest of this section is part of the full cheat sheet

Table 3: Variables and Data Operations

Variables store intermediate values during flow execution, while data operations transform and manipulate arrays, JSON, and other structured data. Initialize variable must occur at the top level of a flow; subsequent actions modify stored values. Data operations like Compose, Select, and Filter array shape data without needing loops, improving performance and readability.

Action	Example	Description
Initialize variable	`Name: counter` `Type: Integer` `Value: 0`	• Creates a variable with specified type (String, Integer, Boolean, Array, Object, Float) and optional initial value • must be defined at flow's top level, not inside loops or conditions

The rest of this section is part of the full cheat sheet

Table 4: Expressions and Functions

Expressions enable dynamic calculations and text manipulation using a formula language similar to Excel functions. They appear in formula boxes throughout Power Automate actions and combine functions, dynamic content, and operators to transform data. Mastering common string, date, and logical functions eliminates the need for helper variables and external services.

Category	Example	Description
String functions	`concat('Hello ', 'World')` `substring('Power', 0, 3)` → `Pow` `replace(text, ' ', '_')`	String manipulation: `concat`, `substring`, `replace`, `split`, `toLower`, `toUpper`, `trim`, `startsWith`, `endsWith`, `indexOf`.

The rest of this section is part of the full cheat sheet

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.
When a row is added, modified or deleted	Dataverse trigger Custom table changes	• Dataverse-specific trigger that fires when records change • supports filtering by columns and scope (organization, business unit, user).
When a row is selected	Model-driven app action Selected records in view	• Enables users to select one or more records in a Dataverse view and trigger a flow • appears as an action button in model-driven apps
When an HTTP request is received	Webhook endpoint `POST https://...logic.azure.com/...`	• Creates a webhook URL that external services can call • supports JSON schema for request body validation and returns responses via Response action
HTTP Webhook trigger	Third-party webhook Subscribe/unsubscribe pattern	• Implements the webhook pattern with subscribe and unsubscribe callbacks • used for building custom webhook connectors

Table 2: Control Flow and Logic

Action	Example	Description
Condition	`If Status equals 'Approved'` Then → Send email Else → Log rejection	• Evaluates an expression and executes If yes or If no branch • supports `and`, `or`, `empty`, `contains`, `equals`, `greater`, `less` operators

Table 3: Variables and Data Operations

Action	Example	Description
Initialize variable	`Name: counter` `Type: Integer` `Value: 0`	• Creates a variable with specified type (String, Integer, Boolean, Array, Object, Float) and optional initial value • must be defined at flow's top level, not inside loops or conditions

Table 4: Expressions and Functions

Category	Example	Description
String functions	`concat('Hello ', 'World')` `substring('Power', 0, 3)` → `Pow` `replace(text, ' ', '_')`	String manipulation: `concat`, `substring`, `replace`, `split`, `toLower`, `toUpper`, `trim`, `startsWith`, `endsWith`, `indexOf`.