ENUMLIST with "Auto-Complete Other Values" set, listed in Alpabetical Order

I have an ENUMLIST with “Auto-Complete Other Values” set. It works fine except that the list is give is not in alphabetical order. I’ve tried usind SORT() but it doesn’t display it correctly because some of cells it selects are themselves a list because its an ENUMLIST. So I see

A,
B,
A,B,C
B,D

Anyone know how to sort it alphabetically and only show indiviual items?

You have an EnumList of EnumLists?

1 Like

Not helpful. I have the same issue.

@1minManager
So you have an ENUMLIST column, where you collect the dropdown content via a SELECT expression (or may be directly pointing out to a column in the same table) in Suggested_Values property. Am I correct?

If so, you want to sort the dropdown content ascending/descending order:
[1] Only for the individual items?
[2] For both individual and list items
[2.1] If list items shall be included, are you expecting them to be sorted internally as well?

To Auto-Complete other values in alphabetical order, without duplicates:
For ENUM:

SORT(
LIST(
A,
B,
C,
D
)
+YourTable[EnumColumn] 
-LIST("")
) 

For ENUMLIST:

SORT(
LIST(
A,
B,
C,
D
)
+SPLIT(YourTable[EnumListColumn],",")
-LIST("")  
)
1 Like