Microsoft Power Automate RPA Developer

Module 1: Take your first steps with Power Automate for Desktop

• Introduction to Power Automate for desktop

• Console overview

• Flow designer overview

• Create a simple flow

• Exercise – Create and run a simple flow

• Check your knowledge

• Summary

Module 2: Power Automate for Desktop Development Essentials

• Introduction to Power Automate for desktop development

• Create a flow in the flow designer

• Create conditionals and loops

• Using subflows

• Test and debug flows

• Manage UI elements and images

• Deploy exception handling

• Check your knowledge

• Summary

Module 3: Build your first Power Automate for Desktop Flow

• Introduction

• Set up the environment

• Explore Power Automate for desktop

• Create your first Power Automate for desktop flow

• Record Power Automate for desktop actions

• Edit and test recorded actions

• Check your knowledge

• Summary

Module 4: Define Input and Output Parameters in Power Automate

• Introduction

• Set up in Power Automate

• Define an input variable

• Set input variables

• Define output variables

• Add UI elements and test

• Check your knowledge

• Summary

Module 5: Integrate Desktop Flows with Outlook Connector in Power Automate for Desktop

• Introduction

• Setup process in Power Automate

• Build a cloud flow that’s triggered in Outlook

• Test your new flow

• Check your knowledge

• Summary

Module 6: Connect a Cloud Flow to Desktop Flows in Power Automate for Desktop

• Introduction

• Setup in Power Automate for desktop

• Create a new cloud flow

• Connect your cloud and desktop flows

• Test your new connection

• Check your knowledge

• Summary

Module 7: Use AI Builder to Process Invoice Forms in Power Automate

• Introduction

• Solution setup in Power Automate

• Create a form processing flow

• Add fields and collections of documents

• Analyze and train a model

• Integrate the model into a cloud flow

• Check your knowledge

• Summary

Module 8: Use the Teams Connector in Power Automate

• Introduction

• Work from an existing solution in Power Automate

• Create an approval solution

• Integrate with an existing desktop flow

• Build communication with Outlook

• Test and run a flow

• Check your knowledge

• Summary

Module 9: Run a Power Automate for Desktop Flow in Unattended Mode

• Introduction

• Set up an unattended desktop flow

• Create a new cloud flow that calls an existing flow in unattended mode

• Perform a test run

• Best practices

• Check your knowledge

• Summary

Module 10: Optimize your Business Process with Process Advisor

• Introduction

• Get familiar with process advisor

• Create your first recording

• Edit recordings and group actions

• Analyze recordings and interpret results

• Automation recommendations

• Check your knowledge

• Summary

Module 11: Handle Variables in Power Automate for Desktop

• Introducing variables

• Create, edit, and use variables

• Variable data types

• Advanced data types

• Input and output variables

• Variable manipulation

• Sensitive variables

• Exercise – Create, access and manipulate variables

• Check your knowledge

• Summary

Module 12: Automate Repetitive Tasks using Loops in Power Automate for Desktop

• Introduction to loops

• Loop actions

• Simple loop actions

• For each loop actions

• Loop condition actions

• Exercise – Loops

• Check your knowledge

• Summary

Module 13: Adjust Process Behavior using Conditional Actions with Power Automate for Desktop

• Introduction to conditional actions

• Conditional actions

• The If group of actions

• Exercise – If group of actions

• The Switch group of actions

• Check your knowledge

• Summary

Module 14: Configure Flow Control in Power Automate for Desktop

• Introduction

• Flow control actions

• Check your knowledge

• Summary

Module 15: Generate Power Automate for Desktop Flows by Recording

• Introduction to the Power Automate for desktop recorder

• Create desktop flows using the recorder

• Exercise – Use the recorder to automate web applications

• Exercise – Use the recorder to automate desktop applications

• Check your knowledge

• Summary

Module 16: Configure Exception and Error Handling in Power Automate for Desktop

• Introduction

• About exceptions

• Exception handling

• Exercise – Exception handling

• Check your knowledge

• Summary

Module 17: Control File and Folder Handling in Power Automate for Desktop

• Introduction

• Folder actions

• File actions

• Exercise – Create a backup copy of the desktop folder

• Check your knowledge

• Summary

Module 18: Web Automation in Power Automate for Desktop

• Introducing web automation

• Launch, close, and handle browsers

• Handle web pages and forms

• Extract data from web pages

• Direct web access and scripting

• Exercise – Extract stocks from MSN

• Check your knowledge

• Summary

Module 19: Use Power Automate for Desktop to Interact with Windows and Applications

• Introduction

• UI elements

• Window handling and element interaction

• Check your knowledge

• Summary

Module 20: Excel Automation in Power Automate for Desktop

• Introduction

• Launch, save, and close an Excel file

• Read from an Excel document

• Write to an Excel worksheet

• Additional actions and features

• Manage worksheets

• Exercise – Organize data in a spreadsheet

• Check your knowledge

• Summary

Module 21: Automating Email Handling in Power Automate for Desktop

• Introducing email automation

• Automate webmail services

• Automate Outlook

• Automate Exchange servers

• Exercise – Confirm the submission of support tickets

• Check your knowledge

• Summary

Module 22: Automate System, Workstation, and Services Actions in Power Automate for Desktop

• Introduction

• System and workstation actions

• Services actions

• Check your knowledge

• Summary

Module 23: Communicate using Message Boxes in Power Automate for Desktop Flows

• Introduction to message boxes

• Message box actions

• Exercise – Use message boxes to communicate

• Check your knowledge

• Summary

Module 24: Text Manipulation in Power Automate for Desktop

• Introduction

• Text handling actions

• Date time actions

• Exercise – Text actions

• Check your knowledge

• Summary

Module 25: Simulate Mouse and Keyboard Actions by using Power Automate for Desktop

• Introduction

• Mouse and keyboard actions

• Exercise – Simulate mouse and keyboard actions

• Check your knowledge

• Summary

Module 26: Combine Power Automate Desktop and Cloud Flows

• Introduction to running Power Automate desktop flows from cloud flows

• Run a Power Automate desktop flow from a cloud flow

• Exercise – Create a cloud flow that calls a Power Automate desktop flow

• Check your knowledge

• Summary

Module 27: Database Handling in Power Automate for Desktop

• Introduction

• Database actions

• Check your knowledge

• Summary

Module 28: Active Directory Handling in Power Automate for Desktop

• Introduction

• Active Directory actions

• Exercise – Create a new Active Directory user

• Check your knowledge

• Summary

Module 29: Scripting in Power Automate for Desktop

• Introduction

• Scripting actions

• Exercise – Calculate modulo with VBScript

• Exercise – Use JavaScript to find the last day of the current month

• Check your knowledge

• Summary

Module 30: OCR Technologies in Power Automate for Desktop

• Introducing OCR technologies

• OCR actions

• Exercise – Extract data from images

• Check your knowledge

• Summary

Module 31: Get Started with Custom Connectors in Power Automate

• Introduction

• Demo of the maker portal experience

• Explore custom connector configuration options

• Exercise – Create a new connector in a solution

• Use a custom connector

• Exercise – Use a connector from Power Automate

• Check your knowledge

• Summary

Module 32: Configure Custom Connectors with Authenticated APIs in Power Automate

• Introduction

• Authentication options

• Use APIs with Azure AD

• Configure Azure Active Directory authentication

• Exercise – Use graph API from a custom connector

• Share and move between environments

• Check your knowledge

• Summary

Module 33: Introduction to Microsoft Power Platform Security and Governance

• Introduction

• Identify Microsoft Power Platform environments

• Data Loss Prevention policies

• Microsoft Power Platform Center of Excellence Starter Kit

• Exercise – Create a Power Platform environment

• Check your knowledge

• Summary