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
Introduction
- Create robots with Power Automate desktop
- What you should know
Get Started With Power Automate Desktop
- Overview and your first robot
Variables and Logic
- Variables
- Data tables - Part 1
- Data tables - Part 2
Applications
- Read an Excel sheet - Data tables
- Iterate through Excel data
- Applications
- Selectors
Browsers
- Log in to a web page
- Check the state of a web page
- Selectors
- Web scraping
Complete Use Case
- Web scraping - Advanced
- Regular expressions
- Find last page
- Loop through all pages
- Scrape all pages
- Excel
- Date
Advanced
- Outlook send emails
- Format emails - Date and HTML
- REST API calls and JSON parsing
- Working with dates in JSON
Conclusion
- Next steps