POWER AUTOMATE flow from table that contains links stored inside data-url value of <tr> tag

[PAuserFromFranc]

Dear All,

i'm looking for some help to build up a flow to scrap data stored inside pages of a website which you reach from a parent page which is a table in which you have links stored as value in data-url attribute of table row tag <tr>

im trying to figure out how to extract those links and then loop into it to scrap the datas in each single page

may be someone may help on my issue?

thanks very much!

regards

Fred

[VJR]

Hi @PAuserFromFranc 

This post and the responses in it will help you to achieve that.

[PAuserFromFranc]

Thanks VJR i will have a look, really appreciating !

[PAuserFromFranc]

@VJRsorry, this isn't the right answer i guess because i'm not able to right click and get the href when i'm extracting the datatable

- step 1 extract data from the webpage (extract entire html table)

- step 2 which i'm trying to do, loop all the links present in this table but stored inside data-url attribute of <tr> tag

- step 3 click on each link to get the new webpage and retreive datas in it

- step 4 go back and go next link and so on ...

In your answer you just tell me how to fetch each individual link but when it is tag as an <a> or Href

may you help?

[PAuserFromFranc · Accepted solution]

Sorry i have to precise i'm novice in coding so i'm not a coder and also the links are not appearing at the screen, i saw them only in data-url attribute of <tr> tag inside the inspector

[VJR · Accepted solution]

You can also get any other custom attribute's value using "Get details of element on webpage" 

do you have a website to share where data-url attribute is used?

[PAuserFromFranc]

Whooo Guys, i almost solved my issue ... Now i have another one, each record i make in the for each loop is creating a new spreadsheet (excel). I don't understand why, all the data extracted should be in list in one excel table no?

i extrat from each page of the list of urls and then translate to excelinstance but it seems it creates several variable (several sheets), how to solve this issue please?

thank you

fred

[ryule]

Can you send a screenshot of your flow? It sounds like you have something inside your loop that should only be set before the loop.