Power Automate Desktop - For Advanced Users

Including Logging, Error Handling and Custom C# Actions

What you'll learn

Create and manage real-world automation workflows by building 10 hands-on projects from start to finish using Microsoft Power Automate Desktop

Develop advanced error-handling and data validation skills to ensure reliable and accurate automation processes in any business environment

Design custom actions using C# and implement advanced techniques such as logging, reporting, and workflow optimization

Apply the Dispatcher/Performer architecture and human approval flows to create efficient, scalable, and flexible automation solutions

Requirements

Learners should have a good understanding of Power Automate Desktop basics and feel confident building simple automation flows. Familiarity with basic flow actions, variables, and conditions is recommended to get the most out of this advanced course

Description

Here’s the updated version with five additional words:This course is perfect for advanced Microsoft Power Automate Desktop users who want to improve their automation skills. You will follow step-by-step videos to create 10 real-world automation projects from start to finish.You’ll learn how to set up automations, fix errors, and check data to ensure it’s correct. We’ll also cover advanced topics like logging, reporting, and making custom actions with C#. Plus, you’ll learn how to manage work queues, use dispatchers and performers, and create approval flows that need human decisions.By the end of this course, you’ll know the best ways to build reliable and scalable automations for real-world business needs and future challenges.What You’ll Learn:Build 10 automation projects step-by-stepMake custom actions with C#Set up logging and reportingUse Power Automate Cloud for scheduling and approvalsMaster error handling and data validationApply the Dispatcher/Performer model to make workflows more efficientWith our hands-on lessons, you’ll gain practical skills to automate tasks, connect systems, and improve business processes. This course will teach you how to use Microsoft Power Automate Desktop in your workplace confidently.Note: The course is updated regularly to include new features and best practices for Microsoft Power Automate Desktop.

Overview

Section 1: Getting Ready

Lecture 1 Download the lesson files

Lecture 2 Install Microsoft Power Automate Desktop

Lecture 3 Connect to the cloud portal (Machine Runtime)

Lecture 4 Intro to SQL Server Management Studio

Lecture 5 Install Visual Studio

Section 2: A Reusable Configuration File

Lecture 6 Intro

Lecture 7 Build the basic flow

Lecture 8 Prepare the config

Lecture 9 A reusable config

Lecture 10 Use the config

Lecture 11 Different environments

Lecture 12 Config in future flows

Section 3: Advanced Error Handling and Resilience

Lecture 13 Intro

Lecture 14 Prepare data

Lecture 15 Build the initial part

Lecture 16 Page state validation 1

Lecture 17 Page state validation 2

Lecture 18 Read Excel

Lecture 19 For each and business exception check

Lecture 20 Ensuring UI stability

Lecture 21 Prepare web search

Lecture 22 Do the web search and reset

Lecture 23 Action-based error-handling

Lecture 24 Data extraction & Wait for web page content

Lecture 25 Write to Excel including transaction status

Lecture 26 Error handling on block of actions

Lecture 27 Flow recovering

Lecture 28 Notify different users (separate desktop flow)

Section 4: Input Validation

Lecture 29 Intro

Lecture 30 Start solving the case

Lecture 31 Reset and launch system

Lecture 32 UI validation and retries

Lecture 33 Input validation

Lecture 34 Input validation (zip code)

Lecture 35 Input validation (email)

Lecture 36 Input validation (name)

Lecture 37 Type and dynamic waits

Lecture 38 Write the status to Excel

Section 5: Create a Detailed Log

Lecture 39 Intro

Lecture 40 Build the basics

Lecture 41 Status and result log

Lecture 42 An advanced flow run log

Lecture 43 Log message to Power Automate Cloud

Section 6: Reporting with SQL

Lecture 44 Intro

Lecture 45 Notify the developer

Lecture 46 Notify the business user

Lecture 47 Notify the management - Create a SQL database

Lecture 48 Notify the management - Add flow name to database

Lecture 49 Notify the management - Add case to database

Lecture 50 Notify the management - Implement 2 x SQL flows

Lecture 51 Notify the management - Send email

Section 7: Custom C# Actions

Lecture 52 Intro

Lecture 53 Build the basics

Lecture 54 Create a Custom C# Action

Lecture 55 Create and import certificate

Lecture 56 Signing the files

Lecture 57 Compress the files

Lecture 58 Upload to Power Automate cloud

Lecture 59 Use the Custom Action in Power Automate Desktop

Section 8: Work Queues

Lecture 60 Intro

Lecture 61 Preperations

Lecture 62 Read Excel

Lecture 63 Iterate data

Lecture 64 Data validation

Lecture 65 Create a Work Queue

Lecture 66 Dispatcher

Lecture 67 Performer

Lecture 68 Change the status of Work Queue items

Lecture 69 Other Work Queue actions

Section 9: Best Practices

Lecture 70 Best practices

This course is ideal for advanced Microsoft Power Automate Desktop users who want to expand their automation skills and build scalable, real-world workflows. It’s perfect for professionals looking to optimize business processes, IT specialists aiming to streamline operations, and automation enthusiasts ready to tackle advanced topics like error handling, logging, and custom actions