Hi @Anonymous,
Could you please share a bit more about the Time of pick up: column in your SP list? Is it a Choice type column?
Do you want to sort your Gallery items by "Date of pickup:" field and "Time of pickup:" field?
Based on the formula that you provided, I think there is something wrong with it. I have made a test on my side, please take a try with the following workaround:
If the Time of pick up: column is not a Choice type column, please modify your formula as below:
SortByColumns(
Filter('Transport Booking Summary', StartsWith(Title, TextSearchBox1.Text)),
"Date_x0020_of_x0020_pickup", If(SortDescending1, Descending, Ascending),
"Time_x0020_of_x0020_Pick_x0020_u", If(SortDescending1, Descending, Ascending)
)
Note: The 'Time_x0020_of_x0020_Pick_x0020_u' represents the Time of pick up column in your SP list. I assume the 'Date of pickup' column is a Date type column in your SP list.
If the Time of pick up: column is a Choice type column, please take a try with the following workaround:
Set the Items property of the Gallery to following:
SortByColumns(
AddColumns(Filter('20190126_case3', StartsWith(Title, TextSearchBox1.Text)), "TimeOfPickup",'Time of pick up:'.Value),
"Due_x0020_Date", If(SortDescending1, Descending, Ascending),
"TimeOfPickup", If(SortDescending1, Descending, Ascending)
)
On your side, you should type:
SortByColumns(
AddColumns(
Filter('Transport Booking Summary', StartsWith(Title, TextSearchBox1.Text)),
"TimeOfPickup",
'Time of pick up:'.Value
),
"Date_x0020_of_x0020_pickup", If(SortDescending1, Descending, Ascending),
"TimeOfPickup", If(SortDescending1, Descending, Ascending)
)
Note: The Choice type column could not be used as a Sort column within the SortByColumns function.
More details about AddColumns function, please check the following article:
AddColumns function
Best regards,
