Select your country to view prices and course dates.

x

Recent Searches
Category

Microsoft Copilot Courses

Category

Microsoft Power BI

Category

AI for Business

Category

Microsoft Excel

Category

Professional Development

Category

Microsoft Office 365

Category

Excel Specialist

Category

Microsoft Project

Category

R Programming

Category

Python

Category

SQL

Category

Power Apps

Category

SharePoint

Category

Power Automate

Category

Microsoft Teams

Category

Microsoft Visio

Category

Microsoft PowerPoint

Category

Microsoft Word

Category

Microsoft Outlook

Category

Adobe InDesign Courses

Category

Adobe Photoshop Courses

Category

Adobe Illustrator Courses

Category

Adobe Premiere Pro Training

Category

Adobe After Effects Training

Category

Adobe Acrobat Courses

Category

Adobe Captivate Training

Category

Adobe Animate Training

Category

HTML Courses

Category

WordPress

Category

Canva Courses

Category

Microsoft Access

Category

Webinars

Course

Copilot for M365

Course

Power BI Beginner

Course

ChatGPT Beginner

Course

Excel Beginner

Course

Achieving Leadership & Success

Course

Microsoft 365 Beginner

Course

Financial Modelling

Course

Project Beginner

Course

R Programming Beginner

Course

Python Beginner

Course

SQL Beginner

Course

Power Apps Beginner

Course

SharePoint Beginner

Course

Teams Essentials

Course

Visio Essentials

Course

PowerPoint Level 1

Course

Word Beginner

Course

Microsoft Outlook Beginner

Course

InDesign Lite

Course

Photoshop Training Intro

Course

Illustrator Training Intro

Course

Premiere Training Intro

Course

After Effects Training Intro

Course

Acrobat Essentials

Course

Captivate Training

Course

Animate Training Intro

Course

HTML Training Intro

Course

WordPress Essentials

Course

Canva Beginners

Course

Microsoft Access Essentials

Course

Copilot for Word

Course

Power BI Intermediate

Course

Excel Intermediate

Course

Microsoft 365 Intermediate

Course

Analysis and Dashboards

Course

Project Intermediate

Course

R Programming Intermediate

Course

Python Intermediate

Course

SQL Intermediate

Course

Power Apps Intermediate

Course

SharePoint Intermediate

Course

PowerPoint Level 2

Course

Word Intermediate

Course

InDesign Training Intro

Course

Photoshop Lite

Course

Illustrator Training Advanced

Course

Premiere Basics Training

Course

Acrobat Forms

Course

Canva Intermediate

Course

Microsoft Access Advanced

Course

Copilot for Excel

Course

Power BI Advanced

Course

Excel Advanced

Course

Microsoft 365 Advanced

Course

Excel VBA

Course

Project Advanced

Course

R Programming Advanced

Course

Python Advanced

Course

SQL Advanced

Course

Power Apps Advanced

Course

SharePoint Advanced (Site Owner)

Course

Word Advanced

Course

InDesign Training Advanced

Course

Photoshop Training Advanced

Course

Advanced Premiere Training

Course

Advanced After Effects Training

Course

Canva Advanced

Course

Copilot for PowerPoint

Course

Power BI DAX

Course

Excel Expert

Course

Machine Learning in R

Course

SharePoint Advanced (Document Governance)

Course

InDesign Interactivity Training

Course

Copilot for Outlook and Teams

Course

InDesign Accessibility Training

Course

Power Automate Beginner

Course

Power Automate Intermediate

Course

Microsoft Outlook Advanced

Course

AI Prompting Fundamentals

Course

Power Automate Advanced

Course

Excel Tables and Pivot Tables

Course

Data Transformation with Power Query

Course

Excel Macro Mastery

Course

Power BI Desktop Advanced Reporting

Course

AI for Business Leaders and Managers

Course

Data Visualisation with Power BI Desktop

Course

Anger Management & Negotiation Skills

Course

Assertiveness & Confidence

Course

Building Resilience

Course

Coaching and Mentoring

Course

Communications

Course

Communications & Quality Client Service Training

Course

Critical Thinking and Problem Solving

Course

Cultural Diversity in the Workplace

Course

Embracing Change

Course

Growing Emotional Intelligence

Course

Minute Taking

Course

Persuasion and Negotiation Skills

Course

Presentation Skills and Public Speaking

Course

Practical Project Management

Course

Respect, Equity and Diversity (RED)

Course

Resumé Writing and Interview Skills

Course

Stress Management

Course

Team Leadership, Management and Development

Course

Time Management Intensive

Course

Train the Trainer

Course

Write Effective Business Documents

Course

Dealing with Difficult People

Course

Managing Difficult Conversations

Course

Managing the Virtual Workplace

All courses are available in-person or remotely. 

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

By the end of this course, you will be able to:

  • Create string expressions and use filtering queries
  • Handle errors and debug flows effectively
  • Work with JSON, arrays, loops and advanced functions
  • Use parent and child flows and manage reusable variables

Prerequisite:

Recommended for users already building flows in Power Automate. You should have completed the Power Automate Beginner course and be confident creating basic flows.

Upcoming Courses

Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Power Automate Training Courses

Course Icon Power Automate Beginner

Learn to automate workflows with Power Automate and boost efficiency. Start creating flows and explore the power of automation.

download course pdf
PL-900 Power Platform Certification

Become a Microsoft Certified in Power Platform Fundamentals. Attend Nexacu Power Apps, Power BI and Power Automate courses, sit the PL-900 exam and earn your Microsoft Certification.

Price: 

$ 3,600
inc GST

Power Automate Intermediate Course Content

Expand All | Collapse All

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

Frequently Asked Questions

What is Power Automate?

Power Automate is a Microsoft application which allows the non-technical user to connect different applications and drive actions. Using its vast library of templates, you can quickly create automated processes to take care of mundane tasks and free you up to focus on higher value-add opportunities. 

What is Remote Training?

Remote training at Nexacu, means our team of experienced trainers will deliver your training virtually. Students can access our usual classroom training courses via video conferencing, ask questions, participate in discussion and share their screen with the trainer if they need help at any point in the course. Students have the same level of participation and access to the trainer as they would in classroom training sessions. 

What can I do to prepare for my online course?

Install the Microsoft Teams desktop application. This can be done through the Microsoft website. 

For the Power Automate Advanced course, ensure you have the latest version of Power Automate Desktop installed.

To access your course guide, login to your student portal and click on the "Materials" tab. 

skills test nexacu

Skills Test

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

 skills test

 

Locations In-Person & Online

Find the nearest location and date that works for you

Locations In-Person & Online

Find the nearest location and date that works for you

Related Training Courses

Course Icon Power Automate Beginner

Learn to automate workflows with Power Automate and boost efficiency. Start creating flows and explore the power of automation.

download course pdf
PL-900 Power Platform Certification

Become a Microsoft Certified in Power Platform Fundamentals. Attend Nexacu Power Apps, Power BI and Power Automate courses, sit the PL-900 exam and earn your Microsoft Certification.

Price: 

$ 3,600
inc GST

Locations In-Person & Online

Find the nearest location and date that works for you

Locations In-Person & Online

Find the nearest location and date that works for you

Trusted Globally by Leading Organisations

At Nexacu, we are proud to be the trusted training partner for hundreds of leading organisations across Australia, New Zealand, and around the world. From government agencies to multinational corporations, we help teams build practical skills and achieve real outcomes through expert-led training.

  • 400+ companies rely on Nexacu for workforce development
  • Trusted by government agencies at all levels
  • Delivering training across 9 countries and growing

Why Nexacu? 

step by step courseware

Step by Step Courseware

Custom workbook included with a step by step exercises

Facility Image 2
Facility Image 3
Facility Image 1

Interactive real time training

Interactive, Real-Time Training

Learn with expert instructors, wherever you are

Trusted by Business

Trusted by Business

Procured by Government

Procured by Goverment

Reviews Not Found

Valued by Individuals