Hi,
I am trying to sort the values from my combobox without success. Here is my code.
If(
varCurrentLanguage = "English",
Sort(
ForAll(
Distinct(
Filter(
OM,
'Type of Authority' = cmbTypeAuth.Selected.Result
),
'Position Title'
),
{Result: ThisRecord.Value}
),
SortOrder.Ascending
),
Sort(
ForAll(
Distinct(
Filter(
OM,
'Type d''autorité' = cmbTypeAuth.Selected.Result
),
'Titre de position'
),
{Result: ThisRecord.Value}
),
SortOrder.Ascending
)
)
Any help would be greatly appreciated.
Thank you.