Prerequisites:
- Microsoft 365 Business or Enterprise Plan
Duration: 5 days
Module 1: Introduction to Microsoft Power Automatez
- Understanding the concept of Robotic Process Automation (RPA)
- Overview of Power Automate Desktop and its capabilities.
- Cloud flows vs Desktop flows
- Installation and setup of Power Automate Desktop
Module 2: Navigating the Desktop Flow
- Working with Desktop flow designer
- How to create desktop flow
Module 3: Variables and Lists
- Setting variable
- Increasing and decreasing variables
- Working with List of Values
Module 4: Conditionals
- Working with IF and Else
- Working with Switch, Case
- Manipulating file and folder based on condtions
Module 5: Reiteration of process in Desktop flows.
- Working with Loop, Loop Condition,
- Working with Next Loop and Exit Loop
Module 6: Program Automation
- Manipulating data in Excel
- Automation in encoding from the Web
- Automation in managing Folders
- Automation in managing files.
- Data manipulation in Text
Module 6: Email Automation
- Retrieve, filter, process and send emails
- Working with Outlook automation
Module 7: PDF Automation
- Extract Images from PDF
- Extract Text from PDF
- Extract PDF pages to new PDF
- Merge PDF Files
- Extract Tables from PDF
Module 8: Web Scrapping and Automation
- Sample Desktop flows for Excel Automation Collating information from the Web
- Working with UI Elements
- Handling dynamic UI Elements for Web Pages
- Web data extraction
- Web actions such as form filling
Module 9: UI Automation: To run a desktop program
- Form filling actions
- Get details of Window
- Get details of UI elements in Window
- Get selected ration button in Window
- Get selected checkbox button in Window
- Extract data from Window
- Web recorder
- Desktop recorder
Module 10: Power Automate Administration
- Creating and switching environments
- Exporting and importing Desktop Flows
- Understanding on-premise gateway
- Trigger Power Automate desktop flows from another flow
- Exception handling
- Action Level Exception handling
- Block Level Exception handling
- Schedule and monitor desktop flows
