Mastering Microsoft Power Automate

Time: 10:30 - 17:30
The chosen training includes following dates:
When paid with Sovelto Access -credits, you will be charged the corresponding amount of credits to the Euro-price. Please contact sales: 020 7776 670 or for exact amount of credits in your case.

Register before
Spoken language: English

We are sorry, but the course is already full, please try with another date or location.

Or contact sales: +358 20 7776 670 or


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.


  • 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


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.


Places left:
No participant limit
1700,00  + VAT