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: [ Ссылка ]

VIDEOS FOR YOU:
🔹 Power Automate Desktop for Beginners: [ Ссылка ]
🔹 Power Automate Desktop PDF Extraction and Application Entry: [ Ссылка ]

POWER AUTOMATE DESKTOP GROUPS:
👨‍👩‍👧‍👦 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: [ Ссылка ]
👨🏻‍💻 Facebook: [ Ссылка ]

FOLLOW ME:
💼 LinkedIn: [ Ссылка ]
📸 Instagram: [ Ссылка ]
👨 Facebook: [ Ссылка ]
🐦 Twitter: [ Ссылка ]
💌 Email Newsletter: [ Ссылка ]

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

свернуть