Solved: Sort ENUM from same column - Page 2

School_Bus · 12-17-2020 10:52 AM

So I select ENUM in my column and it gives me a dropdown of all the previous selections made in the past for that column. How do I sort this? I know I can sort this if I reference a different column, but since this is the same column how do I convince this to sort in my dropdown?

LeventK

You need to use one of the below expression in the Valid_If or Suggested Values expression of your ENUM column.

SORT(SELECT(TableName[ColumnName],TRUE,TRUE),TRUE) // Sorts the selected column values in descending order

SORT(SELECT(TableName[ColumnName],TRUE,TRUE),FALSE) // Sorts the selected column values in ascending order

View solution in original post