No video

Part 2 | How to Web Scrape in Power Automate Desktop

  Рет қаралды 2,155

Essential Excel

Essential Excel

Күн бұрын

Need help with your project?
Book your call today: calendly.com/b...
My Links: linktr.ee/bent...
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....
Our other social accounts:
Instagram: / essentialexcel
TikTok: / essentialexcel
LinkedIn: / essential-excel
Instructor Lead Course ► essentialexcel...
More Tutorials ► / essentialexcel
#powerautomate #webscraping #tutorial

Пікірлер: 7
@EssentialExcel
@EssentialExcel 2 жыл бұрын
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 👉 kzbin.info
@user-yk6bd5tz9x
@user-yk6bd5tz9x 10 ай бұрын
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. :)"
@GaganDeep-mj5hi
@GaganDeep-mj5hi 11 ай бұрын
Please make a video on how we can extract data for multiple pages.
@Mysterious_4-l5p
@Mysterious_4-l5p Жыл бұрын
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?
@EssentialExcel
@EssentialExcel Жыл бұрын
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.
@Mysterious_4-l5p
@Mysterious_4-l5p Жыл бұрын
@@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.
@Knards
@Knards Жыл бұрын
@@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
How to Web Scrape in Power Automate Desktop
16:34
Essential Excel
Рет қаралды 14 М.
Web Scraping Made EASY With Power Automate Desktop - For FREE & ZERO Coding
13:11
Zombie Boy Saved My Life 💚
00:29
Alan Chikin Chow
Рет қаралды 34 МЛН
Inbox Cleaner with Power Automate
18:38
Mike Stephenson
Рет қаралды 1,8 М.
Power Automate - How to Extract Web Data from Multiple Pages?
11:23
Multi Pages Web Scrap (extract) with Power Automate Desktop   #45
14:41
Zbigniew Lukowski - Tutorials
Рет қаралды 4,8 М.
Power Automate Desktop : 104 || How to work with "Invoke Web Service" [GET METHOD]
13:26