Microsoft Power Automate for End Users

Module 1: An Introduction to Power Automate

Let’s get started with an introduction to Microsoft Power Automate. Historically, automating business

processes typically landed in the lap of a developer in the business, who has a good understanding of

coding and the systems that they were connecting. However, more and more systems deployed to

businesses are encouraging a bigger focus on end user design and management. With this culture

change, end users are looking to further improve their business solutions. Power Automate brings

workPower Automate design to all audiences. It offers the building blocks for lightweight or businesscritical processes. In this module, we cover an overview of the product and its application to Office 365 and third-party services.

Lessons

• What is Microsoft Power Automate?
• The benefits of automation
• How to get to Power Automate

Lab: Setup Your Tenant

• Setup Office 365
• Download Course Files
• Customise your App Launcher
• Create accounts for colleagues

After completing this module, students will be able to:

• Know what Microsoft Power Automate is
• Know the benefits of using Power Automate to automate processes
• Access a Power Automate

Module 2: Getting Started with Power Automate

We begin our discovery of Microsoft Power Automate by building our first business process. We will

discuss how to use templates to get started with Power Automate or how to use a blank template to

start with no defined actions. Once in the product, we will give you a tour of the editor, workPower

Automate management page and the home screen to help you navigate around the product. Next, we

will start to add, edit and remove actions from our workPower Automate template in order to

customize the Power Automate for a specific business need. Once ready we will publish and trigger the

workPower Automate to test that it works as expected. We will finish this module by discussing how to

turn a Power Automate on or off as well as deleting a Power Automate.

Lessons

• Using Power Automate templates
• Navigating in Power Automate
• Editing a Power Automate
• Publish and trigger a Power Automate
• Turn off or delete a Power Automate

Lab: Building Processes in Office 365

• Create a Team with a channel
• Build an absence business process
• Testing the absence process
• Optional: Create Feedback Form
• Optional: Power Automate to Notify of Bad Ratings
• Optional: Test your Form and Power Automate

After completing this module, students will be able to:

• Use Power Automate templates
• Navigate around Power Automate
• Edit Power Automates
• Publish and trigger Power Automates
• Turn off or delete Power Automates

Module 3: Power Automate Logic

Decision making during a business process is often a bottleneck. Waiting for decisions or information to

steer the workPower Automate towards its goal is dependent on how long the involved party spends on

the task. This could be mitigated if the desired information is found declared elsewhere for example, as

a document property or a form entry to name a few examples. Logic in a workPower Automate allows

existing information to push the workPower Automate down multiple paths. This often speeds up

workPower Automate duration and minimizes human input. In this module, we will look at the core

logic found in Power Automate and a practical application of each option.

Lessons

• Adding conditions
• Designing switches
• Using apply to each
• Configuring do until logic
• Adding a scope

Lab: Scheduling Documentation Reviews

• Setup a policy library in SharePoint
• Design a policy review schedule
• Testing the policy review process
• Optional: Notify if a file nears review

After completing this module, students will be able to:

• Add conditions in a Power Automate
• Design switches for a Power Automate
• Use apply to each
• Configure do until logic
• Add a scope

Module 4: Integration

Businesses will often use a selection of productivity tools and services beyond Office 365. Marketing

teams may use Facebook and Twitter whereas a sales team may use Salesforce to manage their

customers. Power Automate provides connectors for popular services allowing your processes to extend

beyond Office 365 to other web services. Connections can even be made to on-premises servers,

allowing your business systems house at the office to take part in your processes.

Lessons

• Standard and premium connectors
• Connecting to web services
• Using Power Automate with on-premises data

Lab: Using Power Automate and SQL to Review Sales

• Create a new orders list
• Designing the price check process
• Testing the price check process
• Optional: Update with managers

After completing this module, students will be able to:

• Use Standard and Premium connectors
• Connect to web services
• Use Power Automate with on-premises data

Module 5: The Mobile App

Power Automate has a corresponding mobile app that can be used to leverage many features of Power

Automate. Firstly, it offers users the capability to build new Power Automates, directly from their phone

or tablet. Secondly, it can be used to manage existing Power Automates including editing, viewing

history, saving a copy, disabling and deleting Power Automates. You can access any approvals that have

been sent to you by Power Automate and approve or reject decisions. The app also supports the push

notifications that can be sent to your phone or tablet from a Power Automate. Additionally, you can

even create buttons that appear in the app which allow you to trigger Power Automates. This valuable

app will be detailed in this module.

Lessons

• Downloading the mobile app
• Signing in and account management
• Building and managing Power Automates
• Creating buttons
• Feeds and approvals

Lab: Optional: Using the Power Automate mobile app

• Setting up the Power Automate mobile app
• Create a new Power Automate in the mobile app
• Using Power Automate buttons in the app
• Uninstall the Power Automate mobile app

After completing this module, students will be able to:

• Download the mobile app
• Sign into the mobile app
• Build and manage Power Automates in the mobile app
• Create buttons in the mobile app
• Feed and use approvals in the mobile app

Module 6: Administration and Maintenance

In our last module for Microsoft Power Automate, we will be taking a look at how a business can

manage their Power Automates once they have a good uptake of the product. We will begin by

discussing managing individual Power Automates. This could be using history to discover the source of

any issues and implement error handling as well as using the analytics to discover usage trends. We will

discover how to share a Power Automate which is ideal for sharing the maintenance of a Power

Automate with another colleague and how to import and export Power Automates. Finally, we will

discuss how Office 365 administrators can shape the Power Automate experience with high-level

settings that help ensure data segregation and security.

Lessons

• Maintaining a Power Automate
• View history and analytics
• Sharing a Power Automate
• Export and import Power Automates
• Office 365 administration for Power Automate
• Environments
• Data policies
• Data integration

Lab: Maintaining your Power Automates

• Share a Power Automate with a colleague
• Disabling an active Power Automate
• Deleting a Power Automate

After completing this module, students will be able to:

• Maintain a Power Automate
• View history and analytics for a Power Automate
• Share a Power Automate
• Export and import Power Automates
• Administrate a Power Automate in Office 365
• Use data policies in a Power Automate
• Use data integration in a Power Automate