Microsoft Power Automate (Flow) Crash Course

Course Curriculum

Chapter 1: Introduction, prerequisites and course road map

Lecture 1: Introduction to Power Automate

Lecture 2: Who can benefit from this course?

Lecture 3: What is Power Automate?

Lecture 4: Hello World using Power Automate

Lecture 5: Licenses and tools you need for this course

Lecture 6: Warm-up with Power Automate

Lecture 7: Course Road Map

Chapter 2: Working with Power Automate Trigger

Lecture 1: Understanding different types of Power Automate triggers

Lecture 2: Manually firing a Power Automate Flow

Lecture 3: Instant Power Automate triggers that we don't cover in this course

Lecture 4: Firing Power Automate Flow on schedule

Lecture 5: Power automate automated triggers

Lecture 6: Checking an e-mail arrival in a mailbox using Automated trigger

Lecture 7: What is next?

Chapter 3: Working with Power Automate actions

Lecture 1: Create your first Flow that interacts with SharePoint online

Lecture 2: Make real use of a very simple Power Automate Flow

Lecture 3: Retrieving all items in a SharePoint list

Lecture 4: Why do we need OData in Power Automate?

Lecture 5: Learning OData syntax

Lecture 6: OData Limitations and Sort

Lecture 7: Get Items vs Get Item – Finding list item by ID

Lecture 8: Deleting and Updating list items in Power Automate

Chapter 4: Working with Power Automate Data types and Variables

Lecture 1: Why do we need variables?

Lecture 2: Let's create our first variables

Lecture 3: Set vs Increment/Decrement vs Append

Lecture 4: Append to an array

Lecture 5: Working with Object variables

Chapter 5: Working with Flow Control Actions

Lecture 1: Working with conditions

Lecture 2: Working with Flow Switch

Lecture 3: Working with "Apply to Each"

Lecture 4: Working with "Do Until" loop

Lecture 5: Scope and Error Handling – Problem definition

Lecture 6: Error handling – Basic features

Lecture 7: Error handling – Solving the problem

Lecture 8: Working with approval requests

Lecture 9: Branching the flow for different simultaneous approval requests

Chapter 6: Power Automate Security

Lecture 1: Introduction to Power Automate Security

Lecture 2: Adding co-owners to the Power Automate Flow

Lecture 3: Working with Run-only users

Chapter 7: Working with Excel files

Lecture 1: Introduction to Power Automate and Excel

Lecture 2: Refresh your Excel knowledge

Lecture 3: Calling Flow from Microsoft Excel

Lecture 4: Insert/Delete/Update Excel content from Power Automate Flow

Lecture 5: Reading table rows in Excel

Lecture 6: Creating a table inside Microsoft Excel and reading the content

Chapter 8: Working with Office Forms

Lecture 1: Introduction to Office Forms

Lecture 2: Capturing Office Forms submitted form using Power Automate

Chapter 9: Real life Flow scenarios and future steps

Lecture 1: Planning our future steps

Lecture 2: Project definition

Lecture 3: Design and initial setup

Lecture 4: Solution to final project – 1

Lecture 5: Solution to final project – 2