Dropdown choices import to Excel

[tomaslindev]

Hello everyone,
I need to create a dropdown for a catalog item with more than 50 choices. Is there a way to import them from an Excel file and not create them manually?

Thank you very much in advance and best regards

[Ankur Bawiskar · Accepted solution]

@tomaslindev 

I agree with Atul here.

Having 50 choices and user scrolling them to select is a bad user experience.

I will suggest to do this

1) create a custom table with Name field and Active field (default value=true)

2) load those 50 choices into that table

3) Create a reference variable pointing to this table and with filter condition as Active=true

This is easy to maintain going forward if any admin wants to inactivate that record. they simply make them active=false and that way is gone from the reference field when user selects from Catalog item form.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Dr Atul G- LNG]

Hi @tomaslindev 

As a best practice, if values are more than 8-10, better create the reference not as a choice. 

Are these stored in choice table? if yes then you can import.

[Ankur Bawiskar · Accepted solution]

@tomaslindev 

I agree with Atul here.

Having 50 choices and user scrolling them to select is a bad user experience.

I will suggest to do this

1) create a custom table with Name field and Active field (default value=true)

2) load those 50 choices into that table

3) Create a reference variable pointing to this table and with filter condition as Active=true

This is easy to maintain going forward if any admin wants to inactivate that record. they simply make them active=false and that way is gone from the reference field when user selects from Catalog item form.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar · Accepted solution]

@tomaslindev 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.