Unanswered

Populate text into data table on web with dynamic id

(0) Share

Report

Posted on by Neil_ODonnell

Hi,

I am having difficulty populating text into a table on a web page. I can successfully enter the data into the first row but am unable to add anything to the second row.

The table cells have dynamic ID's. I have to remove the ID in the selector for row 1 in order to poulate it. If i remove the ID in the selector for the second row, data meant for the second row populates in the first row.

I have also tried 'extract data from web page' which captures the entire html table successfully, i can update the data table with the correct data in the correct cells, but then trying to populate the updated data table back to the web table doesn't work either.

I also tried sending key and mouse commands but can't get a reliable flow from this method.

When the web page loads only the first row is visible, when i populate one of the columns with text the second row appears, and so on.

Ultimately i would like to populate 3 rows total, but 2 rows would suffice.

Any help much appreciated,

Neil

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Deenuji_Loganathan_ 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Neil_ODonnell
Do the data table cells on the web always have standard IDs, or are they generated differently for each load?

Additionally, could you please share a screenshot of your table HTML, similar to the one below(Attached sample one), after adding three rows with sample values? We want to see the table cell IDs for all three rows.

Was this reply helpful? Yes No
Neil_ODonnell 46 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you for replying,

The IDs are generated differently for each load, please see html below

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Neil_ODonnell

Thank you for providing the details. The "tr" in the screenshot appears fine. Could you please expand the "tr" and take another screenshot to share?
I'd like to see how the table column IDs look like to determine if they are suitable for automation for (Item, Description, Qty.,Price and Account)?

Meanwhile, look at the below solution where how they handled dynamic selectors similarly for data table.
https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Populating-A-UI-Element-with-Excel-Rows/m-p/2616732#M37097

Was this reply helpful? Yes No
Neil_ODonnell 46 on at

Like
a
(0)

Report
Copy link

Link copied!

Please see attached/below

Was this reply helpful? Yes No
LuckyKha 2 on at

Like
a
(0)

Report
Copy link

Link copied!

you have solution for issue ??? I also had the same problem

Was this reply helpful? Yes No
Neil_ODonnell 46 on at

Like
a
(0)

Report
Copy link

Link copied!

No proper solution unfortunately. I had mixed results by using keyboard and mouse commands to select second row, but I have given up on that and only populate the top row at the moment

Was this reply helpful? Yes No