Is it possible to select a dropdown which input are being fetched from an excels sheet?

Help StudioX
,
1

I am trying to select dropdown based on my excel sheet but wasn’t able to do it.

2

Can you please elaborate on which issue you are facing?

3

Thanks For Responding. I want to select one of the dropdown items given in image 1.

image
image706×362 13.4 KB

But I want to select the item based on the data given in my excel sheet.
Unfortunately, I couldn’t find a solution about how to do it since I am just a beginner.

4

You can use Select Item Activity of Uipath.
Select Item Activity - UiPath

And to use Excel data as your Input you can use For Each Row Activity of Excel DT and pass Expression
CurrenRow(“ColumnName”).ToString.

Let me know if you have any Query.

Regards,
Saloni

5

I tried what you instructed and while using the select item tool it was indicating that "the selected item isn’t a valid UI element for the Select item.

6

1.Than You can use Click activity to Click on that Dropdown Element and
2.Use Click text activity to Select Input from Excel.

7

Thanks for helping. It worked for me :slight_smile:

8

Mark Solution for this Post so we can close the topic.
Happy Automation :blush:

Regards,
Saloni

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.