25,000+ Courses Nationwide
0345 4506120

Mastering Microsoft Power Automate

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.

Select specific date to see price, venue and full details.

Learning Objectives

  • 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


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 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.

Course Content

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

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.


We work with the best