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

[Palaniyappan (Forum Leader)]

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

Ways to select drop down list

Hi Team, Attached work contains various ways to select drop down list. In case any other methods to select drop you can add the same and link the workflow to the same thread.,DropDownSelectItem.xaml (17.7 KB) project.json (239 Bytes) FindChildrenActivityRD.xaml (9.4 KB) SelectDropDownTypeInto.xaml (10.0 KB)

Cheers @HeartCatcher