A reusable config | andersjensenorg

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

A reusable config

Complete and Continue

Discussion

4 comments