Enum Column Drop Down List Sorting Issue

[Michael_Serafin]

Hello,

I have a column set as ENUM with a drop down. “Allow other values” and “Auto Complete other values” are enabled. My goal is to make the drop down list sorted ascending. To accomplish this I added SORT(TableName[ColumnName]) in Valid if. This results in the proper sorting of items in the drop down list however the SORT expression removes the ability for the user to ADD a new item name.

Any assistance is appreciated.

Michael

[Jonathon · Accepted solution]

Move the sort formula from the valid if to suggested values:

[Michael_Serafin]

Thanks, Johnathan. That did the trick.

Michael

[alexandre-sabot]

Hello,

I try the same thing
I have a enumList column with data separated by ','

It works well, but when I want to sort items, I lost the enumList

I put SORT(Table_name[enumList_Colum]) in Suggested values
Any idea?
Thanks and regards,
Alexandre