Hi, have an app generated from a sharepoint list. In the gallery the items is set to,
SortByColumns(Filter([@JobRegister], StartsWith(Company, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))
I have a date field named DOE and want the sort icon to show most recent date
The sort icons Onselect is set to UpdateContext({SortDescending1:true})
Hi @Matt383 ,
As @Jagadeeshk suggested, if you want to sort by DOE column, you should use this column inside your Sort formula. So try to use this formula of your gallery:
SortByColumns(Filter([@JobRegister], StartsWith(Company, TextSearchBox1.Text)), "DOE", If(SortDescending1, Descending, Ascending))
Best regards,
Allen
Use DOE coulmn in place of title in sort function