Microsoft Power Automate (Flow) Crash Course

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

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

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.

Overview

Section 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

Section 2: Working with Power Automate Trigger

Lecture 8 Understanding different types of Power Automate triggers

Lecture 9 Manually firing a Power Automate Flow

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

Lecture 11 Firing Power Automate Flow on schedule

Lecture 12 Power automate automated triggers

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

Lecture 14 What is next?

Section 3: Working with Power Automate actions

Lecture 15 Create your first Flow that interacts with SharePoint online

Lecture 16 Make real use of a very simple Power Automate Flow

Lecture 17 Retrieving all items in a SharePoint list

Lecture 18 Why do we need OData in Power Automate?

Lecture 19 Learning OData syntax

Lecture 20 OData Limitations and Sort

Lecture 21 Get Items vs Get Item - Finding list item by ID

Lecture 22 Deleting and Updating list items in Power Automate

Section 4: Working with Power Automate Data types and Variables

Lecture 23 Why do we need variables?

Lecture 24 Let's create our first variables

Lecture 25 Set vs Increment/Decrement vs Append

Lecture 26 Append to an array

Lecture 27 Working with Object variables

Section 5: Working with Flow Control Actions

Lecture 28 Working with conditions

Lecture 29 Working with Flow Switch

Lecture 30 Working with "Apply to Each"

Lecture 31 Working with "Do Until" loop

Lecture 32 Scope and Error Handling - Problem definition

Lecture 33 Error handling - Basic features

Lecture 34 Error handling - Solving the problem

Lecture 35 Working with approval requests

Lecture 36 Branching the flow for different simultaneous approval requests

Section 6: Power Automate Security

Lecture 37 Introduction to Power Automate Security

Lecture 38 Adding co-owners to the Power Automate Flow

Lecture 39 Working with Run-only users

Section 7: Working with Excel files

Lecture 40 Introduction to Power Automate and Excel

Lecture 41 Refresh your Excel knowledge

Lecture 42 Calling Flow from Microsoft Excel

Lecture 43 Insert/Delete/Update Excel content from Power Automate Flow

Lecture 44 Reading table rows in Excel

Lecture 45 Creating a table inside Microsoft Excel and reading the content

Section 8: Working with Office Forms

Lecture 46 Introduction to Office Forms

Lecture 47 Capturing Office Forms submitted form using Power Automate

Section 9: Real life Flow scenarios and future steps

Lecture 48 Planning our future steps

Lecture 49 Project definition

Lecture 50 Design and initial setup

Lecture 51 Solution to final project - 1

Lecture 52 Solution to final project - 2

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