I am trying to make an app where the gallery collection sorts the items by a value that is stored in a combobox column. The code I am using is this:
SortByColumns(
Filter('Time Tracking',CurrentUser.Email = Author.Email, StartsWith(Title, TextSearchBox1.Text)),
"Pay_x0020_Period",
If(SortDescending1, Ascending, Descending)
)The error is "SortByColumns has some invalid arguments."
I am declaring and setting CurrentUser in Onstart, so that's not the issue.
If I chage "Pay_x0020_Period" for any none combobox column, it works fine.
What gives?

Report
All responses (
Answers (