Web Scraping with Power Automate Desktop in 5 minutes

[@cappreview1435]

What if i want to extract a different name and address but they are on a separate pages such as 1/20, 2/20, 3/20 pages etc...

[@joshuaadams1436]

@Tom's Tech Academy What would be the process for extracting the data that's viewable after hitting "apply," for all of the available job offers including on other pages?

[@TomsTechAcademy]

Hi Joshua, after you stored the data in excel you would need to loop through every row. Then navigate to every url individually and extract the data. This video describes the first step: How to loop through each row in Excel - Power Automate Desktop Tutorial kzbin.info/www/bejne/naOwm4COe7abrZo

[@Rhand007]

Do you think this would work on an Amazon Wishlist to create a very simple price tracker? (I can only test this next week otherwise I would just try it out).

[@KarlMcClelland]

thanks for this. Could you explain how you then get the information from the URL or linked page? Greetings from Belfast, Northern Ireland.

[@TomsTechAcademy]

Hi Karl, thanks for your comment! I'm planning another video on this, though didn't find the time to record it yet. In general you need to follow these 3 steps: 1) After extracting to Excel, you should have an Excel file with all the extracted pages stored in different rows 2) Loop through this Excel file (see this video: kzbin.info/www/bejne/naOwm4COe7abrZo) and visit every page and extract the information you want (e.g. with Get Text) 3) Now save the additional data you extracted to the matching columns in Excel Good luck!

[@rohiniiyer3638]

Hey Tom, thanks for the video. Strangely enough, after using "Extract data from web page", the pop-up doesn't automatically appear for me in Chrome where I can enter the elements I would like to scrape. Would you know a workaround for this?

[@jdimarzio]

I had the same issue. You need the enabled the power automate extension on your browser so that it can grab the context!

[@ario7533]

Hello Tom , congratulation you are very clear and sintetic . Your video is helpful for me but i have an issue whith a web page where a text i wonder to extract , when i tap it whith right clic , activate a popup for others choices...and it prevents me to select the text extraction...do you know how can i do it?

[@TomsTechAcademy]

Hi Ario, thanks for your comment and the nice words. Did you already try another browser? I'm not too familiar with this issue though recommend to try using Firefox, Chrome or Edge and see whether the issue still appears?

[@ario7533]

@@TomsTechAcademy It is very strange..few days after there wasen't problems..all worked fine...bha..thank you so mutch

[@SagarIbrahimSiyal]

What if we have multiple urls in spreadsheet and want to scrap data from them.?

[@TomsTechAcademy]

Hi, in this vide you learn how to loop through multiple urls: How to loop through each row in Excel - Power Automate Desktop Tutorial kzbin.info/www/bejne/naOwm4COe7abrZo good luck!

[@himavanthJarugumalli]

can I extract Page urls and image tags in html code which is excel file through desktop flows

[@TomsTechAcademy]

Hi, it's difficult to help you based on this description. Can you share your challenge in my Discord? Then I can help you right away :) My Discord: discord.gg/WHJWFNDXXX

[@Brmmalesela]

Thank you

[@TomsTechAcademy]

Thank you for your comment, happy automation! 🤖

[@user-bj4lp3fr1o]

Screen visibility is terrible.

[@TomsTechAcademy]

Hi, did you try adjusting the resolution in YT to 1920 * 1080p?

[@douglynch6613]

Hello, is there a way to extract the URL from the web search bar? On some of the pages that I’m trying to extract data from there’s no clickable link on the webpage that I can right click on and extract the href into excel. Thank you