Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Power Automate Desktop - Beginner to Pro
Introduction
Welcome (0:31)
Getting Ready
Install Power Automate Desktop and browser extensions (2:36)
Power Automate Desktop Overview (1:13)
Download the lesson files (1:05)
Install Contoso Invoicing Demo App (3:26)
Record Your Actions
Intro to the Recorder (4:06)
Clean up and configuration (2:36)
The Recorder part 2 (3:47)
Refine the flow (3:59)
Variables
Intro to variables and prepare data (1:43)
Text variables (8:48)
Working with lists (8:18)
Numericals (3:54)
Booleans - True/False (2:02)
Leverage DateTimes (5:49)
DataTables (3:58)
DataRows (7:32)
If and Loop
The If and Else if actions (9:22)
Loop condition (7:11)
Advanced loop conditions, part 1 (9:17)
Advanced loop conditions, part 2 (8:13)
Excel
Excel preperations (1:52)
Basic Excel (Create a master Datatable) (14:01)
Prepare the master sheet (Save to Excel) (7:23)
Add sheets for each shop dynamically (2:57)
Write data to Excel (5:26)
Automate Excel formulas, part 1 (3:50)
Automate Excel formulas, part 2 (4:36)
Resize column widths (1:22)
Advanced VB scripting (6:01)
File Handling
Prepare the project, part 1 (2:52)
Prepare the project, part 2 (subflows) (2:32)
Unzip files (4:50)
Handle error files (8:32)
Process the success files (3:45)
Create a log and variable gymnastics (8:42)
Dynamic file naming (3:01)
Browsers
Basic web automation (8:53)
Combine web automation with Excel (6:09)
Iterate Excel (5:03)
Create a log (4:59)
Advanced error-handling (8:47)
Applications
Basic UI automation (6:32)
Selector work (7:36)
Finish building the basic flow (6:41)
Extract invoice data (4:09)
Implement loop (4:43)
Dynamic selectors (advanced) (7:28)
Web extraction
Prepare the data (1:19)
Navigate and speed things up (11:47)
Create a dynamic selector (6:12)
Web extraction (4:10)
Extract multiple pages (next button) (10:14)
Parameterized web scraping (9:13)
Save extractions to Excel (10:06)
Outlook
Prepare the Outlook emails (5:45)
Retrieve emails (6:40)
Process and respond to emails (4:40)
Process based on attachment(s) (10:05)
Log emails to Excel (9:00)
Artificial Intelligence
Intro to AI Recorder (Copilot) (6:32)
Regular recorder (4:05)
UI automation with the Copilot AI Recorder (6:02)
Save Excel (4:55)
The Copilot sidebar (1:57)
Create text with GPT (7:02)
Now what?
AI and Automation Black Belt
Advanced VB scripting
Complete and Continue
Discussion
2
comments
Load more
2 comments