Unanswered

How to scrape different webpage from URL listed in excel

(0) Share

Report

Posted on by SumitP2018

I want to scrape 3 information from huge number of webpages which I have listed in excel. The issue is when the query reads the current item from excel (which is the URL of the webpage), it pastes the URL in the browser but the page loads incomplete. For example, the URL in my excel is 'https://ABCD/-/XYZ/12128/4/2/ ' but the page which loads in browser is 'https://ABCD/-/XYZ/12128 '. The later part "4/2" does not load. I want to scrape the data from 'https://ABCD/-/XYZ/12128/4/2/ ' and not from https://ABCD/-/XYZ/12128 .

Thanks in advance.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (9)

Answers (1)

Srini007 3,327 Super User 2025 Season 2 on at

Like (0)

Report

@SumitP2018

Can you try manually and see if you type the entire URL is it still going to the /4/2 page?
Also, check while opening the url, the full URL is in the browser or not?

Thanks,
Srini

Was this reply helpful? Yes No
SumitP2018 13 on at

Like (0)

Report

Hi Srini,

thanks for your reply. Yes, I tried that, I copy pasted the URL in the browser and it opened the exact page I needed with 4/2. Even when the flow is running, the webpage opens with complete URL but till the page loads, 4/2 vanishes. So manually it works, only when the flow is running it does not. Thanks again.

Was this reply helpful? Yes No
Verified answer

Srini007 3,327 Super User 2025 Season 2 on at

Like (1)

Report

@SumitP2018

If possible can you share the url, so that I can try and see the exact issue?

Thanks,
Srini

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @SumitP2018

when value is extracted from excel, is url value like this ?
https://ABCD/-/XYZ/12128/4/2/

or like this

https://ABCD/-/XYZ/12128

Could u confirm pls ?

Was this reply helpful? Yes No
SumitP2018 13 on at

Like (0)

Report

@Nived_Nambiar

The value when getting extracted. it in below format
https://ABCD/-/XYZ/12128/4/2/

then the webpage opens with this https://ABCD/-/XYZ/12128/4/2/ but when it completes loading it ends up like https://ABCD/-/XYZ/12128.

Thanks a lot

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @SumitP2018

Do one thing

Launch https://www.google.com using launch chrome action

Use Go to webpage action to go to https://ABCD/-/XYZ/12128/4/2/

See whether it works or not 🙂

Was this reply helpful? Yes No
SumitP2018 13 on at

Like (0)

Report

Thanks for your guidance, the problem is solved

Was this reply helpful? Yes No
SumitP2018 13 on at

Like (1)

Report

@Nived_Nambiar Thanks for looking into this. I guess the problem was that my excel was saved on sharepoint hence it was not reading the URLs correctly. But @Srini007 guided me to how to do it.

Thank a lot both of you 🙂

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @SumitP2018

could you please how the issue was resolved, it would be helpful for others if they are looking for same solution 🙂

Was this reply helpful? Yes No