Call us to get 30% off Python and R Programming courses. Book before 15 Sept 2023.

powerauto courses nexacu

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

powerauto courses nexacu

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
Wed 15 Nov 23
Power Automate Intermediate
Hong Kong
Status: Confirmed
Thu 14 Dec 23
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
Other Courses
Microsoft Power BI Training Courses
Microsoft Excel Training Courses
Microsoft Office 365 Training Courses
Excel Specialist Training Courses
Microsoft Project Training Courses
R Programming Training Courses
Python Training Courses
SQL Training Courses
Power Apps Training Courses
SharePoint Training Courses
Microsoft Teams Training Courses
Microsoft Visio Training Courses
Microsoft PowerPoint Training Courses
Microsoft Word Training Courses
Cloud Computing
Cybersecurity Training Courses
Adobe Training Courses
ChatGPT Training Courses
Other Courses
Course Rating
Power Automate Training Courses

4.72 5 Power Automate Training Courses
4.72 out of 5
60161 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 60161 Reviews

Trusted by Business

Awards and Accreditations

Follow us