Power Automate Course - Intermediate
Learn to build custom flows with Power Automate.
Learn to build custom flows with Power Automate.
4.76
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:
Recommended for users already building flows in Power Automate. You should have completed the Power Automate Beginner course and be confident creating basic flows.
Power Automate BeginnerLearn to automate workflows with Power Automate and boost efficiency. Start creating flows and explore the power of automation.
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.
Rp 41.5k
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
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.
Power Automate BeginnerLearn to automate workflows with Power Automate and boost efficiency. Start creating flows and explore the power of automation.
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.
Rp 41.5k
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.
Students
4 & 5 Star Reviews
Google Reviews
Businesses Trust Nexacu
Custom workbook included with a step by step exercises
Learn with expert instructors, wherever you are
Valued by Individuals
Australia
New Zealand
Singapore
Hong Kong
Malaysia
Philippines
Thailand