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

(0) Share

Report

Posted on 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

Categories:

Power Automate Desktop

All responses (7)

Answers (2)

Sort by

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PAuserFromFranc

This post and the responses in it will help you to achieve that.
PAuserFromFranc 117 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks VJR i will have a look, really appreciating !
PAuserFromFranc 117 on at

Like
a
(0)

Report
Copy link

Link copied!

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

PAuserFromFranc 117 on at

Like
a
(0)

Report
Copy link

Link copied!

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
Verified answer

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

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 117 on at

Like
a
(0)

Report
Copy link

Link copied!

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 929 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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.