How can we sort the order of the drop down li...

[Koichi_Tsuji]

How can we sort the order of the drop down list by either ascending or descending? I made one column type to “Ref”, and can get the drop down list from the table which is referred to.

But the order of the data is not cleanly sorted out as users keep adding new rows. How can we sort the drop down list dynamically?

[Aleksi_Alkio]

You can use ORDERBY expression with the ref column in Valid_If. The parameters to this function are OrderBy(ListOfRecords, SortColumn, True/False).

[Koichi_Tsuji]

Thank you. I wondering which column’s valid if we should put this expression. Whenever we create the ref, the virtual column is automatically being created, should we put in there? Or the column we set the column type as “Ref”?

The expression of orderby, what does “list of records” mean?

[Koichi_Tsuji]

I played around and find out how I form the expression and where to input now!

[Brat]

where to put the orderby() formula for this?

[Aleksi_Alkio]

Good

[paullynun]

mine looks like this for a descending order:

ORDERBY(Operations[Operation ID],[Date],TRUE)