Issue with EnumList Column Formula in Ordering Suggestions

[Soufiane_M]

I have an EnumList column with 'Suggested values' where I've set the formula to ORDERBY( SELECT(verresuggestion[detail], true), [nature]).

The aim is to retrieve suggestion values from the 'verresuggestion' table and order them based on the 'nature' values. While the formula appears correct, it's not functioning as expected and I'm encountering an error message stating 'Unable to find column 'nature'.

[Suvrutt_Gurjar · Accepted solution]

ORDERBY() works with only key columns list. If [detail] is not the key column of the table, ORDERBY() will not work.

You could instead try below. Please create a expression in a VC called say [Details_by_Nature] something like

ORDERBY( verresuggestion[key column of the table verresuggestion], [nature])

In another VC you will get list of details sorted by [nature] can be something like 

[Details_by_Nature][detail]