filmov
tv
Web Extraction in Microsoft Power Automate Desktop - Full Tutorial

Показать описание
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.
VIDEOS FOR YOU:
POWER AUTOMATE DESKTOP GROUPS:
- 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!
FOLLOW ME:
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
VIDEOS FOR YOU:
POWER AUTOMATE DESKTOP GROUPS:
- 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!
FOLLOW ME:
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
Комментарии