Power Automate Advanced
Flows that hold up when the data gets messy.
Advanced2 days6 modulesHands-onHRD Corp claimable
Simple flows break on real data. A list comes back empty, a field is missing, a date arrives in the wrong time zone, a loop hits its limit.
This course is for people who already build flows. It covers variable types, JSON parsing and Compose, string, date, time and math functions, OData filter queries, filtering arrays, Join and Select, CSV and HTML tables, Apply to Each and Do Until loops, loop limits, delays and scheduling. Each topic is practised on realistic workflow scenarios.
By the end, participants can
- Build advanced automated workflows using Microsoft Power Automate
- Work effectively with variables, expressions, JSON data, and collections
- Create and manage complex loop and iteration processes
- Apply OData queries and data operations for advanced data processing
- Use date, time, math, and logical functions within automation workflows
- Implement error handling, debugging, and troubleshooting techniques
- Optimise workflow performance using concurrency controls and parallel branches
- Develop scalable parent-child flow architectures for enterprise automation
- Automate complex business processes with greater efficiency and reliability
Course outline
Day 1
01Power Automate Fundamentals & Instant Flows
- Introduction to Power Automate and workflow automation
- Understanding flows and workflow concepts
- Creating instant flows with user input
- Working with triggers and dynamic content
- Accessing documentation and references
- Understanding and using the “?” operator
02Data, Variables & JSON Handling
- Understanding variable data types
- Setting, incrementing and decrementing variables
- Appending to string and array variables
- Understanding and working with JSON data
- Processing and parsing JSON data
- Using Compose and other data operations
03Functions & Data Transformation
- Working with string and text functions
- Manipulating and formatting text data
- Using date and time functions
- Converting time zones
- Adding values to dates and times
- Using math and logical functions
Day 2
04Filtering, Collections & Data Operations
- Understanding and using OData filter queries
- Creating basic OData expressions
- Working with collection functions
- Filtering arrays
- Using Join and Select actions
- Creating CSV and HTML tables
- Working with current iteration indexes
05Loops, Iteration & Flow Control
- Understanding loops and iteration in Power Automate
- Using “Apply to Each” loops
- Using “Do Until” loops
- Creating and managing loop-based flows
- Managing actions after loops
- Understanding loop limits and successful completion
06Scheduling, Delays & Advanced Workflow Management
- Using Delay and Delay Until actions
- Scheduling workflow execution
- Managing flow timing and dependencies
- Applying functions and conditions within workflows
- Integrating data, loops and functions to build efficient automated workflows
- Practical exercises and real-world workflow scenarios