Power Automate Duration: 10 Hours
Power Automate is an online workflow service that automates actions across the most common apps and services.
Program Objectives
In this module, you will:
- Create a flow that automatically saves email attachments
- Learn how to create a button flow to send yourself a reminder.
Course Curriculum
Module 1:Getting Started With Power Automate
- Using Power Automate templates
- Getting familiar with Environment
- Understanding type of flows
- Creating flow using template
- Creating flow from scratch using flow designer
- Creating flow using Manual trigger
- Creating recurring flow
- Creating Auto trigger flow
- Creating flow using Describing
- Editing a Power Automate flow
- Publish flow in Power Automate
- Run a flow
- Troubleshoot flows
- Turn off, Disable or delete a Power Automate
Module 2:Automation Using Excel
- Open Excel files and attach a process to an already opened file.
- Use the Excel group of actions to read data from and write data to an Excel file.
- Create and edit worksheets.
- Save and close Excel files.
Module 3:Automation Using Emails
- Monitoring email
- Setting up a flow for incoming emails
- Searching for email with specific subject and perform automation
- Build a cloud flow that's triggered in Outlook
- Trigger email if records gets added in Excel
- Trigger email if forms get submitted
- Trigger email if One drive or Sharepoint file updated etc.
Module 4:Automation Using MS Form
- Save record on excel file on submission
- Trigger email notification post submission of MS form
- Trigger email with responses or attachment to anyone post submission of MS form
- Using condition to trigger report
- Generate PDF of the records and share via email
- Sending email based on MS form field input
Module 5:Creating Approval Workflow
- Integration with MS teams
- Build an approval request
- Build a flow that processes an approval request
- Assigning approval to workflows
- Testing the absence process
- Adding reminders