How to get dropdown value from excel?

[Muhammad_Hariz_Hakim_Rosm (Muhammad Hariz Hakim Rosman)]

Hello, I’m trying to get the value from dropdown list in excel. Please reply if you have a solution for this problem. Thanks!!!

[Praveen_Mudhiraj]

Drag and drop the “Select Item” activity into your workflow. Indicate the dropdown list then you will get the values.

@Muhammad_Hariz_Hakim_Rosm

[Gokul001 (Gokul Balaji)]

Hi @Muhammad_Hariz_Hakim_Rosm

Welcome to UiPath community

1. Use the “Read Range” activity to read the data from the Excel file.
2. Use the “Find Children” activity to retrieve the value of all elements in a drop-down menu. The output is stored in the variable type IEnumerable.
3. Use the “Select Item” activity to select an item from a drop-down combo box or list box.

Check out the video link

Drop Down Menus in UiPath (Find Children & Select Item) - Full Tutorial

Regards
Gokul

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @Muhammad_Hariz_Hakim_Rosm ,
You can read excel to get data table, then you go to website
use select item activity with dynamic value
regards,