Mastering Microsoft Power Automate

Mastering Power Automate is an advanced course that provides the skills needed to design, develop, and optimise complex workflows using Microsoft Power Automate. Through structured modules and hands-on labs, learners will deepen their knowledge of expressions, JSON manipulation, Adaptive Cards, API integration, and advanced approval patterns. The course also covers performance tuning, secure flow practices, and integration strategies with Power Apps and Microsoft Graph API.

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

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

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