Unanswered

Loop through a table on a website

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have a website with an HTML table. The first column in each row contains a link.

When clicking this link another tab opens and I have some other clicks that I run there. Once completed, I want to close that tab and click on the next link in the table.

I can't extract the links since they are JS actions and only work in the context of the page.

How do I loop through each row on the page?

Thanks

Sam

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (0)

Sort by

VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

Are you able to get the entire Html table with the contents present in it? This will be into a Datatable. Then loop through the datatable and use "Go to webpage" to navigate to any of those links.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

In theory yes, I can get the whole datatable. The issue is that the links aren't static links, they are JS actions which will do nothing if used as external links. I need a way of actually clicking each on of them on the page itself.

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

Does the recorder give anything when you manually click the links while recording?

Is there some public website that you can point to with the Js actions.

Was this reply helpful? Yes No
Gidi 601 on at

Like (0)

Report
Copy link

Link copied!

Have you tried to use keyboard actions to click the links?

Was this reply helpful? Yes No
Henrik_M 2,021 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The location and selectors are not saved with the table, so you have to create a UI element to use in combination with a loop. The UI element should have a custom selector containing a loop variable that dynamically changes. If that variable is a %LoopIndex% or a %CurrentItem% depends on how your table is set up, and what your desired data outcome is.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Any solution of exporting or recreating the links doesnt work since the application doesn't allow us to open them as standalone links. They must be opened from the main page with the table. The table is a standard HTML table and the links are in a fixed column. The table looks as follows:
We need a way of looping through each 'tr' element in the table and then selecting the third 'td' element for each record. We then need to click on the link of that selected record. How can we create this loop for the table records in the HTML?

Example of the table: (We need to click the values in the 3rd column under 'Process Name')

Thanks
Sam

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Did you ever get a solution to this? this is almost exactly the situation I'm in right now. JS code on the link, it opens a dynamically generated table in the page (instead of a tab), and creates another dynamically generated url that is the one i actually need to click. I've been searching for a solution for longer than i care to admit.

Was this reply helpful? Yes No