Course Curriculum

Go beyond the basics of Power Automate. Ramp up your skills in this in-depth class, taught by Microsoft MVP, Laura Rogers.  This is not a beginner class. A basic knowledge of the Flow interface and concepts, is necessary.

This course has most recently been recorded in June, 2021. 

Module 1: Flow Editing Interface

In this first module, we will go into creating blank Flows and building them from scratch.  This includes an overview of the interface and options when building Flows, and concepts such as triggers, actions, conditions, and dynamic content.  Flow sharing and collaboration concepts will also be covered, as well as the mobile app.

Module 2: Flow Triggers

There are hundreds of available triggers in Microsoft Flow.  In this module, you will learn how to use them, and we will deep dive into some specific common and important triggers.  Learn about manual triggers and how initiation parameters work. This module also covers how to trigger a flow from a SharePoint list or library, how to create a flow trigger button on an item, and how to trigger a flow from Teams. Other triggers such as recurrences, Microsoft Forms, and Outlook will be demonstrated as well.

Module 3: Working with SharePoint Data

This module covers the plethora of actions and possibilities when working with SharePoint data in Microsoft Flow.  After covering the common concepts such as creating SharePoint list items, you will learn the difference between the Get Item action and Get Items, and how manipulate and update data across multiple lists.  You will learn how to work with SharePoint's content approval settings in Flow, how to query one or more SharePoint list items, and how to use actions that create folders and set permissions in SharePoint.

Module 4: Working with Files

In this module, it's all about working with files in Microsoft Flow.  There are many different places that files can come from, or be sent to.        They can be email attachments, documents in a library or OneDrive, attachments to a list item, and much more.  You will learn how to use Flow to work with file content and file names, and all of the gotchas involved in that process.  We will also cover content conversion, moving files, and converting to PDF.

Module 5: Approval Processes

In this module, you will learn about your options when it comes to building approval processes.  There is a Flow action called Approvals, that has a lot of built in functionality.  There are also other ways that you can go about it.  Send emails, assign tasks, assign planner tasks, send email with options.  These various ways will be discussed, compared, and demonstrated.  Learn about approval concepts such as dynamic multiple approvers, serial versus parallel, working with SharePoint content approval, and how to build a flow that sends overdue notifications.

Module 6: Testing & Troubleshooting

Microsoft Flow has very powerful inherent functionality when it comes to testing and troubleshooting your Flows.  In this module, you will learn what your options are, as well as the ways to test different types of Flows.  Flow history, errors, and troubleshooting will be demonstrated, as well as the details on how to catch a specific error in a flow.

Module 7: Conditions, Loops & More

This module is about conditions, loops, and some more common actions.  Conditions let you create IF THEN statements and various branches of a workflow.  Learn about the new interface for creating complex conditions, and other related concepts, such as switches and parallel branches.  With more complex workflows, it is also important to understand looping, and different types of loops, such as apply to each, and do until.  In this module, you will also learn about settings that can be configured on each action, and some useful actions such as date time, schedule, and actions that format numbers and dates.

Module 8: Variables & Expressions

When building Flows, it is important to understand how variables are used, and how to build expressions.  There are several different types of variables, and there are over twelve different actions relating to variables and other data operations.  In this module, we discuss and demonstrate these, as well as how to work with arrays (lists of things) in Flows.  The expression builder is covered, with examples of how it is used, and what the possibilities are.  You will learn how to parse JSON, work with HTML and CSV table actions, and you will see several advanced demonstrations of how to utilize all of these more complex concepts.

Module 9: Flow Administration

In this module, learn about Environments in the Power Platform, and how to do administration of Flows and Power Apps in your organization. Reporting and analytics are covered, as well as how to create flows and Power Apps inside of solutions.  You will also learn how to create a system account so that flows can be run as a different account other than the creator of the flow.

Power Apps with Power Automate

This last module exists in both the Power Apps and Power Automate advanced courses.  Since it covers the integration of the two, it is duplicated across them.  In this module, learn how to create a button in a Power App to trigger a flow, and how to create parameters in the flow that retrieve data from the Power App.  We also cover and demonstrate how to set the flow up to send data back to the Power App after the button is pushed.

Course Details

Duration: 9 hours

  • 1

    Class Agenda

    • Agenda

  • 2

    Module 1: Flow Structure

    • Intro & Flow Structure

    • Sharing Flows

    • Demo: Flow Overview & Structure

    • Advanced Power Automate Quiz

    • Resources

  • 3

    Module 2: Flow Triggers

    • Manual Triggers

    • SharePoint Triggers

    • Other Triggers

    • Demo: Triggers

    • Button in SharePoint List to Trigger a Flow

    • Advanced Power Automate Quiz

    • Resources

    • Supplemental: Flow trigger for selected Teams message

    • Supplemental: Teams Triggers in Flows

  • 4

    Module 3: Working with SharePoint Data

    • SharePoint Actions, Get Item / Items

    • SharePoint folders, content approval, sharing links

    • SharePoint Update Item, Permissions actions

    • Demo: SharePoint Actions

    • Demo: SharePoint Get Item

    • SharePoint Get Changes

    • Advanced Power Automate Quiz

    • Resources

    • Power Automate Module 3 Lab - IW Mentor

  • 5

    Module 4: Working with Files

    • Working with Files

    • Demo: Email attachments to SharePoint item

    • Convert to PDF

    • Demo: Convert to PDF

    • Advanced Power Automate Quiz

    • Resources

    • Power Automate Module 4 Lab - IW Mentor

  • 6

    Module 5: Approvals

    • Approval Concepts & Actions

    • The Approvals Action

    • Other approvals & tasks

    • Working with Multiple Approvers

    • Get manager, overdue notifications, approval example

    • Approval Process Example: Project Requests

    • Demo: Approval Process

    • Advanced Power Automate Quiz

    • Resources

    • Power Automate Module 5 Lab - IW Mentor

  • 7

    Module 6: Testing & Troubleshooting

    • Ways to Troubleshoot

    • Demo: Action on a specific error

    • Advanced Power Automate Quiz

    • Power Automate Module 6 Lab - IW Mentor

  • 8

    Module 7: Actions & Conditions Explained

    • Action & Trigger Extra Settings

    • Action Timeout & Run After

    • Concurrency, Date Calculations, Switches

    • Delay actions, Conditions, Parallel Branches

    • Loops, Do Until, Scope, Terminate

    • Demo: Multi-Level Dynamic Approval

    • Other Built-in Actions

    • Advanced Power Automate Quiz

    • Resources

    • Power Automate Module 7 Lab - IW Mentor

  • 9

    Module 8: Variables & Expressions

    • Variables & Arrays

    • HTML & CSV Tables

    • Demo: List item attachments to email

    • Filter Arrays, Working with Expressions

    • Count items in an array & other useful expressions

    • Demo: Working with Arrays

    • Demo: List of items in an email

    • Demo: Append to String Array of People

    • Demo: Parallel Approvals & Outcomes

    • Demo: Approval - first to respond

    • Advanced Power Automate Quiz

    • Resources

    • Power Automate Module 8 Lab - IW Mentor

  • 10

    Module 9: Flow Administration

    • The Admin Interface

    • Demo: Power Platform Admin

    • System account for sharing

    • Advanced Power Automate Quiz

    • Bonus: Flow to get my flows

    • Resources

    • Supplemental: Translate SPD to Flow

    • Supplemental: Adobe eSign & Power Automate

    • Supplemental: Generic Flow (cross-site)

    • Supplemental: List Button Trigger Power Automate

    • Power Automate Advanced course slides to follow along with the video training - IW Mentor

  • 11

    Power Automate with Power Apps

    • Flow Trigger from PowerApps

    • Example with Details

    • Demo: Trigger Power Automate from Power Apps

    • Power Apps and Power Automate Integration - IW Mentor

    • Advanced Power Automate Quiz

    • Resources

What you get

This is a list of everything that you get when you purchase this class.

  • ~9 hours of training content

  • Class lab files to work through

  • A recording of the class available to you any time

  • Quizzes along the way

  • A completion certificate

  • Earn coins to spend in our point store

Pricing Options

Choose your subscription level - All PowerApps & Power Automate

Reviews of this course

5 star rating

Great Content

Brian Scott

I've been building Flows for several months, but this course introduced many features that I had no idea existed. Good practical examples given throughout th...

Read More

I've been building Flows for several months, but this course introduced many features that I had no idea existed. Good practical examples given throughout the course

Read Less
5 star rating

Awesome Course on Flow Advanced Training

Denise Child

I can't wait to start using what I have learned in this course!

I can't wait to start using what I have learned in this course!

Read Less
5 star rating

Great Course!

Carol Puissegur

I've been (trying) to work with PowerAutomate for several months and knew there was a lot I didn't know. This course actually helped with understanding what...

Read More

I've been (trying) to work with PowerAutomate for several months and knew there was a lot I didn't know. This course actually helped with understanding what I don't know and can now explore further. I learned a lot of new things, and also understand what I don't know, which helps with finding resources and asking the right questions.

Read Less
5 star rating

Flow Advanced Training

Anantha Dommeti

This is an excellent course that provided me a quick learning curve to get me up to speed with building really complex workflows. Laura covered advanced topi...

Read More

This is an excellent course that provided me a quick learning curve to get me up to speed with building really complex workflows. Laura covered advanced topics like PowerApps integration, HTML tables and expressions in much detail than any other courses that are available online.

Read Less
5 star rating

Fun and Informative

Larry Heimendinger

Whether you watch PowerHour sessions or participate in online courses, Laura and her staff provide a sense of delight in what you can learn and at the same ...

Read More

Whether you watch PowerHour sessions or participate in online courses, Laura and her staff provide a sense of delight in what you can learn and at the same time make it fun and lighthearted. While PowerApps and Flow can be casually approached, their real value comes by prying off the veneer and digging deep into their capabilities. This is not code, not heavy duty development, but the courses take you way beyond what you might likely pick up playing around on your own. The big head start they give you allows creation almost at once for serious app design. What I found was a remarkable ability to discover new methods with my own experimentation that would simply not have been possible without the fundamentals I learned from her. Worth every bit of the course cost, and the benefits continue with lab access after the fact. WARNING: being in a course is addictive, and you will want a PowerHour fix weekly! However, this is a very good thing, and your knowledge and skills will continue to pile up.

Read Less
4 star rating

Excellent Training

DeeAnn Feil

I found this training to be very helpful. The step by step examples were very well demonstrated. The additional support for questions was good. Additional...

Read More

I found this training to be very helpful. The step by step examples were very well demonstrated. The additional support for questions was good. Additional demo with live examples for flows other than Approval Flows would be helpful. For example i was trying to learn how to do a flow for email push notifications for phase changes in a flow and had a hard time translating the approval flow to that scenario. It would have been nice to have more demo examples of variables, arrays, switches, etc... that were not related to approvals. Overall very well done.

Read Less
5 star rating

Great Course!!

David Leachman

Was very beneficial and helped me to automate several process within our SharePoint environment. Laura not only shows you the concepts, but always provides i...

Read More

Was very beneficial and helped me to automate several process within our SharePoint environment. Laura not only shows you the concepts, but always provides insight as to how you can create other similar flows.

Read Less
5 star rating

Great way to both learn new features and reinforce what I...

Lisa White

As always, my head hurts because I keep thinking of myriad ways to apply this new knowledge. Doing this as a static online course was good, though I wish I c...

Read More

As always, my head hurts because I keep thinking of myriad ways to apply this new knowledge. Doing this as a static online course was good, though I wish I could have asked questions.

Read Less
5 star rating

module 7 actions and condtions

Gary Krauss

Thanks, the Demo is exactly what I need to do

Thanks, the Demo is exactly what I need to do

Read Less
5 star rating

AOA

Matthew Ellis

Very informative and hands on.

Very informative and hands on.

Read Less
5 star rating

Power Automate Advanced Training

Rick Lemont

The training was excellent! Very informative and helpful.

The training was excellent! Very informative and helpful.

Read Less
5 star rating

Excellent course!

Corey Merrell

Great examples and clearly presented demos! Laura takes the time to explain how everything interacts and then includes tips to get the most out of those conn...

Read More

Great examples and clearly presented demos! Laura takes the time to explain how everything interacts and then includes tips to get the most out of those connections. I really appreciated the "watch out" reminders for certain actions. The quizzes were tough, but they helped to solidify the information for me. I ended up going back to review things I got wrong before taking the quiz again. Well done, and well worth the investment!

Read Less
5 star rating

Great, extensive and well organized training material on ...

Martinus Hamers

Great, extensive and well-organized training material on Power Automate. Well done material brought in very clear setup and presentation.

Great, extensive and well-organized training material on Power Automate. Well done material brought in very clear setup and presentation.

Read Less
5 star rating

Excellent training session for Power Automate

Eddy Tse

This exactly the kind of course that I was looking for. Right speed, right detail, and right topics for my work. I would highly recommend this to my other ...

Read More

This exactly the kind of course that I was looking for. Right speed, right detail, and right topics for my work. I would highly recommend this to my other co-workers.

Read Less
5 star rating

Understanding Expressions and using Arrays

Angela Dimmick

Being able to use this free training is a huge support especially since I would not be able to afford the cost of this.

Being able to use this free training is a huge support especially since I would not be able to afford the cost of this.

Read Less
5 star rating

Just the training I needed

Laura Connell

This training is the most complete to learn about how to make use of the Microsoft Power Automate and Power Apps tools. Every presentation included valuable ...

Read More

This training is the most complete to learn about how to make use of the Microsoft Power Automate and Power Apps tools. Every presentation included valuable information and complete demos on how to actually complete a solution. The examples show real life uses and I will apply all these to my daily work life. As you get further in the course it gets better and better.

Read Less
5 star rating

Great course. It is a lot to try to complete in one day!

Katie Warner

I will be taking more of your courses!

I will be taking more of your courses!

Read Less
5 star rating

Excellent training

Niroshana Buthgamuwa

Really great training and helped to improve the knowledge related to Power automate !

Really great training and helped to improve the knowledge related to Power automate !

Read Less
5 star rating

Excellent Course! Thorough, easy to follow.

Connie Wiegel

Laura's low key style, clear explanations, and real-world examples make this training very effective. She can break down complex topics in a way that allows ...

Read More

Laura's low key style, clear explanations, and real-world examples make this training very effective. She can break down complex topics in a way that allows the learner to take those skills into their job. Well done!

Read Less
5 star rating

Amazing one day whirlwind of a course

John Studt

This is an information packed, well organized and very clearly presented summary of advanced Power Automate topics. The examples are well designed to illust...

Read More

This is an information packed, well organized and very clearly presented summary of advanced Power Automate topics. The examples are well designed to illustrate the material.

Read Less
5 star rating

Great learning experience

Nabeel Salie

Well structured content and delivered given clear examples. Especially appreciate the gotcha tips to deal with some of issues in the environment. Thank you L...

Read More

Well structured content and delivered given clear examples. Especially appreciate the gotcha tips to deal with some of issues in the environment. Thank you Laura and Team!

Read Less
5 star rating

Power Automate Advanced Training course

Donna Fox

I kept saying, "I didn't know it could do that!" Great course! Great content! I especially like the relevant demos. It's helping me resolve road blocks on o...

Read More

I kept saying, "I didn't know it could do that!" Great course! Great content! I especially like the relevant demos. It's helping me resolve road blocks on our current projects. I appreciate your making this course available

Read Less
5 star rating

Excellent Course

Justin Zaun

The course was comprehensive and engaging.

The course was comprehensive and engaging.

Read Less

Compare subscription plans

Take a look at this chart, to find the plan for you.

Your Instructor

Microsoft MVP

Laura Rogers

Laura Rogers is a SharePoint, Power Apps & Power Automate expert, speaker, author and educator. She is well-versed in helping organizations make the most of their SharePoint environments using out-of-box functionalities such as workflows, forms and Web parts. Laura’s technical expertise also includes over 15 years of experience working with Microsoft’s messaging and collaboration systems. She has been named a Microsoft Most Valuable Professional (MVP) for the past ten years. She has contributed to several books on SharePoint over the past ten years. You can read more about Laura’s experiences on her blog, www.wonderlaura.com.