Скачать с ютуб Web Extraction in Microsoft Power Automate Desktop - Full Tutorial в хорошем качестве

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-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