1. Introduction FREE CHAPTER

• What Is Power Automate Desktop?
• Different Types of Flows
• Features of Power Automate Desktop
• Why Learn Power Automate Desktop?
• Course Roadmap
• Keys to Success
• Instructor Overview

2. Beginner - Basic Flows

• Download Power Automate for Desktop
• Environment Walkthrough
• Introduction to New Flow Screen
• Create a Simple Flow - Create a Text File
• Add an Action and Action Parameters
• Run a Flow
• Modify Flow Settings
• Add More Than One Action into a Flow
• Add Input Variables into a Flow and Use Them in a Flow
• Add Input Variables into a Flow and Use Them in a Flow - Continued
• Use Output Variables in Subsequent Actions

3. Beginner - Files and Folders

• Copy Actions - Move and Copy
• Copy Actions - Move and Copy Continued
• Read and Writes
• Read and Writes Continued
• Read and Writes CSV Data
• Get Subfolders
• Get Files in Folders
• If Folder Exists
• If Folder Exists Continued

4. Beginner - Folders and Compression

• Delete Actions
• Get Special Folder
• Compression - Compress
• Compression - Uncompress

5. Beginner - Text and Date

• Text Manipulation
• Text Manipulation Continued
• Text Manipulation - Conversions and Date / Time
• Create Random Text
• Escape Text for Regular Expression
• Recognize Entities in Text

6. Beginner - Email and Outlook

• Retrieve Email Message from Outlook
• Process Emails
• Process Emails Continued
• Send Email Messages in Outlook

7. Intermediate - Inputs and Message Box

• Display Message
• Display Input Dialog
• Display Select File Dialog
• Display Select from List
• Display Custom Form

8. Intermediate - Conditions, Variables, and Loops

• Introduction to Variables
• Lists
• Lists from File
• Lists from Data Source
• Working with Multiple Lists
• Working with Additional Information (Dot Notation)
• IF Statements
• ELSE Statements
• ELSE IF Statements
• SWITCH Statements
• SWITCH Run
• Loops - For Each
• Loops - Loop
• Loops - Loop with Variable
• Loops - Loop Condition
• Loops - Loop Condition - Logic
• Loops - Next and Exit
• Loops - Nested Loops
• Loops - Using Loops - Examples in Files and Emails

9. Intermediate - Flow Action Controls

• Wait and Stop
• Go To and Label
• Subflow
• Subflow Run
• Error Handling
• Errors, Debug, and Next Action

10. Intermediate - UI Automation

• Introduction to UI Automation
• UI Automation - Navigation
• UI Automation - Navigation and Programs
• UI Automation - Data Entry UI Picker
• UI Automation - Data Entry Images, Send Keys, and Move Mouse

11. Intermediate - Excel

• Excel - Open and Read
• Excel - Write, Worksheets, Save, and Close
• Excel - Other Actions

12. Expert - Browser Automation

• Open Browser and Navigate to Web Page
• Download from Web Browser
• Form Fill and Data Extraction

13. Expert - Records

• How to Use Desktop Recorder
• Web Recorder

14. Expert - Database and HTTP

• SQL Database and HTTP

15. Expert - PDF and OCR

• Extract from PDF

16. Expert - Cloud Flow Integration

• Set Up for Integration
• Instant Cloud Flow
• Scheduled Cloud Flow
• Output Variables and Automated Triggers
• Run from Automated Cloud Flow and Return Data

17. Advanced - Systems

• Launch a Program
• Environment Variables

18. Advanced - CMD Actions

• Open CMD, CMD
• Write to, Read from CMD

19. Advanced - Scripting Actions

• Python
• PowerShell

20. Advanced - Workstation Actions

• Print and User Control
• Sound and Screen Resolution
• Screen Capture

21. Advanced - Other Actions

• Available Resources and Process Advisor

22. Conclusion

• Congratulations
• Next Steps