List "enum" in alphabetical order

[Benni]

Hi, the enum list entries you see below are added by users over time and based on their experience. I would like to show them in alphabetical order. I consulted the guide and in particular on the "Sort" and "Orderby" functions, but unfortunately they were of no help.

I await your suggestion.
Thanks for your answer

[TeeSee1 · Accepted solution]

Putting the following in the Suggested Values might do the trick

ORDERBY(
 referenced table[key],
 [column to order by]
)

Dropdown list ordered by Label

Source Table called ENUM1

The expression used in the suggested values

[Benni]

Hi @TeeSee1 Thanks for replying, I'm not sure I understand your suggestion. Where am I doing wrong?

[TeeSee1]

you need to put the name of the table before [IDMISSIONE]

[Benni]

Hi @TeeSee1 Thanks for your clarification. Sorry if I'm at an inadequate technical level. I get no errors and yet I don't get the desired result. I give you more details via pictures.

Thanks for your patience.

[TeeSee1]

Is your expression set in the intervento column?

[Benni]

Hi @TeeSee1 

the moment you answered me, I realized I was wrong. I didn't put it in the "ref" column, but in the source table. I am grateful for your patience and for teaching me something new. Have a nice day .