• Post category:StudyBullet-7
  • Reading time:14 mins read


Practical Use Cases that brings immediate value to the Business

What you will learn

Get Familiar with Microsoft 365 Collaboration and Productivity Apps

Understand When to Use Microsoft Power Automate

Understand How Power Automate can be of great value in your career advancement journey

Learn by doing, various use cases of Microsoft Power Automate

Learn about the Career Path for a Power Platform Developers

Learn how to get FREE Certification Vouchers for Power Platform Exams

Description

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 with it.  In this video, you will learn by doing as we will build together over 15 solutions to business challenges. these solutions can easily be replicated in your organization.

Imagine adding this skill to whatsoever you are into today? It will increase your competitiveness for the next job and earn you a good reputation in your organization.

While not everyone can learn the traditional programming languages, my focus is to support business people to learn a tool that can make them do more with less, and that is exactly what you will get in this course.


Get Instant Notification of New Courses on our Telegram channel.


As a manager, understanding the capabilities of Microsoft Power Automate can make you more valuable as you can suggest more ways for your direct to address business challenges.

As a new graduate, you need beyond the knowledge of MS Word, Excel, PowerPoint on your resume. You need productivity skills like SharePoint, OneDrive, MS Teams, Power Automate, Power Apps, etc. This course will introduce you to the majority of these tools and also upskill you with the use of Power Automate. Make sure you share your learning journey on Power Automate with any recruiter you face, I am sure it will be an interesting topic for them to look into.

This course was prepared with special consideration for people without knowledge of Microsoft 365. As an absolute beginner, you will learn the basics of Microsoft 365 and then appreciate how Microsoft Power Automate makes life easier at work.

Don’t just take this course, gift it and also recommend it to people in your organization.

English
language

Content

Introduction – You are welcome

Introduction – Welcome to the Course
Why Learn Microsoft Power Platform
The 2nd Wave of Digital Transformation
Course Pre-requisite

Microsoft 365 Apps and Services

Introducing Microsoft 365
Create a Microsoft Developer Account for Free
Intro to Microsoft teams
Analyze Your Teams Data Using Microsoft 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
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

Use Case Description
Create The SharePoint List Backend
Create Microsoft Power Automate Button
Test the Solution and Share

Use Case 2: Automate Employee’s Birthday Celebration

Use Case Description
Create SharePoint List
Create Power Automate Flow
Test the Solution

Use Case 3: Automate Employee Work Anniversary

Use Case Description
Create SharePoint List
Create Microsoft Power Automate Flow Pt1
Create Microsoft Power Automate Flow Pt2
Test the Solution

Use Case 4: Create a Learning Management Solution with Forms and Power Automate

Use Case Description
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 Form
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

Use Case Description
Create a Microsoft Teams Group for the Event
Create a Registration Form with MS Forms
Create Power Automate Flow for Communication
Testing the Solution

Use Case 6: On-Field Verification App with Power Automate and SharePoint List

Use Case Description
Create a SharePoint List
Create a Power Automate Button
Test and Share the Solution

Use Case 7: Automating Recruitment Process with MS Forms and Power Automate

Use Case Description
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 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

Use Case Description
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

Use Case Description
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

Use Case Description
Create Microsoft Forms for Item Update
Create Power Automate Flow to Update SharePoint List Item Status
Test the Solution

Use Case 11: Bulk Update of List Item with Excel File from MS Form Upload

Use Case Description
Create MS Forms for Bulk Update
Create a Flow to Populate SharePoint List with Excel File Content Part 1
Create a Flow to Populate SharePoint List with Excel File Content Part 2
Test the Solution

Use Case 12: Automate Memo Approval Process

Use Case Description
Create Microsoft Forms for Request Submission
Create a SharePoint List Backend
Create Power Automate Flow for Routing Approvals
Test the Solution

Use Case 13: Automate Memo Approval with Multiple File Uploads

Use Case Description
Create SharePoint Document Library
Create Microsoft Forms for Multiple File Upload
Create The Flow
Test the Solution

Use Case 14: Run a Schedule Cloud Flow Once

Use Case Description
Create a Schedule Cloud Flow and Make it Run Once

Use Case 15: Populate a MS SQL Database Table with Table coming from MS Forms

Use Case Description
Create MS SQL Database Table
Create a Microsoft Forms
Install and Configure Data Gateway
Create Connection to Data Gateway in Flow
Create Power Automate Flow to Populate the Database Table with Forms Response
Test the Solution

Use Case 16: Schedule Report Spooling from MS Database Using Power Automate

Use Case Description
Create Store Procedure in MS SQL Server Database
Installing and Configuring a Data Gateway
Create Gateway Connection for MS SQL Server
Create Power Automate Flow to Spool Report and Send as Email Attachment
Test the Solution

Multiple Forms, How to Tie Them Together

How to Manage Multiple Forms and Links in an Organization
Let’s get it Done

This is not the End

How Can this be the End?

Bonus Track

Introduction to Microsoft Power Apps
Use Case Description
Create a SharePoint Backend for the App
Create Your First App in 5 Minutes
Get Familiar with Power Apps Environment
Add More Screens to Your App
Apply Theme on Your App
How to Share Your App
Microsoft Certifications for Power Platform Developer
How to Get Microsoft Exam FREE Vouchers