Skip to main content
00:00/00:00
Lecture 21 of 100

Power Automate Expression 101

Download Course (Free)

Course Content

0 / 100 completed
Section 1: Introduction - You are welcome4 videos

Course Pre-requisite

8m

The 2nd Wave of Digital Transformation

29m

Introduction - Welcome to the Course

40m

Why Learn Microsoft Power Platform

34m
Section 2: Microsoft 365 Apps and Services12 videos

Introducing Microsoft 365

14m

Intro to Microsoft teams

20m

Analyze Your Teams Data Using Microsoft Power BI

22m

Create a Microsoft Developer Account for Free

56m

How to Enable Public and Developer Preview for MS Teams from Admin Centre

12m

Microsoft SharePoint and OneDrive for Beginners

28m

Create Your First Microsoft Forms

27m

Formatting Microsoft Forms

18m

The Most Productive Way to Create Microsoft Forms

42m

How to Move Personal MS Forms to Group

20m

Uploading the Course Resources in SharePoint Document Library

4m

Create Your First SharePoint List

18m
Section 3: Microsoft Power Platform and Power Automate7 videos

Introduction to Microsoft Power Automate

9m

A brief Introduction to Microsoft Power Platform

28m

Create Your First Schedule Cloud Flow

34m

Create Automated Cloud Flow

21m

Power Automate Expression 101

24mNow Playing

When to Use Microsoft Power Automate

12m

Create a Dedicated SharePoint Teams Site for the Course Use Case

6m
Section 4: Use Case 1 Employee Check-In Button with Power Automate4 videos

Use Case Description

24m

Create The SharePoint List Backend

15m

Create Microsoft Power Automate Button

28m

Test the Solution and Share

19m
Section 5: Use Case 2 Automate Employee's Birthday Celebration3 videos

Create SharePoint List

10m

Test the Solution

5m

Create Power Automate Flow

31m
Section 6: Use Case 3 Automate Employee Work Anniversary3 videos

Test the Solution

29m

Create Microsoft Power Automate Flow Pt2

37m

Create Microsoft Power Automate Flow Pt1

52m
Section 7: Use Case 4 Create a Learning Management Solution with Forms and Power Automate10 videos

Create SharePoint List Backend

31m

Creating Microsoft Forms

33m

Create Power Automate Flow for Scoring and Communication Pt1

33m

Create Certificate Template

18m

Why We need Another Approach (Method 2)

11m

Duplicate Microsoft Quiz Form

8m

Create Power Automate Flow to Include Certificate Attachment

27m

Method 2 - Creating Power Automate Flow Part 1

1h

Method 2 - Creating Power Automate Flow Part 3

18m

Method 2 - Creating Power Automate Flow Part 2

42m
Section 8: Use Case 5 Event Registration Management Automation4 videos

Create a Registration Form with MS Forms

6m

Create a Microsoft Teams Group for the Event

2m

Create Power Automate Flow for Communication

11m

Testing the Solution

7m
Section 9: Use Case 6 On-Field Verification App with Power Automate and SharePoint List3 videos

Create a SharePoint List

5m

Test and Share the Solution

21m

Create a Power Automate Button

16m
Section 10: Use Case 7 Automating Recruitment Process with MS Forms and Power Automate10 videos

Enable Sharing for OneDrive from Admin Centre

6m

Create MS Quiz for the Assessment

6m

Create MS Forms for Application

16m

Test Application Flow

9m

Create Power Automate Flow for Registration

26m

Create Power Automate Flow for Assessment

1m

Test the Solution

11m

Quiz Flow Part 3

18m

Quiz Flow Part 2

42m

Quiz Flow Part 1

1h
Section 11: Use Case 8 Send Weekly Report as HTML Table via Email3 videos

Populate SharePoint List with Data

42m

Test The Flow with More Data

23m

Create Scheduled Cloud Flow for Weekly Report

56m
Section 12: Use Case 9 Send Weekly Report as Excel Attachment via Email1 videos

Create a Schedule Cloud Flow to Export the Data as Excel

55m
Section 13: Use Case 10 How to Update the Status of SharePoint Item with Microsoft Form2 videos

Create Microsoft Forms for Item Update

13m

Create Power Automate Flow to Update SharePoint List Item Status

57m
Section 14: Use Case 11 Bulk Update of List Item with Excel File from MS Form Upload3 videos

Create MS Forms for Bulk Update

6m

Create a Flow to Populate SharePoint List with Excel File Content Part 2

43m

Create a Flow to Populate SharePoint List with Excel File Content Part 1

1h 5m
Section 15: Use Case 12 Automate Memo Approval Process3 videos

Create a SharePoint List Backend

10m

Create Microsoft Forms for Request Submission

5m

Create Power Automate Flow for Routing Approvals

1h 2m
Section 16: Use Case 13 Automate Memo Approval with Multiple File Uploads3 videos

Create SharePoint Document Library

10m

Create Microsoft Forms for Multiple File Upload

6m

Create The Flow

51m
Section 17: Use Case 14 Run a Schedule Cloud Flow Once1 videos

Create a Schedule Cloud Flow and Make it Run Once

15m
Section 18: Use Case 15 Populate a MS SQL Database Table with Table coming from MS Forms6 videos

Create MS SQL Database Table

14m

Create a Microsoft Forms

11m

Install and Configure Data Gateway

17m

Create Connection to Data Gateway in Flow

9m

Create Power Automate Flow to Populate the Database Table with Forms Response

23m

Test the Solution

5m
Section 19: Use Case 16 Schedule Report Spooling from MS Database Using Power Automate5 videos

Create Store Procedure in MS SQL Server Database

41m

Create Gateway Connection for MS SQL Server

9m

Installing and Configuring a Data Gateway

17m

Test the Solution

11m

Create Power Automate Flow to Spool Report and Send as Email Attachment

19m
Section 20: Multiple Forms, How to Tie Them Together2 videos

How to Manage Multiple Forms and Links in an Organization

9m

Let's get it Done

23m
Section 21: Bonus Track10 videos

Use Case Description

11m

Introduction to Microsoft Power Apps

18m

Create Your First App in 5 Minutes

11m

Create a SharePoint Backend for the App

8m

Get Familiar with Power Apps Environment

12m

Add More Screens to Your App

22m

Microsoft Certifications for Power Platform Developer

14m

Apply Theme on Your App

4m

How to Get Microsoft Exam FREE Vouchers

8m

How to Share Your App

12m
Section 22: This is not the End1 videos

How Can this be the End

20m