Audience
This 1-day course is designed for anyone new to creating and implementing flows in Microsoft Power
Automate. The content will introduce delegates to the key concepts of Power Automate, with the goal
of empowering them to design and implement their own solutions in the workplace.
Prerequisites
Delegates should possess the following knowledge before attending this course.
Familiarity with Windows 10 or later
Some familiarity with the Microsoft 365 environment
Some basic programming knowledge would be useful though not essential
Duration
1 day.
Course Objectives
Upon successful completion of this course, delegates will be able to:
Understand the Key Components of Power Automate
Implement Flows with Templates
Understand the Key Components of a Flow
Handle Email with Flows
Interact with Microsoft SharePoint and OneDrive
Work with Files and Folders
Interact with Microsoft Excel
Work with Variables
Use Expressions
Handle Flow Errors
Interact with Microsoft Teams *
Course Content
1. Introducing Power Automate
The Microsoft Power Platform
The Role of Power Automate
Power Automate Terminology
Power Automate Components
2. Power Automate Templates
Reviewing Power Automate Templates
Configuring and Running a Template Flow
3. Creating Custom Flows
Types of Flows
Data Connectors
Triggers
Actions
Create and Test a Custom Flow
4. Working with Email
Sending and Receiving Email
Handling Attachments
5. Working with SharePoint and OneDrive
SharePoint Lists and Documents
Working with Files and Folders
Working with OneDrive
6. Working with Microsoft Excel
Excel Triggers and Actions
Getting Rows of Data
Adding Rows of Data
7. Flow Management
Working with Variables
Dynamic Content
Expressions
The Compose Action
Controlling Flow Execution
Error Handling
* The Following Module if Time Allows
8. Working with Microsoft Teams *
Microsoft Teams Triggers
Power Automate Teams Actions
Posting Content to Teams