We have a sharepoint list as the source called 'Create Expense Claim' for our gallery.
The items are filtered on the Status column, having values of either Pending or AP Approved.
I want to sort by status descending, and by item ID descending
But I can't get it to compile in the designer.
here is my code:
SortByColumns(
Filter(
'Create Expense Claim',
Status.Value = "Pending" || Status.Value = "AP Approved"
),
"Status",
Descending,
"ID",
Descending
)
If I use the Sort on one column, it works fine:
Sort(
Filter(
'Create Expense Claim',
Status.Value = "Pending" || Status.Value = "AP Approved"
),
"Status",
Descending,
)
so how can I sort my filtered list on both columns?
I don't see any issues with your code... what do you mean by "it wont compile in the designer?" Are you receiving an error message or red underline? Please share a screenshot with your full code and error message.
SortByColumns(
Filter(
'Create Expense Claim',
Status.Value = "Pending" || Status.Value = "AP Approved"
),
"Status",
Descending,
"ID",
Descending
)
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."