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

[1minManager]

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?

[Steve]

You have an EnumList of EnumLists?

[Daryl_Zernick]

Not helpful. I have the same issue.

[LeventK]

@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?

[Fabian_Weller]

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("")  
)

[1minManager]

I tried a few of the examples above, but couldn’t get any to work right. So here’s what I found worked in the Suggested Values section:

SORT(
SPLIT(
Select(Company[Business Type],ISNOTBLANK([Business Type]))
,",")
)

Simon@1minManager.com

[Fabian_Weller]

This may work, but you cannot control the “standard” values.
You may want to always show some “standard” values in the [Business Type] EnumList like:
{Service , Merchandising , Manufacturing}
Then you need to use the solution I mentioned above.