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

Like (0) Share

Report

Posted on 21 Mar 2022 21:35:25 by PAuserFromFranc

117

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

I have the same question (0)

Summarized by AI

All responses (7)

Answers (2)

VJR 7,635 on 22 Mar 2022 at 02:56:51

Like (0)

Report

Re: POWER AUTOMATE flow from table that contains links stored inside data-url value of tag

Hi @PAuserFromFranc

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

Was this reply helpful? Yes No
PAuserFromFranc 117 on 22 Mar 2022 at 14:42:48

Like (0)

Report

Re: POWER AUTOMATE flow from table that contains links stored inside data-url value of tag

Thanks VJR i will have a look, really appreciating !

Was this reply helpful? Yes No
PAuserFromFranc 117 on 22 Mar 2022 at 14:53:34

Like (0)

Report

Re: POWER AUTOMATE flow from table that contains links stored inside data-url value of tag

@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?

Was this reply helpful? Yes No
Verified answer

PAuserFromFranc 117 on 22 Mar 2022 at 14:59:16

Like (0)

Report

Re: POWER AUTOMATE flow from table that contains links stored inside data-url value of tag

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

Was this reply helpful? Yes No
Verified answer

VJR 7,635 on 23 Mar 2022 at 11:40:39

Like (0)

Report

Re: POWER AUTOMATE flow from table that contains links stored inside data-url value of tag

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?

Was this reply helpful? Yes No
PAuserFromFranc 117 on 28 Mar 2022 at 21:38:29

Like (0)

Report

Re: POWER AUTOMATE flow from table that contains links stored inside data-url value of tag

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

Was this reply helpful? Yes No
ryule 929 Super User 2024 Season 1 on 30 Mar 2022 at 14:28:19

Like (1)

Report

Re: POWER AUTOMATE flow from table that contains links stored inside data-url value of tag

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.

Was this reply helpful? Yes No