Scraping data from the web in Microsoft Power Automate for Desktop

Do you keep track of data from a certain web page constantly? Do you need to scrape data from the web?

In this video, we walk you through how to configure web automation in Microsoft Power Automate for Desktop and scrape data from the web.

We'll go through 2 example scenarios:
1. Searching weather information for a certain city from Google based on user input, then return the result to the user through a message box
2. Scraping the result of a keyword search on eBay (2 pages) and storing it in an Excel spreadsheet.

Watch the video and learn to do it for yourself!
00:00 Introduction
00:10 Configuring web automation in Microsoft Power Automate for Desktop
00:33 Web automation actions in Microsoft Power Automate for Desktop
00:59 Scenario 1: Get user input, search Google, and scrape the result
07:13 Scenario 2: Search ebay for a keyword, scrape the results from multiple pages into Excel worksheet
13:40 Storing the scraped data into an Excel worksheet (instead of a variable)

Keep in touch!

#RPA #PowerAutomateDesktop #RoboticProcessAutomation #PowerAutomate

[ASO-xhvu]

No one will imagine how this flow is rare to find. You are the only guy who nailed it. I checked some other videos of yours and you look like you are the best documentation for Power Automate. Thanks a lot! You got my sub

[devbaghel]

Thanks for this valuable session
This is needed in my organisation

[subhamrai]

Nice work, you explain Power Automate very well 🤗🤗

[vLife]

How dynamic is this once deployed? Why is desktop a requirement? is it required to do this every time the web site updates? Will this ever be possible with cloud only?

[muthupandivijayan]

Hi Sir, I have Doubt here, if we extract data from two pages, In this scenario, I have details of page Number in Last Column in Output please help me

[subhamrai]

I have question : Can we detect numeric or alphabetical captcha and put into text box using POWER AUTOMATE ?

[OnLyhereAlone]

Very good tutorial but I have a question about a problem I ran into. The search results that Power Automate is giving me is different from when I do the search manually, even when done a few seconds apart. Hoe can this problem be fixed?
Secondly, could you do a tutorial that will include taking a snapshot of the results of multiple searches (loops) before the results are stored in excel?
Thank you.

[rohanganatra]

Nice tutorial, can you do a tutorial where you can show how to run this through a cloud or server so that it will run 24/7 even while my computer is turned off?

[jadonnorville]

Is it possible to save into an existing spreadsheet?