Learning Power Automate Desktop for Developers

1h 45mIntermediate2023-02-03

Authors

Anders Jensen

RPA Teacher | Microsoft MVP and Power Automate Specialist

Course details

Do you need to transition your development to Power Automate Desktop? In this course, RPA teacher and Power Automate specialist Anders Jensen guides you through how to use Power Automate Desktop without compromising RPA developer best practices. Learn how to get started with Power Automate Desktop. Go over variables and data tables, and explore how to read and interpret Excel data, use Power Automate to update each row in an Excel sheet, open applications, and more. Find out how to use Power Automate with web browsers, and then step through complete use cases. Plus, discover advanced functions like using Power automate to send and format emails, parse REST API calls and JSON responses, and work with JSON and Datatime.

Skills covered

Business IntelligenceLearningData ScienceBusiness Analysis and Strategy

Concepts

0. Introduction

01 - Create robots with Power Automate desktop
02 - What you should know

1. Get Started With Power Automate Desktop

03 - Overview and your first robot

2. Variables and Logic

04 - Variables
05 - Data tables - Part 1
06 - Data tables - Part 2

3. Applications

07 - Read an Excel sheet - Data tables
08 - Iterate through Excel data
09 - Applications
10 - Selectors

4. Browsers

11 - Log in to a web page
12 - Check the state of a web page
13 - Selectors
14 - Web scraping

5. Complete Use Case

15 - Web scraping - Advanced
16 - Regular expressions
17 - Find last page
18 - Loop through all pages
19 - Scrape all pages
20 - Excel
21 - Date

6. Advanced

22 - Outlook send emails
23 - Format emails - Date and HTML
24 - REST API calls and JSON parsing
25 - Working with dates in JSON

Conclusion

26 - Next steps