Sort data of enum type

[Nokia_6230ivn]

My column in google sheet is enum. It had only 1 (one) data at initial.
After a time input data, there are many datas in this field.
Kindly help me know:

1. How could I sort these data?
2. Where new data (CH05, CH10, ABC…) were wrote in my app?

Regards,

[Markus_Malessa]

If you are allowing other values, rather than using the preset approach I might suggest using the ‘Suggested Values’ instead. If you do this your suggested values might be:

SORT(ThisTableName[ThisColumnName], true) to sort ascending

[Nokia_6230ivn]

Thank you for your support.
After change fomular, the “Add or search” bar was disappeared.
I also want to keep it for additional data without existing list.
Please kindly requested instruct me how could I do?
Regards,

[Markus_Malessa]

Can you provide a screen shot of the entire column set up including the ‘Auto compute’ section? It might take 2 screen shots to capture all of it.

[Nokia_6230ivn]

Yes, offcouse. This is first one.

[Nokia_6230ivn]

This is second.

[Markus_Malessa]

Scroll down further in the same window from the first screen shot and provide what is at the bottom.

[Nokia_6230ivn]

This is 1 more if you need additional info,

[Markus_Malessa]

Remove the expression in Valid If and have the same expression in ‘Suggested Values’ under Auto compute section instead. Then also remove everything from ‘Values’. I think that should do it.

[Nokia_6230ivn]

After remove as your instruction, the resulr become as before: the list was not sort.

[Markus_Malessa]

Can you provide the screen shots again after you made the changes? Please include ‘Suggested Values’ under Auto Compute in one of the screen shots.

[Nokia_6230ivn]

Yes. I have divide 2 shot:

[Nokia_6230ivn]

the second:

[Markus_Malessa]

Please expand the highlighted section

[Nokia_6230ivn]

Yes. Nothing at there. It was deleted as your instruction. Please!

[Aurelien]

Can you try similar expression, using ORDERBY instead of SORT ?
In the “suggested value” field
Such as

ORDERBY(
     tableName[key_column],
     [sortColumn],
     FALSE
)

[Markus_Malessa]

In this specific case ORDERBY would not work. Typically Orderby would take the IDs, so it would treat it as a reference which is not the case.

[Markus_Malessa]

Move your

SORT(ThisTableName[ThisColumnName], false) to the ‘Suggested Values’ expression

[Nokia_6230ivn]

Everything is ok now! I don’t know how to say thanks with your help!
Thank you again.