Hi All,
I'm sorting a gallery using this working formula:
Sort(Search( Search(Issues, "Closed", "Status"), "Columbus","Title" ), Modified, SortOrder.Descending)
I'd like to modify this to use SortByColumns so that I can have an ascending/decending icon with the onselect property of:
UpdateContext({SortDescending1: !SortDescending1})
What Should I change my original formula to?
Thanks.
Solved! Go to Solution.
Sorted it:
SortByColumns(Search( Search(Issues, "Closed", "Status"), "Columbus","Title" ), "Modified", If(SortDescending1, Descending, Ascending))
Sorted it:
SortByColumns(Search( Search(Issues, "Closed", "Status"), "Columbus","Title" ), "Modified", If(SortDescending1, Descending, Ascending))
Cool.
So in words ... what is Search( Search(Issues, ..... doing ? Saying ?
User | Count |
---|---|
160 | |
84 | |
68 | |
63 | |
61 |
User | Count |
---|---|
209 | |
146 | |
95 | |
82 | |
67 |