Microsoft Power Automate Tutorial
Learn Microsoft Power Automate step by step: 38 lessons in 9 chapters with examples, quizzes, diagrams and projects.
Start learning →
of lessons completed
Getting Started
- What Is Microsoft Power Automate? Flows, Triggers and Actions Learn what Microsoft Power Automate does, how a flow is built from a trigger and actions, what the product family includes, and when to automate a task.
- Power Automate Flow Types and Licensing Explained Compare automated, instant, scheduled, desktop and business process flows, and understand seeded versus premium licensing, limits and how to plan costs.
- Your First Power Automate Cloud Flow, Step by Step Create your first cloud flow from a blank canvas: pick a trigger, add actions, use dynamic content, save and run it, with a stand-in that simulates the steps.
- Power Automate Designer, Testing and Run History Find your way around the flow designer, test with manual or automatic runs, read run history and outputs, resubmit runs, and troubleshoot failed flows.
- Power Automate Environments, Solutions and the Maker Portal Understand environments, solutions, publishers, My flows versus Solutions, sharing and ownership, and how to move flows from development to production.
Flows and Triggers
- Automated Cloud Flows and How Triggers Work Learn how automated cloud flow triggers fire, the difference between polling and webhook triggers, common triggers for email, files and lists, and trigger settings.
- Instant Flows: Manual Triggers, Buttons and Inputs Build instant cloud flows with the manually trigger a flow trigger, define text, file and yes/no inputs, run them from the mobile app, Teams and SharePoint, and respond.
- Scheduled Flows: The Recurrence Trigger and Time Zones Create scheduled cloud flows with the Recurrence trigger: intervals, frequencies, start times, time zones, weekdays and hours, delay actions and common timing pitfalls.
- Trigger Conditions, Filter Queries and Reducing Runs Stop unwanted flow runs with trigger conditions, OData filter queries and connector filters, write conditions with equals, and, or and not, and test them safely.
- HTTP Request Triggers, Webhooks and the Response Action Turn a flow into an API with the When an HTTP request is received trigger: JSON schema, methods, the callback URL, Response action, security options and testing.
Actions and Expressions
- Actions and Dynamic Content in Power Automate Understand what actions are, how inputs and outputs work, how dynamic content links steps, how to find the right action, and how built-in actions like Compose and Condition fit in.
- Power Automate Expressions: Your First Functions Learn the Power Automate expression language: where to type expressions, functions, the at-sign syntax, logic and comparison functions, if, coalesce and safe access with question marks.
- Variables and Compose Actions in Power Automate Use Initialize variable, Set, Increment, Append to array and Append to string variables, understand when to prefer Compose, and avoid variable limits inside loops.
- Text, Dates and Time Zones in Power Automate Expressions Work with strings and dates in flows: concat, substring, replace, split, formatDateTime, addDays, convertTimeZone, utcNow and format strings, with runnable stand-ins.
- Arrays, Objects and JSON: Select, Filter array and Parse JSON Handle lists and JSON in flows: Apply to each, Select, Filter array, Join, Create HTML table, Parse JSON, item() and first(), with runnable stand-ins.
Connectors and Data
- Power Automate Connectors: Standard, Premium and Custom Learn what connectors are, how triggers and actions are grouped, the difference between standard, premium and custom connectors, and how to choose and find the right one.
- Connections, Authentication and Connection References Understand connections, whose identity a flow uses, OAuth versus API keys, run-only permissions, service accounts, connection references and what breaks when owners leave.
- SharePoint Lists and Excel Tables in Power Automate Read and write SharePoint list items and Excel Online tables from flows: Get items, filter queries, Create item, Update item, column types, Excel limits and patterns.
- Dataverse in Power Automate: Tables, Rows and OData Queries Use the Dataverse connector: list rows with filter, select and expand, add and update rows, relationships and lookups, row triggers, alternate keys and paging.
- Calling REST APIs with the HTTP Action in Power Automate Call any REST API from a flow with the HTTP action: methods, headers, bodies, authentication, Parse JSON, paging, retries and status codes, with runnable stand-ins.
Approvals and Control Flow
- Approvals: Asking People to Decide Add human decisions to a flow with the Approvals connector: approval types, assigning approvers, reading the outcome and responses, reminders, and what happens on timeout.
- Conditions and Switch: Branching a Flow Branch a flow with the Condition and Switch actions: basic and advanced mode, AND and OR groups, comparing text safely, empty values, and when Switch beats nested conditions.
- Apply to Each: Looping Over Lists Process every item in a list with Apply to each: the current item, nested loops, concurrency control, the variable traps, and faster loop-free options like Filter array and Select.
- Do Until, Scope, Parallel Branches and Terminate Control the shape of a run: Do until loops with count and timeout limits, Scope to group actions, parallel branches, Delay, and the Terminate action with Succeeded, Failed and Cancelled.
Desktop Flows
- Power Automate Desktop and Desktop Flows Meet Power Automate for desktop: what a desktop flow is, how it differs from a cloud flow, the designer layout, subflows, and when robotic process automation is the right tool.
- Recorders, UI Elements and Selectors Record clicks and typing into a desktop flow, capture UI elements, and make selectors robust so the flow keeps working when a window changes. Includes a selector-matching stand-in.
- Variables, Excel and Files in Desktop Flows Work with desktop flow data: variable types, the percent syntax, lists, data tables and rows, reading and writing Excel and text files, and looping over files and rows.
- Attended, Unattended and Cloud-Triggered Desktop Flows Run desktop flows from the cloud: attended and unattended modes, the machine runtime and connections, passing inputs and outputs, sessions, queues of work, and licensing questions.
Error Handling
- Run After and Try/Catch/Finally in Flows Handle failures on purpose: configure run after for succeeded, failed, skipped and timed-out actions, build try, catch and finally scopes, and read errors with the result function.
- Retry Policies, Timeouts and Throttling Make flows resilient to temporary errors: the default retry policy, fixed and exponential intervals, which status codes are retried, action timeouts, HTTP limits and throttling.
- Monitoring and Troubleshooting Flows Find out why a flow failed: reading run history, inspecting inputs and outputs, common errors by status code, expression mistakes, resubmitting runs, and keeping watch with alerts and analytics.
Governance and Patterns
- Environments, Solutions and Moving Flows Safely Organize and ship flows professionally: environment types, solutions as containers, connection references, environment variables, managed versus unmanaged, and dev to production deployment.
- Data Loss Prevention and Governance Understand how admins keep automation safe: DLP policies with Business, Non-business and Blocked connector groups, why a flow gets suspended, security practices, and a lightweight governance model.
- Flow Patterns That Scale: Child Flows, Pagination, Idempotency Reusable designs for solid flows: child flows, trigger conditions, trigger concurrency, pagination and server-side filtering, idempotent processing, batching, configuration and logging.
- Limits, Licensing and Performance Plan flows that fit the platform: run duration, action and request limits, throttling, standard versus premium connectors, license types, and practical tips for faster, cheaper flows.
Projects and Practice
- Project: An Expense Approval Process Design and build a complete expense approval flow: form trigger, validation, routing by amount, approvals with escalation, error handling and logging, with a runnable model of the rules.
- Project: Invoices from Email to a Desktop Application Combine a cloud flow and a desktop flow: collect invoice emails, extract fields, validate and de-duplicate them, enter them in a legacy application with RPA, and report exceptions.
- Practice Scenarios and Design Exercises Test your Power Automate design skills with eight realistic scenarios on approvals, loops, desktop flows, error handling and governance, each with hints and a model answer outline.