How to input data from excel to form if there are repetitive fields?

Help Activities
, ,
1

Dear Guys,

How to robot fill data from excel repeatedly with the following case conditions

If there is more than 1 row, the robot will add data by clicking the (+) icon on the form.

I have created an activity

  1. Use Excel
  2. For each excel row
  3. Select item
  4. Type into the name

Example page:

This image shows an application form interface under the "Supplier & Buyer" section, where users can add details about business relationships, including the role and name, with options to submit or close the form. (Captioned by AI)
This image shows an application form interface under the "Supplier & Buyer" section, where users can add details about business relationships, including the role and name, with options to submit or close the form. (Captioned by AI)1532×697 45.4 KB

Example excel:

The image shows a spreadsheet with three columns labeled "No," "Business Relationship," and "Name," listing three suppliers with corresponding names, highlighted in orange in the "Business Relationship" column. (Captioned by AI)
The image shows a spreadsheet with three columns labeled "No," "Business Relationship," and "Name," listing three suppliers with corresponding names, highlighted in orange in the "Business Relationship" column. (Captioned by AI)782×163 4.4 KB

Example activity:

The image shows a UI workflow for processing an Excel file named "HPU_Supplier_Buyer.xlsx" and iterating through each row in "Lembar1" sheet. (Captioned by AI)
The image shows a UI workflow for processing an Excel file named "HPU_Supplier_Buyer.xlsx" and iterating through each row in "Lembar1" sheet. (Captioned by AI)659×581 19.4 KB

The image depicts a sequence in a UI automation workflow where it iterates through each row of an Excel sheet and performs specific actions, including selecting an item and entering text into a field. (Captioned by AI)
The image depicts a sequence in a UI automation workflow where it iterates through each row of an Excel sheet and performs specific actions, including selecting an item and entering text into a field. (Captioned by AI)543×638 30.1 KB

The image shows a sequence in an automation workflow where a 'Name' field is populated using a variable from a data row, followed by a click on an icon. (Captioned by AI)
The image shows a sequence in an automation workflow where a 'Name' field is populated using a variable from a data row, followed by a click on an icon. (Captioned by AI)496×637 30.1 KB

Thanks Guys

Regards,
Raden Bayu H.

2

For Output error warning

The image shows an error message in an automation software indicating that it could not uniquely identify the "Buyer" item due to multiple similar matches and needs validation and anchors for precise identification. (Captioned by AI)
The image shows an error message in an automation software indicating that it could not uniquely identify the "Buyer" item due to multiple similar matches and needs validation and anchors for precise identification. (Captioned by AI)1004×393 22.5 KB

3

The image shows a "Create Application" form on a webpage, specifically on the "Supplier & Buyer" tab, displaying four rows for entering details about business relationships, with only the first row partially filled and a red box highlighting an area with a note indicating "Robot not input below add list." (Captioned by AI)
The image shows a "Create Application" form on a webpage, specifically on the "Supplier & Buyer" tab, displaying four rows for entering details about business relationships, with only the first row partially filled and a red box highlighting an area with a note indicating "Robot not input below add list." (Captioned by AI)1490×741 48.2 KB

4

Hi Raden Bayu,

It looks like the Select Item ‘Buyer’ found multiple similar elements after the robot clicked the + button to add a new row.

Kindly use UI Explorer and find any tag for a row (eg: tableRow, rowIndex, etc). Then, edit the value of the tag with variable (eg: int_rowIndex), and change the variable (int_rowIndex) with the current row index from the For Each activity.

Regards,
Azeem