Sort with an If Statement

(0) Share

Report

Posted on by Jct7878

New to Power Apps - thanks for the help on what I feel has to be an elementary question.

How do I sort a gallery when “ALL” is selected by “Created” the base code is this:

If(searchdropdown.Selected.Value="All",Receipts, Sort(Filter(Receipts,creditcard.Value=searchdropdown.Selected.Value),Created,Descending))

The sort is working when I select a value other than “All” in the drop down box. I’ve tried everything I could think of with my limited knowledge of Power Apps.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
I confirm that your original statement doesn't work. I can get this statement to work when there is a Sort on both options for the If() statement:
If(searchdropdown.Selected.Value="All", Sort(Receipts, Created, Descending), Sort(Filter(Receipts,creditcard.Value=searchdropdown.Selected.Value),Created,Descending) )
Try and see if this works for your situation.

Bryan

Was this reply helpful? Yes No
Jct7878 4 on at

Like
a
(0)

Report
Copy link

Link copied!

This worked perfectly. Thanks!

Was this reply helpful? Yes No