How exctract and download file from a table in a web page

[ancorte]

Hello,

i've made a desktop flow with success, but now i have to download the file from a web page that containa table like this:

i don't know how many files will be present in the table, and i think that i have use variable but it's the first time that i have to afford this problem. In the red adrea thera the button to download the file.

Thanks for the help.

[Henrik_M]

Check this documentation out: Automation in the web - Power Automate | Microsoft Docs

Your download links will probably have a src attribute that you can extract, and then use in a download from web action (by looping through the table)

[MichaelAnnis]

I would try @Henrik_M‘s way first. But if you can’t get the web elements to work, I do something similar by using Send Lrys where I {Tab} to each download icon and {Enter} to select the icon. 

[ancorte]

Hello Henrik, the problem is that I'm new in this situation, and so I have difficulty extracting the elements. Is there some suggestion or some explications about extracting all this kind of information?

[ancorte]

Hello,

now i'm able to exctract the data table, that has this format :

The link "Dettaglio Fattura" is the link that open another web page : in this web page there is the link to download.

So i ave to enter in the single web page (that is different for every row in the table) and after download the file....

Too much difficult for me !!! Anyone that can give me some suggestione ? Thanks in advance. antonio

[Henrik_M]

Hi Antonio

When the extraction helper is open, open advanced settings, then change the extration property on the last column (your "Dettaglio Fattura") to src/source instead of Own text.

[ancorte]

Hi Enrik, after 3 weeks of hard wok, now i'm trying to resolve the problem. Some questions:

That is the table:

The number of  rows of the table could be different, and the link at the right open a page in which i can download the file.

1. For extract the data from a table which kind of istance ? I use "obtain details of element of a web page", but i can choose "Own Text",  "Source Link",  "Href" etc...... Which is the right value ? Own text give me an error.

2. And after ? i have to make a loop to push  every element on the right of the table (in the red circle) to open the page and extract the file....

I'm very sorry, but it's difficult for me to move on at this point.

Antonio

[ancorte]

Hi, now i'm in this situation:

With "extract data" i has been able to put all the links in a variable: so i have a table with the "href" for all the page where i can download the files : now is it correct use a variable or should i use an excel ? and after ?

Thanks for all your help

Antonio