Extract Multiple Web Pages with Power Automate Desktop - Full Tutorial
24.1 هزار بار بازدید -
2 سال پیش
-
This video tutorial shows how
This video tutorial shows how to extract multiple web pages with Microsoft Power Automate Desktop. You'll learn how to create a loop with a dynamic selector and ensure you don't overwrite Excel data.
🌍 The page I scrape in the video: https://portal.cfm.org.br/busca-medicos
VIDEOS FOR YOU:
🔹 Web Scraping in Power Automate Desktop (1 HOUR): Web Scraping in Power Automate for De...
🔹 Save Web Data to Excel - Advanced PAD Use Case (2 HOURS): Save Web Data to Excel - Power Automa...
POWER AUTOMATE DESKTOP GROUPS:
👨👩👧👦 Discord: Discord: discord
- Join my network with 4200+ Automation/RPA developers, where we solve Automation/RPA problems, network and help each other upgrade our careers. It's free!
👩🏻🎓 LinkedIn: LinkedIn: 12566435
👨🏻💻 Facebook: Facebook: 754059285247921
FOLLOW ME:
💼 LinkedIn: LinkedIn: andersjensenorg
📸 Instagram: Instagram: andersjensenorg
👨 Facebook: Facebook: andersjensenorg
🐦 Twitter: Twitter: andersjensenorg
💌 Email Newsletter: https://andersjensen.org/email-newsle...
0:00 Web Scrape a Single Page
Power Automate Desktop is next to none regarding data extraction of web pages with no code. Directly apply Regular Expressions to the results if you want to filter them further.
3:13 Multi-page Web Scraping
We have search results on multiple pages. In addition, there is no next button, only page numbers. So the solution is to create a loop with a dynamic selector - both dependent on the current and the total page number.
6:37 Creating a Dynamic Selector
We create a dynamic selector in Power Automate Desktop so that we can click all the next page buttons.
12:48 Write to Excel (multiple pages)
We'll ensure we don't overwrite Excel data when continuously writing newly extracted data to Excel.
#powerautomate #powerplatform #office365
🌍 The page I scrape in the video: https://portal.cfm.org.br/busca-medicos
VIDEOS FOR YOU:
🔹 Web Scraping in Power Automate Desktop (1 HOUR): Web Scraping in Power Automate for De...
🔹 Save Web Data to Excel - Advanced PAD Use Case (2 HOURS): Save Web Data to Excel - Power Automa...
POWER AUTOMATE DESKTOP GROUPS:
👨👩👧👦 Discord: Discord: discord
- Join my network with 4200+ Automation/RPA developers, where we solve Automation/RPA problems, network and help each other upgrade our careers. It's free!
👩🏻🎓 LinkedIn: LinkedIn: 12566435
👨🏻💻 Facebook: Facebook: 754059285247921
FOLLOW ME:
💼 LinkedIn: LinkedIn: andersjensenorg
📸 Instagram: Instagram: andersjensenorg
👨 Facebook: Facebook: andersjensenorg
🐦 Twitter: Twitter: andersjensenorg
💌 Email Newsletter: https://andersjensen.org/email-newsle...
0:00 Web Scrape a Single Page
Power Automate Desktop is next to none regarding data extraction of web pages with no code. Directly apply Regular Expressions to the results if you want to filter them further.
3:13 Multi-page Web Scraping
We have search results on multiple pages. In addition, there is no next button, only page numbers. So the solution is to create a loop with a dynamic selector - both dependent on the current and the total page number.
6:37 Creating a Dynamic Selector
We create a dynamic selector in Power Automate Desktop so that we can click all the next page buttons.
12:48 Write to Excel (multiple pages)
We'll ensure we don't overwrite Excel data when continuously writing newly extracted data to Excel.
#powerautomate #powerplatform #office365
2 سال پیش
در تاریخ 1401/08/10 منتشر شده
است.
24,140
بـار بازدید شده