The collection name is colSelectedChecklist and Column Name is EHSCheckList.
Using the following formula, I can get the first row of the collection. But it is not in alphabetical order.
First(colSelectedChecklist).EHSCheckList.Result
Tried below Sort/SortColumn formulas. But it is not working.
Sort(colSelectedChecklist,EHSCheckList,Ascending)
First(Sort(colSelectedChecklist,EHSCheckList,Ascending))
SortByColumns(Distinct(colSelectedChecklist,EHSCheckList),"Result",Ascending))
Did you ever get this working?
Getting the following error for - First(SortByColumn(colSelectedChecklist,"EHSCheckList",Ascending))
First(SortByColumn(colSelectedChecklist,"EHSCheckList",Ascending))