Microsoft Power Automate (Flow) Crash Course

Name: Microsoft Power Automate (Flow) Crash Course
Rating: 4.6 (12349 reviews)

Learn how to create workflows using Microsoft Power Automate from ground zero

Created byAlireza Aliabadi

Last updated 7/2026

English

What you'll learn

Creating Workflows using Microsoft Power Automate Flow
Connecting different solutions to SharePoint Online
Calling Flows from external sources
Creating workflow triggers and actions with Flow
Controlling flow using conditions
Querying records using OData in Microsoft Flow
Sending Office Forms data to Microsoft Flow

Course content

9 sections • 53 lectures • 8h 0m total length

Introduction to Power Automate1:08
Welcome and introduction to the course
Who can benefit from this course?4:06
The course target audience and prerequisites.
What is Power Automate?9:38
A review on Microsoft Power platform and understanding the basics of Power Automate.
Hello World using Power Automate8:41
Let's create a tiny Flow using Power Automate and point out Trigger, Action and Connectors.
Licenses and tools you need for this course7:51
Discover the licenses and tools required for this course, including SharePoint Online, Power Automate licenses, Postman, and the Power Automate mobile app. Understand standard versus premium connectors and their costs.
Warm-up with Power Automate12:05
Let's build our first Flow in Power Automate together :)
Course Road Map2:26
Let's have an overview on what we are going to learn in this course.

Understanding different types of Power Automate triggers3:26
In this lecture we learn about different types of triggers we have in Power Automate.
Manually firing a Power Automate Flow13:49
In this lecture you will learn how to use manual flow trigger with added fields. You will also run your first Flow from Power Automate mobile app.
Instant Power Automate triggers that we don't cover in this course3:37
Explore instant triggers in Power Automate beyond the course, including PowerApps, Excel (in preview), and Web API calls. Learn where to find related information.
Firing Power Automate Flow on schedule7:08
In this video you will see how to create a Flow that is fired on a calendar with intervals.
Power automate automated triggers13:07
In this lecture we create a Flow that monitors a SharePoint library and sends an email when a file is added to the library.
Checking an e-mail arrival in a mailbox using Automated trigger7:12
In this lecture we use a trigger that is fired when an e-mail gets to a mailbox.
What is next?0:50
Learn to trigger automation with Microsoft Flow as you instruct it to perform tasks. Experience the exciting start of automation beyond sending emails.

Create your first Flow that interacts with SharePoint online10:02
Create a Power Automate flow with an instant trigger to submit title, category, and comments to a SharePoint list, using a SharePoint site and a Demo List for Power Automate.
Make real use of a very simple Power Automate Flow9:22
This is a real life example of using what we have learned so far
Retrieving all items in a SharePoint list12:55
In this lecture we will learn how to get all items from a SharePoint list using Power Automate Get Items action
Why do we need OData in Power Automate?4:32
In this video you will describe a scenario in which we need OData
Learning OData syntax15:39
In this lecture we learn the basic OData filters and use them in Power Automate Flow.
OData Limitations and Sort5:49
In this lecture we review some of the limitations of OData in Power Automate. We will also see how to sort the content that we receive from other sources using OData sort feature.
Get Items vs Get Item - Finding list item by ID7:32
So far we learned how to get all items in a list based on some filter criteria. In this lecture we learn how to get a specific item assuming that we have the item ID.
Deleting and Updating list items in Power Automate19:13
Test your knowledge

Why do we need variables?1:37
This is a quick introduction to why we need variables in Power Automate
Let's create our first variables6:32
Learn to initialize variables in Power Automate flows, assign meaningful names, and select types like integer and string, demonstrated with age 47 and a client name.
Set vs Increment/Decrement vs Append12:55
In this lecture we learn how to work with different variable actions in Power Automate.
Append to an array8:05
An introduction to arrays in Power Automate followed by append function
Working with Object variables9:08
In this lecture, we create an object variable and assign a JSON object to it. Then we learn to use "Parse JSON" to read the object properties.
Test your knowledge

Working with conditions11:26
In this lecture we learn how to use Condition action and select different flow paths based on the received value.
Working with Flow Switch9:53
This lecture is a demo of Switch control
Working with "Apply to Each"10:09
In this lecture we learn how to use "Apply to each" to navigate through all items in an array.
Working with "Do Until" loop11:58
Now we can have a loop with counter.
Scope and Error Handling - Problem definition13:43
The first section of error handling.
Error handling - Basic features12:55
In this lecture we learn about "Configure run after" and go through a simple example
Error handling - Solving the problem10:01
Working with approval requests15:25
In this lecture we learn how to create an approval request and send it to more than one approver simultaneously
Branching the flow for different simultaneous approval requests10:23
In this lecture we learn how to create two approval requests and send them to two approvers at the same time in two parallel branches.
Test your knowledge

Introduction to Power Automate Security2:01
Explore securing Power Automate flows by adding co-owners and run-only users, assigning permissions, and understanding who can grant access.
Adding co-owners to the Power Automate Flow5:48
In this lecture we learn about how to add co-owners to the flow and the impacts of it to other access levels.
Working with Run-only users6:28
This is an important chapter. In this lecture we will learn about giving a user to run a Power Automate Flow without giving access to open the Flow for edit.
Test your knowledge

Introduction to Power Automate and Excel2:26
Learn to integrate Excel with Power Automate by triggering flows from an Excel button, using Excel tables as data storage, and reading or updating records from Power Automate, with challenges.
Refresh your Excel knowledge8:24
Calling Flow from Microsoft Excel11:47
In this lecture we create a Power Automate Flow that we call directly from Microsoft Excel and we pass table row as parameter to Flow
Insert/Delete/Update Excel content from Power Automate Flow16:27
In this lecture we create an excel file with a table inside it. Then we user Power Automate to insert, delete and update the rows in the table.
Reading table rows in Excel10:58
In this lecture, we connect to a table in Microsoft Excel and read the table content from Power Automate Flow
Creating a table inside Microsoft Excel and reading the content15:36
In this lecture we use Power Automate to convert an Excel range to a table and then read the content from the table in the same Flow.
Test your knowledge

Planning our future steps4:35
Project definition4:44
Automate tailor shop's weekly order list with Power Automate, using supervisor inputs from a SharePoint Excel sheet; enforce 30+ approvals or auto add to the weekly list, then email logistics.
Design and initial setup8:03
Solution to final project - 120:51
Create an instant Power Automate flow that reads an Excel table, initializes config and order amount, handles large order approvals, and adds items to a SharePoint weekly purchase list.
Solution to final project - 211:50
Let's create the schedule for the Flow and finish the course
Your next course is FREE5:05

Requirements

Basic understanding of SharePoint Online
Familiarity with workflow and business process automation

Description

Power Automate (formerly known as Microsoft Flow) is the new generation of Microsoft automation tools on Microsoft cloud. With this technology Microsoft is trying to make automation more accessible to the people who actually understand and live with the business process than techies to live and breath technology and quite often not so familiar with the business process.

This course is designed form beginners with no experience with Power Automate and upon completion of this course you will be able to create workflows using Power Automate that can solve real life automation challenges. Although the course is designed for beginners, the content is suitable for people with strong technical background that are willing to start with Microsoft Power Automate.

The course focuses on field experience and using the technology in day-to-day basis rather than just demos. Clear explanation is given for every step of the work assuring you well understand the work you do and can transfer the knowledge to your day-to-day job. Clear explanation of Microsoft Power platform guarantees your understanding of all elements you need to learn and all the licensing requirements are clarified right in the beginning of the course.

The course includes lectures, quiz and a final project that puts all the course knowledge together for a real life example of using Power Automate.

Who this course is for:

SharePoint Online power users
SharePoint developers
Workflow developers/designers
System integrators
Dynamics 365 Developers
Dynamics 365 Architects
SharePoint Architects

Microsoft Power Automate (Flow) Crash Course

What you'll learn

Explore related topics

Course content

Introduction, prerequisites and course road map7 lectures • 46min

Working with Power Automate Trigger7 lectures • 49min

Working with Power Automate actions8 lectures • 1hr 25min

Working with Power Automate Data types and Variables5 lectures • 38min

Working with Flow Control Actions9 lectures • 1hr 46min

Power Automate Security3 lectures • 14min

Working with Excel files6 lectures • 1hr 6min

Working with Office Forms2 lectures • 21min

Real life Flow scenarios and future steps6 lectures • 55min

Requirements

Description

Who this course is for: