How to Select the drop down value based on the excel input values

Help Studio
, ,
1

Hi All,
I want to select
drop down value based on the input from the excel the put value is not constant it is random value,how can I select the random value in dropdown from the input value??

Please somebody help me in this.

Thanks in advance

@Nithinkrishna
@ppr
@Yoichi
@Gokul001
@NIVED_NAMBIAR
@geetishree.rao
@Sudharsan_Ka

2

Hi @HeartCatcher

could you share us a sample for reference

1 Like
3

DropDown
Like that based on the plan column value from excel I need to select the dropdown but it is random values as in attachment

4

@HeartCatcher Do you have to select multiple values from the drop down? If not use click
activity for drop down and another click activity to select the drop down value

To select the value randomly based on the excel input, you have to use dynamic selectors meaning, pass the variable which have the excel input to the selector in the click activity

Can you share the selector for one of the drop down value

For more info

1 Like
5

HI @HeartCatcher

You can try with Select Item activity → Indicate on the screen.

Pass the CurrentRow(“ColumnName”).Tostring

image

Have a look on the Document

Regards
Gokul

1 Like
6

Hi

Say you have the data in a excel column and you have got that excel as a datatable named dt

Now use a for each row activity and pass dt a input and inside that loop use a SELECT ITEM activity where pass the input as CurrentRow(“yourcolumnname”).ToString.Trim

This will select the item from drop down

If you are not able to get it with select item there are many ways to handle a drop down
Have a view on this for different methods but the way to pass the input is same as above

Cheers @HeartCatcher

1 Like