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. 📂Course materials: https://andersjensen.org/microsoft-power-automate-desktop/web-extraction/ VIDEOS FOR YOU: 🔹 Power Automate Desktop for Beginners: https://youtube.com/playlist?list=PLXXz88_TPiHpY_5bfeV8RAOHnBKgc-rtw 🔹 Power Automate Desktop PDF Extraction and Application Entry: https://youtu.be/BxkfdK8rCRU POWER AUTOMATE DESKTOP GROUPS: 👨‍👩‍👧‍👦 Discord: https://discord.gg/iloveautomation - 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: https://www.linkedin.com/groups/12566435 👨🏻‍💻 Facebook: https://www.facebook.com/groups/754059285247921 FOLLOW ME: 💼 LinkedIn: https://www.linkedin.com/in/andersjensenorg 📸 Instagram: https://www.instagram.com/andersjensenorg 👨 Facebook: https://www.facebook.com/andersjensenorg 🐦 Twitter: https://twitter.com/andersjensenorg 💌 Email Newsletter: https://andersjensen.org/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