Part 2 | How to Web Scrape in Power Automate Desktop
HTML-код
- Опубликовано: 13 сен 2022
- Need help with your project?
Book your call today: calendly.com/bathompsonltd
My Links: linktr.ee/benthompsonuk
Did you know it is easy to web scrape in Power Automate desktop from your required websites? Web scraping is a very resourceful tool for gathering information at scale and being able to source through an automated process.
In this power automate tutorial we demonstrate how you can quickly create a power automate flow to scrape information from you desired website. We also look at how power automate is able to navigate a website by selecting required drop-downs and entering specific search terms.
WHAT IS POWER AUTOMATE?
Power Automate (previously known as Microsoft Flow) is a cloud-based automation platform that allows users to create and automate workflows across a variety of applications and services. It enables users to automate repetitive tasks and processes, such as data transfer and synchronization, email notifications, and approval requests. Power Automate includes a range of connectors that allow users to connect to a wide range of applications and services, including Office 365, Dynamics 365, Azure, and other third-party applications. It is a powerful tool that can help users save time, reduce errors, and improve efficiency in their workflows.
For more Excel tips, tricks and tutorials don't forget to subscribe to @EssentialExcel channel.
Have a project you would like us to help with?
Website: bathompsonltd.com/
Our other social accounts:
Instagram: / essentialexcel
TikTok: / essentialexcel
LinkedIn: / essential-excel
Instructor Lead Course ► essentialexceluk.com/courses
More Tutorials ► / essentialexcel
#powerautomate #webscraping #tutorial
I hope you enjoyed this tutorial 😃 If you did please give it a LIKE... and don’t forget to SUBSCRIBE for even more content!
For More 👉 ruclips.net/user/EssentialExcel
This is just amazing. I was stuck and didn't know how to use Power Automate, but your easy explanation has helped me a lot!
If you could, please also make a video on how to automate web scraping on Fiverr gigs, Upwork, or any freelancing platform. That would be great. I'm trying it on Fiverr but having some issues, like automating it to the second page. How do I automate it to the second page? I have tried to set "2" as the pager element, but it doesn't do anything after heading to the second page. I have also tried to set the arrow as the pager element on Fiverr, but it goes to the "2nd" page first and then to "1" again, and that loop runs back and forth. Also, if I go to the 2nd page manually by clicking the left click and perform the required scraping actions, it creates separate "Outputdata 2/3...". So, how do I save them all to a single "ExcelInstance -> Excel File"?
I'm so confused; I need that data for my final year project, but I'm stuck. Also, can you please explain what's the benefit of saving the data in variable form?
If you could make a detailed video or explain it here, I'd be grateful to you.
Thanks for your time. :)"
Please make a video on how we can extract data for multiple pages.
Great info 👍🏼Is there a way to do this for multiple pages? Also on some sites the price won’t appear in the csv, is there a way to fix this?
Thanks Adam! If you refer to part 1 (link below) and refer to approx. 11:06 when selecting items to extract from page, once page items have been selected navigate to button for next page and rather than using “extract element value” use “set element as pager”. The flow should then continue to extract from all pages.
@@EssentialExcel I have been trying but it doesn’t seem to pull any info from other pages just the first page, bit strange because I can see that it should work.
@@EssentialExcel I have never seen set as pager to work. Perhaps sometime maybe a tutorial on how to program this so one can get all pages