Trying to add Sort to this Filter Syntax and its not working

(0) Share

Report

Posted on by punksterz626

I'm trying to add a sort to this syntax on the Item property of a gallery.

Current Syntax on Item

Filter(
'Org Chart',
'Reporting Manager' = Gallery3_1.Selected.Employee

I'm trying to add a sort based off of a column titled "Status" in descending order but it is not taking. Not sure what i'm doing wrong here. See below.

SortByColumns(Filter('Org Chart','Reporting Manager' = Gallery3_1.Selected.Employee)), "Status", descending)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Rusk 1,369 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
SortByColumns( Filter( 'Org Chart', 'Reporting Manager' = Gallery3_1.Selected.Employee ), "Status", Descending )

The main issue with the original formula was that the "Descending" argument was outside of the SortByColumns function's parentheses. In the corrected formula, "Descending" is included as a third argument within the parentheses, which tells Power Apps to sort the data in descending order based on the "Status" column.

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @punksterz626,

My apologies, I only now saw your response on the previous topic.
@Rusk's solution should do the trick 😊.

To add upon Rusk's answer: if the 'status' column is a choice column (no multi-select) you could use the following code:
Sort( Filter( 'Org Chart', 'Reporting Manager' = Gallery3_1.Selected.Employee ), Status.Value, Descending )

I hope this helps!

Was this reply helpful? Yes No
punksterz626 on at

Like (1)

Report
Copy link

Link copied!

this was the one that ended up working. Thank you.

Was this reply helpful? Yes No