How to select drop down value based on value in Excel file

Hi team,

Below is the website I am trying to use for drop-down value selection.

image

I have a column in excel file that has only single value one out of these drop downs. As and when the excel value is changed, the UiPath workflow should select that value dynamically.

I am not able to use select item activity for some reason.

Please help.

@Pranee_007

If select item does not work…

Then use a click on the drop down and after expanding the dropdown use one more click to click on the required itemby making the innertext dynamic in the selector

Eg : <webctrl tag='DIV' innertext='{{varFromexcel}}' />

Cheers

You can try typing the text on the dropdown element and hit enter to select it.