Microsoft Power Automate (Flow) Course

Lesson 1 • Flow Types and Use Cases

Distinguishes cloud flows, desktop flows, and business process flows. Maps each type to real workplace scenarios.

Lesson 2 • Licensing and Access Tiers

Explains licensing plans, per-user vs. per-flow models, and feature availability. Helps learners identify what is accessible in their environment.

Lesson 3 • What Is Power Automate

Defines Power Automate, its role in the Microsoft 365 ecosystem, and core automation concepts. Establishes vocabulary used throughout the course.

Lesson 1 • Using Dynamic Content

Introduces dynamic content tokens that pass data between steps. Enables flows to respond to real input rather than static values.

Lesson 2 • Adding and Configuring Actions

Teaches how to add sequential actions, configure parameters, and chain steps logically. Directly follows trigger setup to complete a basic flow.

Lesson 3 • Using Templates to Accelerate Creation

Shows how to find, customise, and deploy pre-built templates. Reduces build time and reinforces flow structure learned earlier.

Lesson 4 • Testing and Running Flows

Demonstrates how to manually test flows, review run history, and interpret results. Establishes a test-first habit before deploying automation.

Lesson 1 • Key Microsoft Service Connectors

Explores connectors for SharePoint, Outlook, Teams, and OneDrive in practical scenarios. Builds the most commonly used integration skills.

Lesson 2 • Standard vs. Premium Connectors

Differentiates connector tiers, associated licensing requirements, and availability. Sets expectations for what integrations are possible per plan.

Lesson 3 • Building Custom Connectors

Teaches how to create a custom connector from an OpenAPI definition or Postman collection. Enables integration with any REST API not in the catalog.

Lesson 4 • Authenticating and Managing Connections

Covers OAuth, API key, and service account authentication methods. Ensures learners can create and share connections securely.

Lesson 1 • Parallel Branches and Performance

Demonstrates running actions simultaneously using parallel branches. Reduces total flow execution time for independent tasks.

Lesson 2 • Switch and Multi-Branch Logic

Covers the Switch action for handling multiple discrete values cleanly. Reduces nested condition sprawl in complex flows.

Lesson 3 • Apply to Each and Loops

Teaches the Apply to Each loop for processing arrays and the Do Until loop for repetition. Enables batch processing of lists and collections.

Lesson 4 • Scope and Error Handling

Introduces the Scope action and run-after settings to manage errors gracefully. Prevents entire flows from failing due to a single step error.

Lesson 1 • Array and Collection Functions

Explores functions for creating, filtering, and transforming arrays. Supports the loop and batch processing patterns from the previous chapter.

Lesson 2 • Numeric and Logical Functions

Teaches arithmetic, rounding, and logical functions such as if, and, and or. Enables calculated fields and conditional value assignment.

Lesson 3 • JSON Parsing and Variables

Covers Parse JSON action, variable initialisation, and data type management. Enables flows to consume and produce structured data reliably.

Lesson 4 • String and Date Functions

Covers functions for manipulating text and formatting dates. Addresses the most frequent data transformation needs in business flows.

Lesson 1 • Approval Outcome Routing

Routes flow execution based on approval outcomes using conditions and expressions. Connects approval decisions to downstream business actions.

Lesson 2 • Approval Action Fundamentals

Introduces the Approvals connector, approval types, and response handling. Establishes the building block for all approval patterns in this chapter.

Lesson 3 • Approval Center and Tracking

Demonstrates the Approvals hub for monitoring pending and completed requests. Gives learners visibility into approval pipeline status.

Lesson 4 • Sequential and Parallel Approvals

Builds multi-approver flows using sequential chains and parallel everyone-must-approve patterns. Covers the most common enterprise approval structures.

Lesson 1 • Variables and Flow Control in Desktop

Applies variables, loops, and conditionals within the desktop flow designer. Mirrors cloud flow logic concepts in the RPA context.

Lesson 2 • UI Element and Selector Management

Teaches how to identify, capture, and maintain UI selectors for reliable automation. Addresses the most common cause of RPA flow failures.

Lesson 3 • Power Automate Desktop Overview

Introduces the desktop application, its interface, and how it differs from cloud flows. Prepares learners for the RPA-specific concepts ahead.

Lesson 4 • Triggering Desktop Flows from Cloud

Connects cloud flows to desktop flows for end-to-end hybrid automation. Enables orchestration of RPA tasks from cloud-based triggers.

Lesson 1 • Exporting and Importing Flows

Teaches package export, solution import, and environment migration procedures. Supports promotion of flows from development to production.

Lesson 2 • Data Loss Prevention Policies

Covers DLP policy creation, connector classification, and policy enforcement. Protects sensitive data from unauthorised connector combinations.

Lesson 3 • Environments and Solutions

Explains environment types, their purposes, and how solutions package flows for deployment. Establishes the governance structure for all subsequent topics.

Lesson 4 • Monitoring, Analytics, and Auditing

Uses the admin centre, Power Platform analytics, and audit logs to monitor flow health. Gives administrators the visibility needed to maintain reliability.