In this complete use case, you'll learn how to do advanced web extraction in Microsoft Power Automate Desktop. By the end of this tutorial, you will have a solid understanding of using Power Automate Desktop to build a complete web scraping project.

📂Course materials: https://andersjensen.org/microsoft-po...

VIDEOS FOR YOU:
🔹 Power Automate Desktop for Beginners:    • Power Automate Desktop for Beginners  
🔹 Power Automate Desktop PDF Extraction and Application Entry:    • Power Automate Desktop: PDF Extractio...  

POWER AUTOMATE DESKTOP GROUPS:
👨‍👩‍👧‍👦 Discord:   / discord  
Join my network with 6000+ Automation/RPA developers, where we solve Automation/RPA problems, network and help each other upgrade our careers. It's free!
👩🏻‍🎓 LinkedIn:   / 12566435  
👨🏻‍💻 Facebook:   / 754059285247921  

FOLLOW ME:
💼 LinkedIn:   / andersjensenorg  
📸 Instagram:   / andersjensenorg  
👨 Facebook:   / andersjensenorg  
🐦 Twitter:   / andersjensenorg  
💌 Email Newsletter: https://andersjensen.org/email-newsle...

00:00:00 Intro
Download the course materials. We will create a complete web extraction flow that reads an Excel sheet, web scrape data, and write it back to Excel. Everything is done with Microsoft Power Automate Desktop.

00:02:28 Initialization
We use Regions to structure our flow well. Use variables for things that can change, like the project path or the URL.

00:05:17 Browser Automation
Navigate to the data we want to extract with a Launch new Microsoft Edge action, a Set drop-down list value on web page action, and a Populate text field on web page action.

00:09:42 Web Extraction
Web scraping is straightforward in Power Automate Desktop. We can automatically extract web data by drag'n'drop and clicking.

00:15:53 Excel and DataTables
We work with DataTables in Power Automate Desktop since it's faster than doing it directly in Excel.

00:24:02 Dynamic File Naming
We use the current date and time for dynamic file naming.

00:26:58 Regular Expression on the Extraction
Regular Expression is a series of characters that defines a search pattern. Next, we'll use Regular Expressions, RegEx, to extract specific data, e.g., remove unwanted text from the extraction.

00:35:58 Extract URL from Search Results
With CSS selector work we extract the URL from the search results with Power Automate Desktop

00:44:48 Extract Multiple Topics
We want to do multiple web searches and extract each search result into a separate Excel sheet.

00:54:00 Extract Multiple Pages
Each search has its results on multiple pages. Therefore, our Power Automate Desktop flow must move to each page and extract the data.

01:05:59 Merge Two DataTables
We cant join two DataTables directly in Power Automate Desktop. So instead, we'll create a workaround with a loop to merge the DataTables.

#powerautomate #powerplatform #microsoft365