The aim of this course is to provide you with the knowledge to work with more advanced topics of Microsoft Power Automate (previously known as Flow). The course will emphasise hands-on experience, with a series of self-guided exercises integrated into the training.

You will discover how to create more complex Flows to automate and manage business processes.


Before attending this course, learners should have:

  • A basic understanding of Windows 7 or later versions
  • Experience using Internet Explorer or equivalent browser
  • A general knowledge of using Office 365
  • Have attended QA’s Power Automate Essentials course, or have equivalent knowledge
  • Some basic programming knowledge is useful, but not essential
  • General knowledge of HTML and CSS would also be useful, but again is not essential

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

Delegates will learn how to

  • Understand and work with expressions
  • Work with Team Flows
  • Work with Switch Case, Variables, Apply To Each and Do Until features
  • Use manual and scheduled triggers
  • Use Do Until and Reuse Flows


Module 1 – Understanding Expressions

  • Operators
  • Functions
  • Creating a Hyperlink with Expressions
  • Names and Comments

Module 2 – Team Flows

  • Team Flow Features
  • Adding Individual Users as Co-Owners to a Team Flow
  • Removing an Individual Co-Owner
  • Adding a SharePoint List or Library as an Owner
  • Removing a SharePoint List as a Co-Owner

Module 3 – Adding a Switch Case

  • Understanding the Switch Case
  • Using the Switch case

Module 4 – Working with Variables

  • Initialising Variables
  • Updating Variables
  • Increment and Decrement Variables
  • Creating Email Variables

Module 5 – Add an Apply to Each

  • Creating the SharePoint Lists
  • Creating a For Each Flow
  • Limitations to Get Items Actions
  • Add the Apply to Each Step

Module 6 – Triggering a Flow from PowerApps Form

  • Creating the Relevant Apps in SharePoint
  • Creating a PowerApp Flow
  • Creating the PowerApp List Form
  • Configuring the PowerApp Form
  • Adding a Button to Run the Flow
  • Saving and Publishing the PowerApp Form

Module 7– The Flow Mobile App

  • Installing the Flow App
  • The Flow App Interface
  • Creating New Flows
  • Modifying an Existing Flow in the Mobile App
  • Creating a Button Flow

Module 8 – Scheduled Flows

  • Using the Schedule Recurrence Trigger
  • Manually Testing a Flow
  • Other Scheduling Actions

Module 9 – Using Data Operations

  • What are Data Operation Actions?
  • Storing a Data Array
  • Filtering Data
  • Outputting Data

Module 10 – Using Do Until

  • Setting Up a Do Until Loop
  • Creating a Flow using Do Loop Actions
  • Creating the Onboarding List
  • Creating the Do Loop Flow
  • Adding Email Actions to the Do Until Controls

Module 11 – Saving and Reusing Flows

  • Saving a Flow
  • Reusing a Flow
  • Creating an Exportable Zip Package
  • Importing a Zip Package
  • Creating an Exportable JSON Package
  • Creating a Flow Template

Microsoft 365 Learning Pathways

This course features in the following learning path:

= Required
= Certification
Technical Decision Maker
Office 365 General Administration
Exchange Online/Hybrid
SharePoint Online/Hybrid
Device Management, Identity and Services
Security and Compliance
Modern Desktop
Power Platform
Office 365 Development
Microsoft Teams
Key for bundle contents
= Exam Preparation
= Exam
= Practice Exam
= Exam Voucher
= Tutor Support
= Pre Course Work
*This is based on QA research



Microsoft Official Course (MOC)


QA Authored


QA Authored