Power Automate Course - Intermediate

Learn to integrate and automate with Power Automate.

Courses running remotely - live online.

Microsoft's traditional office systems sit alongside a new wave of computing power within reach of end-users, in a way that has never been available before.  Power Automate is a key application within Microsoft 365 that allows end users to connect applications and automate workflows and processes.

Learn how to work with the building blocks of Power Automate to create custom flows for your workplace. You will learn to work with arrays, expressions, advanced functions and JSON data to implement logic to customise flows. This course is suitable for those who are already familiar with creating template flows in Power Automate. View our detailed course outline below. Microsoft Power Automate training is available in-person or remote. 

Power Automate Course - Intermediate

Automate workflows with Power Automate and start tapping into the Power Platform with this Intermediate course.

10 max
1 day

Hong Kong

Upcoming Courses:
Hong Kong
Fri 27 Sep 24
Power Automate Intermediate
Hong Kong
Status: Scheduled
Tue 19 Nov 24
Power Automate Intermediate
Hong Kong
Status: Scheduled
Taking enrollments.
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Power Automate Intermediate Course Details

1 day
9am - 4pm ( approx )
Class Size (max)
Class Size (avg)
Reference Materials
CPD Hours
6 hours
Instructor-led training
Live Online

Power Automate Course Outlines

  • Power Automate Beginner
  • Power Automate Intermediate
  • Power Automate Advanced
  • PL-900 Power Platform Certification
Course Rating
Power Automate Training Courses

4.72 5 Power Automate Training Courses
4.72 out of 5
71460 Student Reviews

Skills Test

Try our short skills test and find out which course is right for you.

skills test nexacu

 skills test


Contact Us

What do I need to know to attend?

Recommended for those currently building flows in Power Automate:

  • Students should have attended Power Automate Beginner.
  • Students should be comfortable with creating basic flows in Power Automate.
  • This course is aimed at those who want to build custom flows from scratch. 

Power Automate Intermediate Learning Outcomes

On completion of this course you will know how to:

  • Create String expressions
  • Handle errors and debug Power Automate flows
  • Use filtering queries
  • Understand how to work with Parent and Child flows


  • Understand how to use JSON in a flow
  • Create loops
  • Work with Arrays, Functions and Data and Time expressions
  • Save variables for re-use in other flows

Power Automate Intermediate Course Content

  • Introduction
  • The purpose of Power
  • Automate
  • What is a flow?
  • Instant Flows with User Input
  • Dynamic content
  • Data from the trigger
  • Accessing documentation
  • The ? operator
  • String Functions
  • Text function actions
  • Variables
  • Variable data types
  • JSON data
  • How to handle JSON data
  • Set variable
  • Increment / decrement variable
  • Append to string variable
  • Append to array variable
  • Date and Time Functions
  • Date time actions
  • Convert time zone
  • Add to a date
  • Using Filter Queries
  • OData filter queries
  • Basic OData expressions
  • Collection Functions
  • Use a collection functions
  • Loops
  • Loops in Power Automate
  • Apply to each
  • Do until
  • Create and use a Do until
  • loop in a flow
  • Data Operations
  • Compose
  • Join
  • Select
  • Filter array
  • Create CSV table
  • Create HTML table
  • Parse JSON
  • Use data operations
  • Current Iteration Index
  • Actions after a Loop
  • Do until limits
  • Successful completion of a Do
  • until loop
  • Delay a Flow
  • Delay
  • Delay Until
  • Add Comments
  • Adding comments to actions
  • Comments as a collaborative tool
  • Use Compose with Data Outputs
  • Adding actions to the flow
  • Use Compose to see data outputs and debug
  • Apply to Each and Concurrency
  • Concurrency controls for triggers
  • Concurrency controls for loops
  • Working with JSON Data
  • Accessing values from a JSON array
  • JSON arrays replacing multiple variables
  • Parse JSON action
  • Reshaping an array
  • Create an HTML table
  • Format an HTML table
  • Append to an Array
  • Use arrays to dynamically attach multiple files to an email
  • Parallel Branches
  • Error handling with parallel branches
  • Scopes
  • Use parallel branches to speed up flows
  • Joining parallel branches
  • Trigger a Flow from Another Flow
  • Solutions
  • Parent flows
  • Child flows

Contact Us

Why Nexacu? 

Valued by Individuals

4.72 / 5
Over 71460 Reviews

Trusted by Business

Awards and Accreditations

Follow us