web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter doesn't make se...

Power Apps

Answered

Filter doesn't make sense what I am seeing

(0) Share

Report

Report

Posted on by Mattw112b

1,088

I have a gallery with a filter.

This filter works fine and returns 200 records:

Filter(Sponsor_1,Active = true && 'Role to Sponsor For'.Value <> 'Last Title' && CorporateOrField.Value = "Field")

This filter returns nothing:

Filter(Sponsor_1,Active = true && CorporateOrField.Value = "Field")

Only different in the above is I removed:

&& 'Role to Sponsor For'.Value <> 'Last Title'

How is it possible that me removing an "AND" extra filter, makes no results? Obviously all "ANDs" must be true to return results, so why would removing one, not show results?

Anything I'm missing?

Thanks,

Terry

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 156,740 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Mattw112IG ,

I don't think you are missing anything in the logic space, however the Boolean true/false field is not Delegable and I have had some inconsistent results using it straight on lists. For the purposes of debugging, try this

With( { wField: Filter( Sponsor_1, CorporateOrField.Value = "Field" ) }, Filter( wField, Active = true ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Mattw112IG

In addition to @WarrenBelz response to try, also consider that PowerApps has an order of operations as well on formulas and sometimes the strings and numeric values will give you a different than expected result.

So consider giving this a try as well:

Filter(Sponsor_1,Active && (CorporateOrField.Value = "Field"))

Join the conversation