Power Automate RPA Full Course – Day 4 | Excel Automation, UI Automation & Environment Setup

Welcome to Day 4 of the Power Automate RPA Full Course using Power Automate Desktop (PAD).

This session covers three major enterprise RPA pillars:

✅ Excel Automation
✅ UI Automation (Windows Application Automation)
✅ Power Platform Environment & Governance Concepts

This is a real project-oriented session showing how Excel data is used to automate a Windows application using UI automation actions.

📌 Topics Covered in This Video
🔹 Power Platform & Governance

✔ Default vs Custom Environments
✔ Switching Environments in Power Automate
✔ Developer vs Paid Subscription
✔ Enterprise Governance Best Practices

📊 Excel Automation

✔ Launch Excel with Existing Instance
✔ Read Excel Data into DataTable
✔ Insert Column into Excel
✔ Write Data into Excel Cells
✔ Apply Excel Filters from PAD
✔ Clear Filters Programmatically
✔ Append Data to Excel
✔ Column Index vs Column Name Handling
✔ Excel Limitations in PAD
✔ Why Rename Column is Not Available
✔ Using DataTable for Advanced Excel Operations

Excel is used as input source for UI automation.

🖥 UI Automation (Windows Application Automation)

✔ Difference between UI Automation and Browser Automation
✔ Launch Windows Application using PAD
✔ Wait for Application to Load
✔ Maximize Application Window
✔ Click UI Elements
✔ Fill Form Fields
✔ Navigate Menu Options
✔ Automating Contoso Invoice Application
✔ Reading Data from Excel and Filling UI
✔ Real Business Invoice Entry Automation Use Case

This demonstrates real enterprise desktop application automation.

🧠 Real-Time Use Case

Excel file contains invoice data →
Power Automate Desktop reads Excel →
Launches Windows invoice application →
Fills invoice details automatically →
Submits record using UI automation

This is exactly how RPA bots work in real companies.

🎯 Who Should Watch

• Power Automate Desktop Beginners
• RPA Developers
• Power Platform Architects
• Excel Automation Learners
• UiPath / Blue Prism / Automation Anywhere Migrators

⏱ Chapters / Timestamps (Approximate)
00:00 Session Introduction
07:00 Environment Setup Discussion
10:00 Flow Sharing & Roles
13:00 Developer Subscription
18:30 Excel Automation Intro
20:00 Read Excel into DataTable
22:30 Insert Column in Excel
25:00 Apply Excel Filter
28:00 Clear Excel Filter
31:00 Excel Limitations in PAD
35:00 UI Automation Introduction
38:00 Windows App Automation Concept
41:00 Launch Contoso App
44:00 UI Element Interaction
47:00 Excel to UI Data Mapping
50:00 Invoice Entry Automation