Power Automate Desktop Fundamentals & RPA Automation

Day 1 - Power Automate Desktop Fundamentals

Introduction to RPA

• What is Robotic Process Automation?

• RPA use cases

• Identifying repetitive business processes

• Power Automate Desktop overview

• Desktop flows vs. cloud flows

• Understanding actions and flows

• Creating and running your first desktop flow

Working with Actions

• Understanding actions

• Adding and configuring actions

• Action properties

• Input and output variables

• Searching for actions

• Running and debugging flows

• Reading flow execution results

Variables and Data

• Creating variables

• Text and numeric variables

• Boolean values

• Lists

• Data tables

• Working with variable values

• Converting data types

• String manipulation

Conditions and Loops

• If / Else conditions

• Multiple conditions

• Switch

• For loops

• For Each loops

• Loop conditions

• Breaking and continuing loops

Day 2 - Excel, Files and Web Automation

File and Folder Automation

• Create folders

• Copy files

• Move files

• Rename files

• Delete files

• Search for files

• Get file properties

• Work with paths

• Process multiple files

Excel Automation

• Open Excel

• Create workbooks

• Read Excel data

• Write data to Excel

• Work with worksheets

• Read ranges

• Write ranges

• Work with tables

• Process rows

• Save and close Excel

• Automate repetitive Excel operations

Data Processing

• Working with Data Tables

• Filtering data

• Searching data

• Sorting data

• Extracting information

• Transforming data

• Creating summary information

Web Browser Automation

• Launching a browser

• Navigating websites

• Working with web elements

• Clicking buttons

• Entering information into forms

• Extracting information from web pages

• Working with browser tabs

• Handling dynamic web pages

Day 3 - Building Reliable RPA Solutions

Desktop Application Automation

• Launching Windows applications

• Finding UI elements

• Clicking controls

• Entering text

• Reading information

• Working with windows

• Keyboard and mouse automation

• Handling application dialogs

Text and Data Extraction

• Extracting text

• Working with clipboard data

• Text parsing

• Substrings

• Splitting text

• Replacing text

• Regular expressions basics

• Processing structured and semi-structured data

Error Handling

• Understanding errors

• Handling failed actions

• On-block-error configuration

• Retry strategies

• Validating data

• Creating robust flows

• Logging and troubleshooting

Subflows and Reusable Automation

• Creating subflows

• Organizing large flows

• Reusing automation logic

• Passing information between processes

• Designing maintainable desktop flows