Mastering Microsoft Power Automate Training

Important - This course has MFA Requirements. Please read this link and download the MFA app, prior to attending.

Before attending this course, learners should have:

• Completed the QA course Power Automate Essentials or have equivalent experience
• At least 2–3 months’ experience with Power Automate
• Competency in creating basic flows, using triggers, actions, and connectors
• Awareness of Power Automate licensing, including Premium connectors and developer environments

Please Note: If you attend a course and do not meet the prerequisites you may be asked to leave.

Target audience

This course is intended for:

• IT professionals and developers responsible for automation within Microsoft 365
• Power users managing business workflows
• Solution architects and consultants integrating Power Automate with broader systems
• Individuals seeking advanced knowledge in enterprise-grade automation techniques

By the end of this course, learners will be able to:

• Write advanced expressions using Power Automate's expression language
• Transform and process structured data using built-in data operation actions
• Design and send Adaptive Cards via Microsoft Teams for dynamic messaging
• Optimise flow performance using OData queries and pagination
• Build complex, multi-step approval workflows with reminders and conditional logic
• Integrate flows with Power Apps for interactive, bi-directional data exchange
• Apply error handling techniques using try/catch/finally patterns
• Develop modular flows using HTTP-based parent-child architecture
• Use Microsoft Graph API for accessing Microsoft 365 services beyond default connectors

Core concepts and assumptions

• Review of environments and licensing
• Introduction to dynamic content and expressions
• Trigger and action referencing using safe navigation

Functions and expressions

• Use cases and syntax of expressions
• Combining expressions and variables
• Applying functions to control flow and manipulate data

Transforming data with Data Operation actions

• Working with JSON and the Parse JSON action
• Filtering, mapping, and restructuring data
• Generating emails using HTML and CSS-formatted tables

Adaptive Cards

• Designing Adaptive Cards with placeholders
• Using JSON payloads within Microsoft Teams
• Posting dynamic cards via the Flow bot

Advanced control properties and optimisation

• Applying Run After settings for branching logic
• Using OData queries and enabling pagination
• Configuring trigger conditions and securing sensitive data

Approval automation

• Majority and sequential approval flows
• Adding reminders
• Logging approvals and controlling the approval process

Integration with Power Apps

• Passing parameters between apps and flows
• Capturing and displaying returned data

Handling errors

• Designing flows with Try, Catch, and Finally scopes
• Diagnosing and debugging failure points
• Best practices for error tracking and remediation

Parent and child flows

• Creating reusable flows using HTTP actions
• Creating reusable flows using solutions

Using the Microsoft Graph API

• App registration and permission configuration
• Creating flows using Graph endpoints
• Comparing Graph API access with Office 365 connectors