Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Power Automate Desktop - For Advanced Users
Getting Ready
Download the lesson files (0:34)
Install Microsoft Power Automate Desktop (2:33)
Connect to the cloud portal (Machine Runtime) (1:14)
Intro to SQL Server Management Studio (17:32)
Install Visual Studio (1:03)
A Reusable Configuration File
Intro
Build the basic flow (11:20)
Prepare the config (3:26)
A reusable config (9:18)
Use the config (4:54)
Different environments (5:16)
Config in future flows (3:38)
Advanced Error Handling and Resilience
Intro
Prepare data (3:25)
Build the initial part (5:29)
Page state validation 1 (5:15)
Page state validation 2 (2:55)
Read Excel (4:10)
For each and business exception check (2:05)
Ensuring UI stability (6:36)
Prepare web search (8:13)
Do the web search and reset (4:48)
Action-based error-handling (3:45)
Data extraction & Wait for web page content (10:38)
Write to Excel including transaction status (8:49)
Error handling on block of actions (3:32)
Flow recovering (3:09)
Notify different users (separate desktop flow) (11:34)
Input Validation
Intro
Start solving the case (8:02)
Reset and launch system (5:30)
UI validation and retries (9:10)
Input validation (4:00)
Input validation (zip code) (5:01)
Input validation (email) (6:45)
Input validation (name) (3:17)
Type and dynamic waits (7:30)
Write the status to Excel (3:37)
Create a detailed Log
Intro
Build the basics (19:34)
Status and result log (8:47)
An advanced flow run log (15:30)
Log message to Power Automate Cloud (3:40)
Reporting with SQL
Intro
Notify the developer (8:06)
Notify the business user (3:13)
Notify the management - Create a SQL database (5:52)
Notify the management - Add flow name to database (7:52)
Notify the management - Add case to database (8:36)
Notify the management - Implement 2 x SQL flows (4:54)
Notify the management - Send email (5:02)
Custom C# Actions
Intro
Build the basics (13:24)
Create a Custom C# Action (9:51)
Create and import certificate (6:31)
Signing the files (4:48)
Compress the files (5:56)
Upload to Power Automate cloud (5:33)
Use the Custom Action in Power Automate Desktop (5:33)
Work Queues
Intro
Preperations (8:34)
Read Excel (3:52)
Iterate data (4:37)
Data validation (5:50)
Create a Work Queue (3:10)
Dispatcher (7:23)
Performer (4:35)
Change the status of Work Queue items (8:39)
Other Work Queue actions (8:17)
Best Practices (coming November 22, 2024)
Best Practices
Now what?
AI and Automation Black Belt
An advanced flow run log
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock