UMSL logo

Computer Education & Training Center

Power Automate

Power Automate

Power Automate (formerly called Flow) is a flexible tool to help with productivity by automating many of your business processes and repetive tasks. While Power Automate works with many apps in Office 365, one of its most common uses is to create flows (workflows) in SharePoint. [More on Power Automate]

Virtual Classes: Our Power Automate classes are available virtually (online) with an instructor present for the entire course. You will be able to log in and use our Office 365 accounts during class. You will see the instructor's screen throughout the class and you can share your screen if you need individual help from the instructor. You will have time to practice, ask questions, and receive hands-on training.

In-person classes are also available at our West County facility with limited enrollments to promote social distancing. When you register, choose your class section based on how you want to attend the class: virtual or in-person.

  • Select "Live Online" if you want to attend virtually from your workplace or home.
  • Choose "West County In-Person" if you want to attend a class at our West County location.

For more information, email info@cetc.umsl.edu.

Introduction to Power Automate

Prerequisite: Experience with Windows. If you have no experience with SharePoint, it is recommended that you take the Introduction to SharePoint Online Course). Learn to use Power Automate (formerly Flow) and understand the benefits of automation and workflows for your business processes. Understand how to navigate Power Automate, use templates, and work with the Flow management page. Discover how to build your workflow by adding, editing, and removing actions. Learn how to send email approvals and update lists based on the response. Understand how to define your logic and core paths and add conditions. Learn to set up a help desk or other types of routing workflows to send requests to the appropriate staff. Learn to automatically copy files, update lists, and archive information. Topics include triggers, connectors, and managing flows.  [Course Outline]
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E1435 Fri., Mar. 5Virtual/WCAllan Crean
E1695 Tues., June 15Virtual/WCAllan Crean

Intermediate Applications of Power Automate

(Prerequisite: Introduction to Power Automate.) Take your skills to the next level and develop more sophisticated workflows. Understand how to use forms to gather information for surveys and processing time off or other approval requests. Learn how to set up approvals for one person or for multiple approvers. Understand how to implement serial and parallel approvals and include custom responses. Discover how to effectively bring in data from a list using filters. Learn to automate document approvals, process requests, and extract information from other sources. Discover the power of using loops in your workflows to consolidate information for reports or other actions. Learn how to store your settings in a list to give your automated routines more flexibility and avoid hard-coded text. Additional topics include effective flow design, working with the Approval Center, and checking for incomplete items in a list. [Course Outline]
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E1436 Fri., Mar. 12Virtual/WCAllan Crean
E1696 Tues., June 22Virtual/WCAllan Crean

Advanced Applications of Power Automate

(Prerequisite: Intermediate Applications of Power Automate.) Learn more advanced features in Power Automate that you can use to build flows. Understand how to use available functions and the expression builder. Learn to configure the settings on each action. Discover the power of the Scope action and how to use it to determine when your flow has not run properly. Work with Date Time functions and schedules. Understand the different types of loops and when to use each. Learn how to work with and modify file content. Discover the power of adaptive cards and how they can work with Teams and other Office 365 applications. Addtional topics include error-trapping and properly documenting your flows.
Fee: $279

One-Day Class Meets 8:30am-4:00pm (6.5 hours)
Code Date Location Instructor
E1437 Fri., Mar. 19Virtual/WCAllan Crean
E1697 Tues., June 29Virtual/WCAllan Crean

If you would like to register for a course, call (314) 984-9000 or register online.

Classes are also available in SharePoint Online and other Office 365 apps.