Answered

Use sort, if and filter in one formula

(0) Share

Report

Posted on by tmarch

Is it possible to sort and filter a gallery with an if statement? There are two filters currently. One is for location, and that one filters the other one which is for Asset. I want the defualt of the gallery to show all items, but when the user selects the asset I want it to filter the items for that asset.

I have tried the following, but it errors out:

Sort(
If(Facility.Selected.Value="All"),
Machine_Projects,
Filter(
Machine_Projects,
Asset=Line.Selected.Value),
'Date Down')

HELP!!!! Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

timl 37,205 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @tmarch

You could try incorporating your If condition into your call to Filter like so:

Sort( Filter(Machine_Projects, Facility.Selected.Value="All" || Asset=Line.Selected.Value
), 'Date Down'
)

Was this reply helpful? Yes No
tmarch 34 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your reply. Unless the user selects one of the filters, I want the gallery to show all items in the SP list. Using the solution you provided did not do that.

Was this reply helpful? Yes No
tmarch 34 on at

Like (0)

Report
Copy link

Link copied!

@timl Thank you for your reply. Unless the user selects one of the filters, I want the gallery to show all items in the SP list. Using the solution you provided did not do that.

Was this reply helpful? Yes No
timl 37,205 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @tmarch

Could you confirm how the formula is not working? If the user does not select either of the filters, does your gallery show no records, or does it show more records than you expect?

With none of the filters selected, can you add a label and set the text property to the following:

(Facility.Selected.Value="All")

Can you confirm that this resolves to true?

Was this reply helpful? Yes No
tmarch 34 on at

Like (0)

Report
Copy link

Link copied!

@timl Yes, if the user does not select either filter nothing shows in the gallery. The label text shows "true" when "All" is selected; "false" when it is not selected.

Was this reply helpful? Yes No
Verified answer

tmarch 34 on at

Like (0)

Report
Copy link

Link copied!

After trying a lot of different formulas etc, here is the workaround: I created a text input for Facility, and a text input for Asset. The Defaults were: "Facility.Selected.Value", and "Asset.Selected.Value". Then on the Gallery Items were: Sort( If( Facilityduplicate.Text="All", Machine_Projects, Filter( Machine_Projects, Asset=Assetduplicate.Text)),'Date Down')

Was this reply helpful? Yes No