Create dynamic drop down box in form using excel

Help Forms
, ,
1

Hi,

I want to create a dynamic form using excel.

There will be two drop down boxes. Based on selection of first drop down box, 2nd drop down data will be populated. User can choose multiple options in 2nd box. After submitting, selected options will be copied in excel file.

Both the boxes data will be derived from excel sheet or SQL server (if possible).

2

@csmart

Try with macro it will work

3

Hello @csmart
Will it be possible to share the screenshot?

Here as per my understanding you have to use dynamic selectors, by passing a variable to the selector.

Thanks

4

Screenshot is not possible. I tried to modify the sample provided on UiPath support page where C# code is evoked. But I don’t know how to pass variable to the code.

Check this link
https://docs.uipath.com/activities/docs/dynamic-checkboxes