Power Automate Advanced Training
Learn about advanced concepts in Microsoft Power Automate, and deep dive into the details of how to use it to automate your business processes, in this immersive class.
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 is a recording of our live class that we taught in September, 2020.
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.
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. Other triggers such as SharePoint, recurrences, Microsoft Forms, and Outlook will be demonstrated as well.
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, and even how to query one or more SharePoint list items.
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.
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.
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.
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, and schedule.
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 also covered, with examples of how it is used, and what the possibilities are.
In this last module, learn about Environments in the Power Platform, and how to do administration of Flows and PowerApps in your organization. Reporting and admin alerts are covered, as well as special Flow actions relating to the admin of these systems.
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 how to set the flow up to send data back to the Power App after the button is pushed.
Agenda
Power Automate Advanced Class - IW Mentor
Intro & Flow Structure
Sharing Flows
Demo: Flow Overview & Structure
Advanced Power Automate Quiz
Resources
Manual Triggers
SharePoint Triggers
Other Triggers
Demo: Triggers
Advanced Power Automate Quiz
Resources
Supplemental: Flow trigger for selected Teams message
SharePoint Actions: Get Item / Items
SharePoint folders, content approval, sharing links
SharePoint Update Item, Permissions actions
Demo: SharePoint Actions
SharePoint Get Changes
Advanced Power Automate Quiz
Resources
Power Automate Module 3 Lab - IW Mentor
Working with Files
Demo: Email attachments to SharePoint item
Demo: SharePoint attachments to email
Convert to PDF
Advanced Power Automate Quiz
Resources
Power Automate Module 4 Lab - IW Mentor
Approval Concepts & Actions
The Approvals Action
Other approvals & tasks
Working with Multiple Approvers
Get manager, overdue notifications, approval example
Demo: Approval Process
Advanced Power Automate Quiz
Resources
Power Automate Module 5 Lab - IW Mentor
Ways to Troubleshoot
Demo: Action on a specific error
Advanced Power Automate Quiz
Power Automate Module 6 Lab - IW Mentor
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 Part 1
Other Built-in Actions
Advanced Power Automate Quiz
Resources
Power Automate Module 7 Lab - IW Mentor
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: Multi-Level Dynamic Approval Part 2
Demo: Append to String Array of People
Advanced Power Automate Quiz
Resources
Power Automate Module 8 Lab - IW Mentor
Admin & Reporting
Demo: Power Platform Admin & Reporting
Advanced Power Automate Quiz
Bonus: Flow to get my flows
Resources
Supplemental: Translate SPD to Flow
Flow Trigger from PowerApps
Demo: Flow with PowerApps
Power Apps and Power Automate Integration - IW Mentor
Advanced Power Automate Quiz
Resources
This is a list of everything that you get when you purchase this class.
~8 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
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 MoreI'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 LessI 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 LessI'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 MoreI'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 LessThis 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 MoreThis 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 LessWhether 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 MoreWhether 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 LessI 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 MoreI 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 LessWas 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 MoreWas 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 LessI took the 4-day PowerApps class in August 2018, which was fabulous. It didn't take long to realize that PowerApps can be made MUCH more powerful and efficie...
Read MoreI took the 4-day PowerApps class in August 2018, which was fabulous. It didn't take long to realize that PowerApps can be made MUCH more powerful and efficient by adding Flows. I've also created several rudimentary stand-alone Flows - most of which work. This advanced class took me to another level. Topics covered are practical and useful rather than esoteric - especially with Laura's tips and tricks to make things work. The lab exercises are designed to make you think (ouch) instead of just a cookbook approach. Laura's teaching style is interactive and enjoyable - not dry or pedantic. I also appreciate that Laura can add information based on a student's question, even if it's slightly off topic. I recommend that participants have some experience with creating and testing Flows before taking this class. Perfect for non-developers like me.
Read LessThanks, the Demo is exactly what I need to do
Thanks, the Demo is exactly what I need to do
Read LessVery informative and hands on.
Very informative and hands on.
Read LessLaura Rogers