Build desktop flows that automate Windows apps, browsers, Excel, and legacy systems, from attended bots to unattended RPA with Power Automate Desktop.
Power Automate Desktop lets you automate any Windows application — even legacy systems with no API — using a visual recorder and drag-and-drop actions. This hands-on lesson walks you through installation, your first recording, and running a real desktop flow from scratch. No coding required.
Master the data structures that power every real-world RPA flow. This lesson goes deep on variables, lists, and data tables in Power Automate Desktop — including type conversion, filtering, batch writes, and a full invoice processing exercise.
Go beyond simple recordings and build production-grade Excel automation with Power Automate Desktop. Learn how to read dynamic ranges, write data tables, execute VBA macros with parameter passing, and architect multi-workbook consolidation pipelines that hold up in the real world.
Learn how to build browser automation flows in Power Automate Desktop that open websites, fill in forms, and extract structured data — without writing code. This hands-on lesson walks through a realistic supplier portal scenario, covering element picking, table extraction, pagination, and timing management.
Broken selectors are the #1 reason RPA automations fail in production. This lesson teaches you how to read, edit, and build resilient UI element selectors in Power Automate Desktop — covering dynamic IDs, wildcard matching, timing strategies, and a systematic debugging workflow that works on real enterprise applications.
Legacy Windows applications with no APIs and no modern interfaces are some of the hardest automation targets — and some of the most valuable. This expert-level lesson teaches you to automate them reliably using Power Automate Desktop's UI automation engine, from accessibility tree inspection to production-hardened error recovery.
Learn how to build desktop flows that handle failures gracefully using On Block Error handlers, retry policies, and automatic recovery screenshots. This lesson takes you from brittle proof-of-concept to production-ready RPA with practical, hands-on techniques.
Learn how to architect Power Automate Desktop flows using subflows — named, callable units of logic with formal input and output parameters. Stop copy-pasting actions and start building automations you can actually maintain.
Learn how to build production-ready OCR automation in Power Automate Desktop that extracts structured data from scanned PDFs, images, and live screen regions. Covers text parsing, regex patterns, error handling, and full folder processing pipelines for real-world document workflows.
Learn how to build production-grade RPA integrations by passing dynamic inputs from cloud flows into Power Automate Desktop and returning structured outputs back. Covers attended and unattended modes, DataTable outputs, error patterns, and real-world architecture.
The choice between attended and unattended RPA determines your entire deployment architecture — not just a setting you pick at the end. Learn how to evaluate your process, register and configure machines, set up machine groups for scale, and avoid the session management pitfalls that break unattended bots in production.
Running a single RPA bot on one VM is a proof of concept. Running an automation fleet that handles enterprise workloads, survives machine failures, and scales with your business is an engineering discipline. This lesson teaches you the architecture, configuration, and operational patterns behind Power Automate machine groups — so your unattended bots run reliably at scale, not just on demo day.
Hardcoded credentials in RPA flows are a P1 security incident waiting to happen. Learn how to use PAD's sensitive variable type, retrieve secrets from Azure Key Vault through both cloud flow orchestration and direct HTTP calls, and build a credential subflow architecture that survives security audits and secret rotation without touching your flows.
Master production-grade file and email automation in Power Automate Desktop. Learn how to build reliable pipelines that process incoming files, manage dynamic folder structures, read and send Outlook emails with attachments, and wire everything together into a robust, self-monitoring bot.
Go beyond PAD's built-in actions by embedding PowerShell, Python, VBScript, and batch scripts directly in your desktop flows. Learn how variable injection works, how to return structured data, and how to build secure, maintainable scripting blocks for production RPA.
When you're running dozens of unattended bots across a machine fleet, "check the portal" stops being a monitoring strategy. Learn how to build production-grade observability for Power Automate desktop flows — from structured telemetry and automated alerting to systematic diagnostic frameworks for the five most common failure categories at scale.
The Power Automate Desktop Recorder converts your mouse clicks and keystrokes into reusable automation steps — no coding required. Learn how to record, clean up, and reliably replay desktop interactions in this hands-on foundation lesson.
Learn how to use Power Automate Desktop's built-in action library to launch applications, manage windows, and manipulate files with confidence. This lesson takes you from the basics of the action library structure to building a complete, realistic file-processing automation from scratch.
Windows dialogs and pop-ups are the silent flow-killers that freeze bots mid-run and derail production automations. This hands-on lesson teaches you exactly how to detect, respond to, and defensively handle every category of Windows dialog — from standard message boxes to file save prompts — so your flows keep running even when applications talk back.
Learn how to build a Power Automate Desktop flow that launches a Windows application, reads records from Excel, fills out forms field by field, and submits data reliably — even in legacy systems with no API. This hands-on lesson covers everything from UI element capture to loop structure and error recovery.
SAP GUI holds critical enterprise data but predates modern APIs by decades. This lesson shows you how to drive SAP reliably with Power Automate Desktop — navigating transactions with scripting IDs, extracting full ALV grid datasets, and building session recovery logic that keeps unattended flows running without human intervention.
Learn how to automate multi-sheet Excel workbooks in Power Automate Desktop without writing a single macro. This hands-on lesson covers reading tables, writing data to specific cells and ranges, navigating worksheets, and using named ranges to build flows that don't break when the spreadsheet changes.
Learn how to build a single Power Automate Desktop flow that extracts data from a Windows application, enriches it via browser lookups, and writes the results to Excel — with proper synchronization, error handling, and subflow architecture. This is the multi-application orchestration pattern that separates production-ready RPA from hobby scripts.
When Power Automate Desktop selectors can't reach an application — Citrix streams, custom-rendered controls, broken accessibility trees — image recognition and coordinate-based automation take over. This expert-level lesson teaches you how to build reliable, production-grade automations using template matching, OCR, and dynamic coordinate calculation, including fallback chains that gracefully degrade between all three techniques.
Learn how to read CSV and text files in Power Automate Desktop, parse delimited records, handle header rows correctly, and write processed data back to files. A hands-on guide for automating flat-file workflows from first principles.
Legacy systems don't give up their data easily — especially when they're running inside Citrix or IE. This lesson teaches you how to build Power Automate Desktop flows that reliably extract data from virtual environments using layered selector strategies, OCR, image recognition, and production-grade session management.
Most RPA deployments fail not because the bots are bad, but because the orchestration layer wasn't designed for production. This expert lesson walks you through building a complete queue-driven, self-healing bot fleet using Power Automate Work Queues, machine groups, and layered monitoring cloud flows. You'll leave with a blueprint for 24/7 automation that recovers from failures automatically and scales without babysitting.
Learn how to use Power Automate Desktop's clipboard actions to transfer data between Windows applications programmatically. This lesson covers Set Clipboard Text, Get Clipboard Text, keyboard simulation, timing issues, and building reliable multi-application data transfer flows from first principles.
Most RPA failures happen before the bot touches a single button — the environment simply was not ready. Learn how to check, start, stop, and monitor Windows services and processes in Power Automate Desktop so your flows manage their own runtime environment reliably, day or night.
Learn how to launch Windows applications programmatically, handle authentication prompts reliably, and keep sessions active throughout your automation. This lesson takes you from basic app launching through production-grade credential handling and session recovery — the skills every RPA developer needs before anything else.
Learn how Power Automate's unattended execution engine distributes work across machine groups, how to design queue policies that honor business SLAs, and how to prevent resource conflicts when dozens of bots run simultaneously. This expert-level lesson covers the architecture decisions that separate a stable enterprise RPA program from one that collapses under load.
Dialog boxes and pop-up windows are the most common reason desktop automations fail silently. This lesson teaches you how to detect, interact with, and gracefully handle any Windows dialog — from simple alerts to complex file picker prompts — so your bots never get stuck waiting for a click.
Learn how to start, stop, and monitor Windows services and scheduled tasks from Power Automate Desktop flows. This hands-on lesson covers native actions, PowerShell integration, polling loops, and production-ready orchestration patterns for background process management.
Learn how to read and write Windows Registry keys and environment variables directly from Power Automate Desktop. Build self-healing bots that validate and repair system configuration before every run, handle permission boundaries gracefully, and eliminate configuration-related failures in production RPA.
Learn how to connect Power Automate Desktop directly to SQL Server, execute parameterized queries safely, iterate over results, and write data into Windows applications — with production-grade error handling and multi-bot concurrency patterns built in.
Learn how to build a production-ready, end-to-end report automation pipeline in Power Automate Desktop — from extracting raw data out of Windows applications to merging it into formatted Excel templates and delivering the finished report via email, completely unattended. This expert-level lesson covers architecture, error recovery, credential security, and the edge cases that break real-world flows.
Mainframes still run the world's most critical business data, but extracting it means navigating green screen terminals most modern tools can't touch. This expert-level lesson teaches you how to connect Power Automate Desktop to TN3270 and TN5250 emulators, navigate menu hierarchies reliably, and parse fixed-width screen data into structured tables for modern system integration.
Most web scraping tutorials cover the happy path. This lesson covers production reality: dynamic tables, pagination loops that detect the last page automatically, session timeouts mid-run, and writing thousands of extracted rows to clean CSV and Excel output files — without losing a single row when something goes wrong.
UI changes break RPA bots — but they don't have to break your flows. This expert-level lesson teaches you how to build cascading fallback chains in Power Automate Desktop that detect broken selectors at runtime, attempt dynamic repair, and gracefully degrade through image recognition and OCR before ever raising a fatal error.
FTP and SFTP automation in Power Automate Desktop goes far beyond drag-and-drop upload actions — production-grade workflows require protocol awareness, secure credential management, per-file verification, and layered error handling. This lesson teaches you to build unattended transfer automation that handles real-world failures reliably, including the PowerShell/WinSCP path for SFTP that PAD's native actions don't cover.
Hardcoded passwords in RPA bots are a security crisis waiting to happen. Learn how to use Windows Credential Manager and PowerShell P/Invoke to store, retrieve, and rotate application credentials securely inside Power Automate Desktop flows — with automatic rollback when rotation fails.
Learn how to build production-grade desktop flows that read Outlook emails, extract attachments, parse message content with regex, and trigger downstream actions — all through COM automation without requiring cloud connectors or Exchange API access. A complete expert-level guide covering edge cases, error handling, and enterprise hardening.
Learn how to build production-grade unattended bots that populate PDF AcroForm fields using PDFtk and iTextSharp, apply certificate-based digital signatures, and route completed documents to structured network share locations — all without human intervention and with robust per-record error handling.
Most RPA guides ignore the system tray — but that's exactly where many legacy business apps communicate their status. Learn how to detect tray icon states, capture balloon notifications before they vanish, and trigger flow logic based on system tray events using Power Automate Desktop and PowerShell.
Microsoft Access databases power more enterprise operations than anyone admits — and most of them need daily reporting that someone does manually. This deep-dive lesson shows you how to automate the entire Access reporting cycle with Power Automate Desktop: running queries via COM automation, exporting formatted results to Excel, and building a bulletproof unattended flow that runs at 5 AM without a human in sight.