Power Automate Course - Intermediate

Learn to build custom flows with Power Automate.

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. 

powerauto courses nexacu
powerauto courses nexacu

Course Details

Download Course PDF
Price
$640 $575
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

Course Details

Download Course PDF
Price
$640 $575
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 8
201 Charlotte Street
Brisbane QLD 4000

Course Details

Download Course PDF
Price
$640 $575
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 24/477 Pitt Street
Sydney
New South Wales 2000

Course Details

Download Course PDF
Price
$640 $575
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 7
79 George Street
Parramatta NSW 2150

Course Details

Download Course PDF
Price
$640 $575
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 12A
45 William Street Melbourne VIC 3000

Course Details

Download Course PDF
Price
$640 $575
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
NEW LOCATION
Level 2
221 London Circuit
Canberra ACT 2600

Course Details

Download Course PDF
Price
$640 $575
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 15
33 King William Street
Adelaide 5000

Course Details

Download Course PDF
Price
$640 $575
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 7
553 Hay Street
Perth WA 6000

Course Details

Download Course PDF
Price
$640 $575
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

Upcoming Courses

Remote East

Brisbane

Sydney

Parramatta

Melbourne

Canberra

Adelaide

Perth

Remote West

Remote East

We currently have no public courses scheduled. Please contact us to register your interest.

Brisbane

We currently have no public courses scheduled. Please contact us to register your interest.

Sydney

We currently have no public courses scheduled. Please contact us to register your interest.

Parramatta

We currently have no public courses scheduled. Please contact us to register your interest.

Melbourne

We currently have no public courses scheduled. Please contact us to register your interest.

Canberra

We currently have no public courses scheduled. Please contact us to register your interest.

Adelaide

We currently have no public courses scheduled. Please contact us to register your interest.

Perth

We currently have no public courses scheduled. Please contact us to register your interest.

Remote West

We currently have no public courses scheduled. Please contact us to register your interest.

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 start tapping into the Power Platform.

download course pdf
Price: $470 $520
View Course
4.72
(853)
Course Icon Power Automate Intermediate

Automate workflows with Power Automate. Use Power Automates building blocks to create customised workflows with this Intermediate course.

download course pdf
Price: $575 $640
View Course
4.74
(696)
Course Icon Power Automate Advanced

Learn to automate workflows with Power Automate and start tapping into the Power Platform.

download course pdf
Price: $595 $660
View Course
4.75
(528)
PL-900 Power Platform Certification

Become a Microsoft Certified in Power Platform Fundmentals. 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 that 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 more important opportunities. Microsoft Power Automate training will help you make the most of this incredibly useful application. 

What is Remote Training?

Remote training at Nexacu means our experienced trainers will deliver your training virtually. Students can access our usual classroom training courses via video conferencing, ask questions, participate in discussions, 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. Our Microsoft Power Automate training is offered remotely. 

I previously attended a course with Excel Consulting, will the training be similar?

Yes, we rebranded from Excel Consulting in October 2019. The business quickly outgrew its original name. Our new brand Nexacu better reflects our direction, continued innovation and commitment to delivering next-level learning. We have continually refined and continue to update our courses but retain our excellent trainers and deliver the same high-quality content.

Course Details

Download Course PDF
Price
$640 $575
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

Course Details

Download Course PDF
Price
$640 $575
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 8
201 Charlotte Street
Brisbane QLD 4000

Course Details

Download Course PDF
Price
$640 $575
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 24/477 Pitt Street
Sydney
New South Wales 2000

Course Details

Download Course PDF
Price
$640 $575
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 7
79 George Street
Parramatta NSW 2150

Course Details

Download Course PDF
Price
$640 $575
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 12A
45 William Street Melbourne VIC 3000

Course Details

Download Course PDF
Price
$640 $575
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
NEW LOCATION
Level 2
221 London Circuit
Canberra ACT 2600

Course Details

Download Course PDF
Price
$640 $575
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 15
33 King William Street
Adelaide 5000

Course Details

Download Course PDF
Price
$640 $575
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 7
553 Hay Street
Perth WA 6000

Course Details

Download Course PDF
Price
$640 $575
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online

Skills Test

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

skills test nexacu

 skills test

 

Contact Us

Can’t find a suitable date or have questions about the course? Fill out the form below, and our team will get back to you promptly.

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

;

Why Nexacu?

Books Icon

Step by Step Courseware

Custom workbook included with a step by step exercises

Why grid 2
Why grid 3
Why grid 1
Refresh Icon

Free Refresher

Resit your course for free within 6 Months

More than 1,300 Business trust Nexacu

Trusted by Business

Procured by Government

Procured by Goverment

Valued by Individuals