Mastering Microsoft Power Automate 2026: From Zero to Hero

Explore licensing requirements for Power Automate, compare cloud flows and desktop flows, and understand standard vs premium connectors, plan options, and pay-as-you-go pricing.

Explain the update to the Microsoft 365 developer program, noting free licenses are unlikely and recommend the Microsoft 365 Business Basic plan for Power Automate.

Set up your own Microsoft 365 developer tenant to explore Power Automate, gain 25 E5 licenses, and practice admin tasks with sample data and multi-factor authentication.

Explore the Power Automate portal, learning to use Copilot to generate flows from templates, navigate my flows and templates, approvals, solutions, and the AI hub, and manage environments and settings.

Explore the new Power Automate UI and compare it with the old UI. Learn to build an instant cloud flow, add a trigger, and connect a SharePoint create item action.

Build your first flow in power automate with a template to save office 365 email attachments to a OneDrive for business folder, using a trigger and apply to each attachment.

Learn how connectors in Power Automate bridge flows to data sources with over 900 connectors, including standard, premium, and custom connectors, plus on-premises gateways and secure connections.

Explore the types of flows in Power Automate, including automated, instant, scheduled, and desktop flows. Learn about triggers like new form responses, SharePoint items, and RSS feed events.

Master triggers and actions in automated cloud flows by building a SharePoint item watcher, creating a customers list, and testing triggers with actions like compose, Excel Online, and Teams.

Using the provided zip resource and Power Automate solution, set up SharePoint sites and lists, import the orchestration of flows, and verify creation via a confirmation email with links.

Build your first flow from scratch in Power Automate to automatically create a SharePoint item when an item is created, then create and update a Planner task.

Edit and optimize an existing flow by switching to the new designer, configuring split on for per-item runs, and updating planner tasks with dynamic data from SharePoint triggers.

Configure a flow to post to the US sales team's general channel when a new customer is added to the SharePoint list, using the flow bot and Planner.

Learn to create an instant cloud flow in Power Automate with input parameters like text, date, email, and number, and test them via a compose action.

Explore how expressions in Power Automate transform data and power dynamic flows, using functions like concat, UTC now, date difference, and rand to build flexible, condition-driven actions.

Explore how to debug flows in Power Automate by examining run history, identifying a failed action, and reading error details such as the invalid template in the date difference action.

Explore how to implement error handling in Power Automate by using run after conditions, handling inputs, and configuring actions to run on success, skip, fail, or timeout.

Learn how to use for each loops in Power Automate to process a SharePoint employees list, compare lookup and text department fields, and apply concurrency control for parallel processing.

Learn to use conditions in Power Automate to filter employees by department, location, and skills, combine rules with and/or groups, and handle common flow logging and save warnings.

Use Power Automate with SharePoint and Planner to automate new customer tasks from templates, track status (new, in-progress, completed), and email updates in real time.

Learn to use variables in Power Automate: initialize with a data type, assign values, and build expressions for calculations and decisions, illustrated by accumulating emails.

Master Power Automate variables by initializing an integer counter, incrementing it in a loop, and displaying the result with a compose action in a SharePoint task flow.

Learn to initialize and build a string variable of emails from a SharePoint employees list in a Power Automate flow, filter by Zurich, append, and compose the final result.

Master integer variables in a Power Automate flow that updates stock in a SharePoint asset management list when an order from the orders list is completed.

Master float variables in Power Automate to calculate average order value for completed orders by looping items, retrieving price per unit from the asset list, and multiplying quantity by price.

Explore how boolean values (true or false) drive stock availability in a Power Automate flow by evaluating stock, orders, and processing status on SharePoint asset lists to set availability.

Explore arrays and objects in Power Automate, using bookshelves and keys to organize data, explain how arrays hold items and objects store key-value pairs.

Discover how JSON (JavaScript Object Notation) enables lightweight, language-independent data exchange between servers and Power Automate connectors, with objects, arrays, and nested data examples.

Create a SharePoint list from blank, design city columns (city name, state id, state name, population), and populate items using Power Automate with an Excel file on OneDrive.

Use Power Automate to bulk create SharePoint city items from Excel Online tables, pulling rows, mapping fields, with pagination and 50 parallel iterations for speed.

Learn how OData, the open data protocol, standardizes querying RESTful APIs and enables server-side filtering, field selection, and ordering across data sources in Power Automate.

Learn to filter a cities list with an OData query in Power Automate, then update items to fill the state ID for all matching Oklahoma records, showcasing efficient get items.

Learn how item limit threshold and pagination work in Power Automate, using a 1199-item list, showing how to enable pagination, set a threshold, and fetch all pages.

Power Automate integrates with Microsoft Forms and Excel to automate onboarding feedback collection, notify the employee's manager via Teams, and log responses to an Excel file with parallel execution.

Learn to manage documents with Power Automate by building an instant flow that aggregates monthly sales from a SharePoint list, updates an Excel table, converts to PDF, and emails it.

Launch a monthly Power Automate flow to pull February sales from the SharePoint list, update the dashboard.xlsx data table, and email the dashboard attachment to the manager.

Learn to build a condition in the control connector, using SharePoint get items to route flows by true/false branches with nested groups and data checks like office location Paris.

Master the for each loop in Power Automate to apply identical actions to every item in a collection, using get items, update item, and real-world examples.

Master do until action and how it loops until a condition is met. Build a flow that creates, updates, and emails a file, then delays and retries delete until success.

Learn the scope control action to containerize flow steps and improve readability by grouping file creation, conversion, email, and deletion inside scopes, including nested scopes.

Explore how to replace nested conditions with a switch statement in Power Automate, evaluating task priority (urgent, important, medium, low) and routing actions like sending emails.

Explore the terminate action in Power Automate by ending a flow when a new item in the employees list belongs to the IT department, with statuses canceled, failed, or succeeded.

Use the data operations connector and compose actions in Power Automate, building an instant cloud flow to replace text, extract URLs with index and length, and select first array item.

Create a csv table in Power Automate by building an instant cloud flow, retrieving items, filtering by office location, choosing automatic or custom columns, and saving the result to OneDrive.

Learn to create an HTML table in Power Automate using the HTML table action, configure custom columns from the body value, and email the formatted table.

Master the filter array action in Power Automate to filter SharePoint data beyond OData queries, build HTML tables, and optimize flows with parallel branches.

Learn to use the join and select actions in Power Automate to transform arrays and objects into readable strings, including formatting first and last names into a single display name.

Explore how the parse json action converts a json string into an array of objects, generates a schema from a sample payload, and enables dynamic field access in flows.

Master Power Automate to consolidate unbilled transactions into client invoices. Group by client, populate line items from an Excel template on SharePoint, and update metadata with invoice numbers.

Learn how approvals in Power Automate streamline requests, using create and start-and-wait actions to automate decisions, with a centralized view in the portal and Teams app to reduce manual intervention.

Create approvals in power automate, configure approval types and custom responses, and start and wait for an approval to capture outcomes for flow branching.

Learn to use trigger conditions in Power Automate to run flows only when specific SharePoint fields, like has car license, are true or false, with tests and expressions.

Extend approvals beyond 30 days with a SharePoint Power Automate flow that starts on new documents and updates the approval history, looping on timeout until a decision is reached.

Explore adaptive cards, a JSON-based format for interactive content across Microsoft Teams, Outlook, and mobile apps, and learn to build cards with buttons, input forms, and actions in Power Automate.

Create an instant cloud flow that sends an adaptive card via Microsoft Teams, collects activity choices and comments, and stores results in a SharePoint Adventure Quest registration list.

Develop a dynamic project creation workflow using SharePoint requests and adaptive cards in Teams, enabling approvals and project number input with automatic card updates and a 29-day restart.