Create drop down from excel column

[sathya_auto]

I have a excel data…i want to create input dialog box which has drop down values…dropm down values are in excel column

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @sathya_auto ,
To create filter in excel, you can use invoke VBA code
or
Open file by excel application
Send Hotkey : Ctrl G
regards,

[sathya_auto]

no @Nguyen_Van_Luong1 i need to create input dialog box in UiPath based on column

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Can you share input and expect output by image to clear ?

[supermanPunch (Arpan)]

Hi @sathya_auto ,

Could you check with the below Configuration :

For using the values from Excel Column, we can check with below Expression in the Options property :

DT.AsEnumerable.Select(Function(x)x("YourColumnName").ToString).Distinct.ToArray

[sathya_auto]

i have excel value in column i want to create input dialog box in UiPath

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

You want create dialog, enter value to dialog, then write that value to excel
that’s right?
or dialog as a dropdown, values of dropdown are in excel?

[sathya_auto]

no creating options based on excel values

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

that’s right?

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

my input

my code

[sathya_auto]

Thankyou its working fine
Cheers

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Cheer @sathya_auto ,
happy automation