The Library · Insights
Deep dives across data, automation & AI
162 in-depth articles — from Excel foundations to production machine learning. Filter by topic or difficulty to find exactly what you need.
Power AutomatePractitioner
Error Handling in Desktop Flows: On Block Error, Retry Policies, and Recovery Screenshots
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.
21 min read
Power AutomateFoundation
Automating Legacy Windows Applications with UI Automation in Power Automate Desktop
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.
33 min read
Power AutomateFoundation
UI Elements and Selectors in Power Automate Desktop: Building Automations That Don't Break
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.
21 min read
Power AutomateFoundation
Web Automation in Power Automate Desktop: Browser Actions, Form Filling, and Data Extraction
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.
18 min read
Power AutomateFoundation
Automating Excel with Power Automate Desktop: Reading, Writing, and Running Macros
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.
29 min read
Power AutomateFoundation
Variables, Lists, and Data Tables in Power Automate Desktop: A Complete Practitioner's Guide
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.
21 min read
Power AutomateFoundation
Getting Started with Power Automate Desktop: Installing, Recording, and Running Your First Desktop Flow
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.
18 min read
Power AutomateExpert
Implementing Batching and Chunking Strategies in Power Automate: Processing High-Volume Data Sets Efficiently with Do Until Loops, Array Splitting, and API Rate Limit Management
When your Power Automate flow works perfectly on 50 records but collapses under 5,000, you have a batching problem. This expert-level lesson teaches you how to architect production-grade flows using Do Until loops, take/skip array chunking, exponential backoff for API rate limits, and stateful checkpointing so your automation never loses progress—no matter the data volume.
27 min read
Power AutomatePractitioner
Automating SharePoint Document Library Version Control with Power Automate: Archiving, Restoring, and Enforcing Retention Policies Across Sites
Learn how to build a production-grade version governance system in Power Automate that automatically archives document versions, enables self-service restoration, and enforces configurable retention policies across SharePoint sites — with a complete audit trail behind every action.
23 min read
Power AutomateFoundation
Automating Microsoft 365 User Onboarding with Power Automate: Provisioning Accounts, Assigning Licenses, and Sending Welcome Emails from a Single Flow
New hires shouldn't wait hours for IT to manually set up their Microsoft 365 accounts. This hands-on lesson walks you through building a single Power Automate flow that creates user accounts, assigns licenses, and sends personalized welcome emails automatically — the moment HR submits a new hire request.
17 min read
Power AutomateExpert
Building a Power Automate Monitoring and Alerting System: Detecting Failed Flows, Notifying Owners, and Logging Telemetry to Azure Application Insights
Most Power Automate environments fly blind when flows fail — this lesson teaches you to build a production-grade watchdog system that detects failures across an entire environment, routes intelligent alerts to flow owners via Teams Adaptive Cards, and ships structured telemetry to Azure Application Insights for dashboarding and trend analysis. By the end, you'll have centralized, proactive monitoring that works even when your flows don't.
30 min read
Power AutomatePractitioner
Automating SharePoint and OneDrive Metadata Tagging with Power Automate: Extracting, Classifying, and Applying Managed Metadata at Scale
Manual metadata tagging never sticks — people are too busy creating documents to classify them consistently. Learn how to build a Power Automate flow that automatically extracts classification signals, resolves SharePoint Term Store GUIDs, and writes managed metadata to document libraries at scale, with AI fallback for ambiguous files.
22 min read