Process Automation Course Using Power Automate

By Olanrewaju Oyinbooke Categories: Automations, Cloud Computing, Technical Courses

About Course

One of the advantages of technology and having the skill is the opportunity it offers to scale your business and career. To be more productive, you need to work smarter. With low-code/no-code tools, Microsoft Power Automate, you can automate redundant tasks and focus on what will earn you more productivity points at work. The best approach to learning a tool like Microsoft Power Automate is by building a solution alongside it.

Course Content

Introduction – You are Welcome

Introduction – Welcome to the Course

02:11
Why Learn Microsoft Power Platform

03:32
The 2nd Wave of Digital Transformation

11:57
Course Pre-Requisite

00:46

Microsoft 365 Apps and Services

Introducing Microsoft 365

08:15
Create a Microsoft 365 Developer Account

18:41
Intro to Microsoft Teams

14:21
Analyze Your Teams Data Using Power BI

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

03:55
Microsoft SharePoint and OneDrive for Beginners

11:09
Create Your First Microsoft Forms

15:42
The Most Productive Way to Create Microsoft Forms

14:39
Formatting Microsoft Forms

06:52
How to Move Personal MS Forms to Group Forms

05:44
Create Your First SharePoint List

07:07
Uploading the Course Resources in SharePoint Document Library

00:52

Microsoft Power Platform and Power Automate

Use Case 1: Employee Check-In Button with Power Automate
Learn how to automate employee check-in and check-out activities with Microsoft Power Automate.

Use Case 2: Automate Employee’s Birthday Celebration
Employers can get more closer to their employees by celebrating them on a day that matters. Birthday is one of those days.

Use Case 3: Automate Employee Work Anniversary
Celebrate your employees on their work anniversary and take the task away from your HR team.

Use Case 4: Create a Learning Management Solution with Forms and Power Automate
Leverage on Microsoft Forms and Power Automate to Create a Learning Management Solution for your organization

Use Case Description

01:16
Creating Microsoft Forms

12:17
Create SharePoint List Backend

09:43
Create Power Automate Flow for Scoring and Communication Pt1

09:44
Create Certificate Template

05:42
Create Power Automate Flow to Include Certificate Attachment

06:48
Why We need Another Approach (Method 2)

02:50
Duplicate Microsoft Quiz Forms

02:10
Method 2 – Creating Power Automate Flow Part 1

14:37
Method 2 – Creating Power Automate Flow Part 2

13:43
Method 2 – Creating Power Automate Flow Part 3

05:31

Use Case 5: Event Registration Management Automation
Learn how to leverage on Microsoft Power Automate to drive an automated event registration session

Use Case 6: On-Field Verification App with Power Automate and SharePoint List
Create a Power Automate Button flow to carry out field verification activities.

Use Case 7: Automating Recruitment Process with MS Forms and Power Automate
Leverage on Microsoft Forms, OneDrive, SharePoint and Power Automate for automating recruitment process in your organization

Use Case Description

01:15
Enable Sharing for OneDrive from Admin Centre

02:17
Create MS Forms for Application

04:31
Create MS Quiz for the Assessment

01:46
Create Power Automate Flow for Registration

08:54
Test the Application Flow

02:46
Create Power Automate Flow for Assessment

00:32
Quiz Flow Part 1

14:37
Quiz Flow Part 2

13:43
Quiz Flow Part 3

05:31
Test the Solution

03:10

Use Case 8: Send Weekly Report as HTML Table via Email
How can you embed HTML table in your email content? This use case will address it

Use Case 9: Send Weekly Report as Excel Attachment via Email
What if you will prefer to have your weekly report as Excel File attached as the content of your Email? Let's do that together in this use case

Use Case 10: How to Update the Status of SharePoint Item with Microsoft Form
What if you have list of actions on a SharePoint list and you need people to update item status by just filling a form. This use case will help address this challenge

Use Case 11: Bulk Update of List Item with Excel File from MS Form Upload
What if you want to do a batch upload or creation of items on a SharePoint List, can you just upload the file via MS Form and have them created on SharePoint List? Yes, It is possible.

Use Case 12: Automate Memo Approval Process
How do you automate the Memo Approval process in your organization? Power Automate can be leveraged on to get this done.

Use Case 13: Automate Memo Approval with Multiple File Uploads
This use case addresses how to handle multiple files uploaded in MS Forms within Power Automate Approval and Email Attachment

Use Case 14: Run a Schedule Cloud Flow Once
How do you get a flow to run at a particular time and for once? With a Schedule Cloud Flow, It can run at a particular time but will have to be repeated. This use case will show you a way around it

Use Case 15: Populate a MS SQL Database Table with Table coming from MS Forms
How can you use Microsoft Power Automate to Communicate with your Database? we will establish the connection and also build a flow that populates the database table with responses from MS Forms

Use Case 16: Schedule Report Spooling from MS Database Using Power Automate
We will create a Power Automate Flow that will run on schedule to spool reports from MS SQL Database, export the report to Excel and send as attachment via Email

Multiple Forms, How to Tie Them Together
We have created multiple forms and links. how do we get them coordinated and make them easily accessible?

This is not the End
Yeah, the topic reads 15+ Use Cases and not 15 Use Cases. so expect to see more use cases added frequently

Bonus Track
There is more for you. In this Module, You will build your first Microsoft Power Apps, Learn about Microsoft Certifications and how to get FREE Vouchers. get ready to explore this career path

Introduction to Microsoft Power Apps

06:00
Use Case Description

01:06
Create a SharePoint Backend for the App

03:09
Create Your First App in 5 Minutes

05:37
Get Familiar with Power Apps Environment

04:55
Add More Screens to Your App

10:04
Apply Theme on Your App

01:50
How to Share Your App

05:14
Microsoft Certifications for Power Platform Developer

03:36
How to Get Microsoft Exam FREE Vouchers

02:12

Student Ratings & Reviews

No Review Yet

A course by

Olanrewaju Oyinbooke

This course is for beginners. we focus on taking you from beginners to advance by working on business use cases.
Intermediate learners can also gain a lot through the diverse use cases considered in this course.
Non technical employee who is interested in solving business challenges without writing codes
Individuals interested in upskilling to become more competitive and productive at work
Employees with repetitive task or seemingly manual processes and need to automate them
Students who want to upskill in preparation for job placement
Managers who is interested in what is possible with Power Platform
Young Graduate who need to add more skills to their skillset for better job placement
Anyone interested in business transformation using no/low code platform
Anyone interested in creating workflow in their organization

About Course

What Will You Learn?

Course Content

Introduction – You are Welcome

Microsoft 365 Apps and Services

Introducing Microsoft 365

Create a Microsoft 365 Developer Account

Intro to Microsoft Teams

Analyze Your Teams Data Using Power BI

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

Microsoft SharePoint and OneDrive for Beginners

Create Your First Microsoft Forms

The Most Productive Way to Create Microsoft Forms

Formatting Microsoft Forms

How to Move Personal MS Forms to Group Forms

Create Your First SharePoint List

Uploading the Course Resources in SharePoint Document Library

Microsoft Power Platform and Power Automate

A brief Introduction to Microsoft Power Platform

Introduction to Microsoft Power Automate

Create Your First Schedule Cloud Flow

Create Automated Cloud Flow

Power Automate Expression 101

When to Use Microsoft Power Automate

Create a Dedicated SharePoint Teams Site for the Course Use Case

Use Case 1: Employee Check-In Button with Power Automate Learn how to automate employee check-in and check-out activities with Microsoft Power Automate.

Create A SharePoint List

Create a Microsoft Power Automate Flow

Test the Solution

Use Case 2: Automate Employee’s Birthday Celebration Employers can get more closer to their employees by celebrating them on a day that matters. Birthday is one of those days.

Create SharePoint List

Create Power Automate Flow

Test the Solution

Use Case 3: Automate Employee Work Anniversary Celebrate your employees on their work anniversary and take the task away from your HR team.

Create SharePoint List

Create Flow Part 1

Create Flow Part 2

Test the Solution

Use Case 4: Create a Learning Management Solution with Forms and Power Automate Leverage on Microsoft Forms and Power Automate to Create a Learning Management Solution for your organization

Creating Microsoft Forms

Create SharePoint List Backend

Create Power Automate Flow for Scoring and Communication Pt1

Create Certificate Template

Create Power Automate Flow to Include Certificate Attachment

Why We need Another Approach (Method 2)

Duplicate Microsoft Quiz Forms

Method 2 – Creating Power Automate Flow Part 1

Method 2 – Creating Power Automate Flow Part 2

Method 2 – Creating Power Automate Flow Part 3

Use Case 5: Event Registration Management Automation Learn how to leverage on Microsoft Power Automate to drive an automated event registration session

Create a Microsoft Teams Group for the Event

Create a Registration Form with MS Forms

Create Power Automate Flow for Communication

Test the Solution

Use Case 6: On-Field Verification App with Power Automate and SharePoint List Create a Power Automate Button flow to carry out field verification activities.

Create a SharePoint List

Create a Power Automate Button

Test the Solution

Use Case 7: Automating Recruitment Process with MS Forms and Power Automate Leverage on Microsoft Forms, OneDrive, SharePoint and Power Automate for automating recruitment process in your organization

Enable Sharing for OneDrive from Admin Centre

Create MS Forms for Application

Create MS Quiz for the Assessment

Create Power Automate Flow for Registration

Test the Application Flow

Create Power Automate Flow for Assessment

Quiz Flow Part 1

Quiz Flow Part 2

Quiz Flow Part 3

Test the Solution

Use Case 8: Send Weekly Report as HTML Table via Email How can you embed HTML table in your email content? This use case will address it

Populate SharePoint List with Data

Create Scheduled Cloud Flow for Weekly Report

Test the Flow with More Data

Use Case 9: Send Weekly Report as Excel Attachment via Email What if you will prefer to have your weekly report as Excel File attached as the content of your Email? Let's do that together in this use case

Populate SharePoint List with Data

Create a Schedule Cloud Flow to Export the Data as Excel

Test the Solution

Use Case 10: How to Update the Status of SharePoint Item with Microsoft Form What if you have list of actions on a SharePoint list and you need people to update item status by just filling a form. This use case will help address this challenge

Create Microsoft Forms for Item Update

Create Power Automate Flow to Update SharePoint List Item Status

Use Case 1: Employee Check-In Button with Power Automate
Learn how to automate employee check-in and check-out activities with Microsoft Power Automate.

Use Case 2: Automate Employee’s Birthday Celebration
Employers can get more closer to their employees by celebrating them on a day that matters. Birthday is one of those days.

Use Case 3: Automate Employee Work Anniversary
Celebrate your employees on their work anniversary and take the task away from your HR team.

Use Case 4: Create a Learning Management Solution with Forms and Power Automate
Leverage on Microsoft Forms and Power Automate to Create a Learning Management Solution for your organization

Use Case 5: Event Registration Management Automation
Learn how to leverage on Microsoft Power Automate to drive an automated event registration session

Use Case 6: On-Field Verification App with Power Automate and SharePoint List
Create a Power Automate Button flow to carry out field verification activities.

Use Case 7: Automating Recruitment Process with MS Forms and Power Automate
Leverage on Microsoft Forms, OneDrive, SharePoint and Power Automate for automating recruitment process in your organization

Use Case 8: Send Weekly Report as HTML Table via Email
How can you embed HTML table in your email content? This use case will address it

Use Case 9: Send Weekly Report as Excel Attachment via Email
What if you will prefer to have your weekly report as Excel File attached as the content of your Email? Let's do that together in this use case

Use Case 10: How to Update the Status of SharePoint Item with Microsoft Form
What if you have list of actions on a SharePoint list and you need people to update item status by just filling a form. This use case will help address this challenge

Use Case 11: Bulk Update of List Item with Excel File from MS Form Upload
What if you want to do a batch upload or creation of items on a SharePoint List, can you just upload the file via MS Form and have them created on SharePoint List? Yes, It is possible.

Use Case 12: Automate Memo Approval Process
How do you automate the Memo Approval process in your organization? Power Automate can be leveraged on to get this done.

Use Case 13: Automate Memo Approval with Multiple File Uploads
This use case addresses how to handle multiple files uploaded in MS Forms within Power Automate Approval and Email Attachment

Use Case 14: Run a Schedule Cloud Flow Once
How do you get a flow to run at a particular time and for once? With a Schedule Cloud Flow, It can run at a particular time but will have to be repeated. This use case will show you a way around it

Use Case 15: Populate a MS SQL Database Table with Table coming from MS Forms
How can you use Microsoft Power Automate to Communicate with your Database? we will establish the connection and also build a flow that populates the database table with responses from MS Forms

Use Case 16: Schedule Report Spooling from MS Database Using Power Automate
We will create a Power Automate Flow that will run on schedule to spool reports from MS SQL Database, export the report to Excel and send as attachment via Email

Multiple Forms, How to Tie Them Together
We have created multiple forms and links. how do we get them coordinated and make them easily accessible?

This is not the End
Yeah, the topic reads 15+ Use Cases and not 15 Use Cases. so expect to see more use cases added frequently

Bonus Track
There is more for you. In this Module, You will build your first Microsoft Power Apps, Learn about Microsoft Certifications and how to get FREE Vouchers. get ready to explore this career path