Unanswered

Populating A UI Element with Excel Rows

(0) Share

Report

Posted on by lilclss

Hi All

I've been trying to develop this flow that creates a workbook and pastes in cell A1 any order number that the user has stored in the clipboard, then, PAD takes each cell and pastes it on a UI element in a website, which is a table.

I currently have an issue with the loops, since I'm trying to make this as less hard coded as possible, I need to make a loop that iterates through each order in the excel workbook and populates each UI element in the website. (Excel 1,1 goes to UI 1,1 ; Excel 2,1 goes to UI 2,1 ; and so and on depending on the amount of orders) *I only have 1 column in each data set.

Currently, the loop does iterate through 1 order and populates correctly in the website, however, when I add second order, the loop iterates twice as it should, but populates UI 1,1 and 2,1 with the first order, and then overwrites UI 1,1 and 2,1 with the second order.

I'm basically new at PAD and very stuck at this point.

Thanks for any help provided

Categories:

Power Automate Desktop

Screenshot 2024-0...

I have the same question (0)

All responses (12)

Answers (1)

Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report

@lilclss

I've reviewed the code you shared above. However, could you please provide a detailed explanation of your use case? Additionally, sharing some screenshots related to your application would be helpful in understanding what you are trying to achieve here.

Here are the additional questions:
1. How did you extract the value from the clipboard? Was it from a web application or a Windows application? Please provide some screenshots to understand the data it holds and the type of UI element it is.
2. When you have the data in the clipboard, why are you adding it to Excel? Why not consider using another variable like a datatable, etc.?
3. In the shared screenshot, why are you using a double loop, like a for each and a loop? Any specific reason?

Please note that if you intend to loop through the datatable, using just one "for each" loop is adequate. For reading specific cells, you would call currentitem[0], currentitem[1], and so forth.

Thanks,
Deenu

Was this reply helpful? Yes No
lilclss 12 on at

Like (0)

Report

Hey @Deenuji , thanks for replying.

What I'm trying to achieve is to copy a group of order numbers and populate a number of rows in a webpage (see webpage screenshot). I do not have fixed order numbers nor order amount. I want to replace the manual work of plugging in an order every time, specially when there are a lot of orders.

I used the Paste cells to Excel worksheet to organize the selected orders in a table manner, if that makes sense.

I believe that the issue is related to the Populate text field on web page loop , since it only works with one order, but when I add more than one order, it overwrites the information. (see flow screenshot)

Screenshot 2024-0...

image.png

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report

@lilclss

Would you mind sharing some screenshots of your Excel document after you've pasted your group of order numbers? Additionally, could you manually add them to the webpage and take screenshots to provide us to understand your use case?

Thanks,
Deenu

Was this reply helpful? Yes No
lilclss 12 on at

Like (0)

Report

@Deenuji

Here are the screenshots of de ideal result of the flow.

Doing a little more research, I think that I have to loop through the source rows and also through each of the table rows (tr), and my current loop only seems to iterate through the source rows, but only going into the same tr. How can I make a variable and a loop out of my UI element? I

ui element.png

excel example.png

label example.png

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report

@lilclss
One last info:
Please share the element id for the below highlighted table rows?

Was this reply helpful? Yes No
lilclss 12 on at

Like (0)

Report

@Deenuji
Hope this helps.

I notice that tr id increments by 1 every time, starting from zero.
Orders-cell-0-0 (row 1)
Orders-cell-1-0 (row 2)
Orders-cell-2-0 (row 3)

Table__.JPG

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report

@lilclss

Still We can't able figure it out the element which present inside the table td.
Please expand the td and show the element details which hold your order number

Was this reply helpful? Yes No
lilclss 12 on at

Like (0)

Report

Apologies, here you go

Table___.JPG

Was this reply helpful? Yes No
Verified answer

Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report

@lilclss

Please find the below suggested flow for your use case(I haven't optimized your flow).

Flow Details(created counter variable for handle dynamic input element id):
UI element change:

Thanks,
Deenu

Was this reply helpful? Yes No
lilclss 12 on at

Like (0)

Report

Thanks a lot @Deenuji . After using your suggestion and updating my flow with the correct UI elements, it worked. Very appreciated.

Was this reply helpful? Yes No