Power Automate Download All Files from Website displayed over Multiple pages

Like (0) Share

Report

Posted on 23 Nov 2022 03:09:33 by UDev

Hi there,

Can anyone help with advising how to best setup a flow to automate downloading of files from a webpage?

The webpage has a tabular display of which one column holds these files. The filename is more like a hyperlink where once you click on it, it starts to download. The page can be set to display 25 or 50 lines. Therefore, one has to click to download these files individually and then upon completion, move to the next page and repeat the above steps for the next group. There is more than 10K pages. Happy to breakdown into batches if it makes it any easier.

I was doing 25 files at a time using Recorder function then moving to next page to repeat. However, a recent updated on Power Automate and Edge has caused this method to not work anymore saying the object cannot be found once I move to the next page. Any other method to speed this up will help.

Thanks

All responses (4)

Answers (0)

momlo 1,527 Super User 2024 Season 1 on 25 Nov 2022 at 07:24:59

Like (0)

Report

Re: Power Automate Download All Files from Website displayed over Multiple pages

Hi
If those links/urls are href elements then my approach would be preety standard:
1. Extract all links.
1.1 Use Extract data from web page action to extract all links from all pages:
https://learn.microsoft.com/en-US/power-automate/desktop-flows/actions-reference/webautomation#extractdata

1.2 Add action to your flow and open it's settings
1.3 Open web page
1.4 Start right clicking the links and select "href" attribute. After two or three you it all other should get automatically selected.
1.5 Right click the "next" button that you use for moving to next page and select as a pager.
1.6 In action setting remember to enable extracting data from all pates.
---
2. Loop through links
Now you want to click the links, but why to click them if you already have them in extracted variable? 😉
My approach would be to use "for each" loop through the list of link sand use browser action and navigate to URL.
VJR 7,635 on 25 Nov 2022 at 04:30:05

Like (0)

Report

Re: Power Automate Download All Files from Website displayed over Multiple pages

Yes, find one link and change the selector as other links. Same reference here. May need exploring depending on your particular scenario.

Click all the elements in a list of links - Power Automate | Microsoft Learn

This link uses Click link on webpage. First try that and then also try with the above 2 download actions.
UDev 2 on 25 Nov 2022 at 04:17:11

Like (0)

Report

Re: Power Automate Download All Files from Website displayed over Multiple pages

Hi, not sure how you setup the Flow as there are other links also on the page. Do I record link to one file then use loop function for remaining links?
VJR 7,635 on 25 Nov 2022 at 02:59:38

Like (0)

Report

Re: Power Automate Download All Files from Website displayed over Multiple pages

Check out if any of these two options makes it any easier.