How to get the input option as the list where the list value are fetch from excel or database

I am trying to show the list for user using the input dialog box. To get list we can use {“A”,“B”,“C”} but I want the values or option to get from excel sheet. The excel sheet content the list of options. and i want to get the option from excel not adding it manually.

Help me .

Thanks

Hello @Aman_Mongar1

use Read Range Activity to read data from excel. its store data into Datatable
you use that data table as a source of Input and get data from that and use it

Thanks

1 Like

I did but in input display it was showing only the last value, not the list of value

@Aman_Mongar1
show me the screen shot where you used as input

Thanks

1 Like

1 Like

@Aman_Mongar1

i think you need store data row value in String array through iterate data table

Thanks

2 Likes