How to enter values from an excel file into a drop down list? HELP PLEASE!

Hi Guys,

Good day! I would like to automate a process where I should enter values from an excel file and enter it into a drop down list of another application. I’m thinking of putting all the values from the excel file (say for example I have 50 rows of Cust ID, Cust Name, Result ) into a data table and for each and every line, I will enter them into a drop down list of an application, click Save and enter the 2nd row. Hope you could help me with this. Please note that I’m using REFramework for this process. Thanks so much!

@caduque

use Select Item activity and pass value like this: row(“ColumnName”).Tostring

Values of drop down list and excel values should be match and its case sensitive also.

5 Likes