Enumlist values with Ref base type not in order as per table order

[notmat111]

Hi all,

I'm really struggling with this.

I have a table named "ICD10Codes" with a key column called "Code". The table itself is listed in the order that I want my enumlist to show the values listed. I REQUIRE an existing Valid_if expression "ICD10Codes[Code]", in order for the codes to not "!" yellow triangle error when accessing the enumlist.

However, the listed values in the App, in the enumlist, are not listed in the order as per the table. Why?

How do I make it show as per the table list of values?

Thanks so much.

[notmat111 · Accepted solution]

Figured it out. Really obscure that it doesn't default to ordering it in the original way, but okay.

Ended up making a Orderby() expression + added a column called "Order" which was literally just a numbering system 1-x.