Basic web automation | andersjensenorg

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Power Automate Desktop - Beginner to Pro

Introduction

Welcome (1:02)

Getting Ready

Install Power Automate Desktop and browser extensions (2:36)
Power Automate Desktop Overview (1:13)
Download the lesson files (1:05)

Record Your Actions

Record your first flow (Web automation) (6:16)
Clean up and add to the flow (4:03)
Improve with the recorder (Word automation) (7:13)
Manually improve the flow (4:23)

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

Prepare data (2:27)
Basic selector work (6:35)
Dynamic selectors (3:53)
Dynamic application entry (10:05)
Write application results to Excel (4:17)
Application work with logic (7:38)
Add conditional formatting to the results (5:07)

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)

Now what?

AI and Automation Black Belt

Basic web automation

Find the web form here.

Complete and Continue

Discussion

0 comments