cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

This Gallery Filter is performing strangely.

The Items property in my Gallery are filtered like this:

 

Filter(FinishedGoodsMaster,  SearchInput_2.Text in stDescLine1 || SearchInput_2.Text in stCodeParent ||
txtQrCode2.Text in stCodeParent)

This works fine if I enter a value in SearchInput_2.Text but not if I just put a value in txtQrCode (both Text Input fields).

Unusually, if I start entering a value in SearchInput_2, it suddenly filters on txtQrCode!

Am I getting these OR operators wrong?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Champion
Community Champion

Re: This Gallery Filter is performing strangely.

This post would be helpful.
https://powerusers.microsoft.com/t5/Building-Power-Apps/Multiple-Search/m-p/57765#M23904

If you like this post give thumps up. If it resolved your request then mark as a solution

View solution in original post

3 REPLIES 3
Highlighted
Community Champion
Community Champion

Re: This Gallery Filter is performing strangely.

This post would be helpful.
https://powerusers.microsoft.com/t5/Building-Power-Apps/Multiple-Search/m-p/57765#M23904

If you like this post give thumps up. If it resolved your request then mark as a solution

View solution in original post

Highlighted
Post Patron
Post Patron

Re: This Gallery Filter is performing strangely.

Brilliant @eka24  - this works a treat:

 

Filter(FinishedGoodsMaster,  (SearchInput_2.Text in stDescLine1) , (SearchInput_2.Text in stCodeParent) ,
(txtQrCode2.Text in stCodeParent))
Highlighted
Community Champion
Community Champion

Re: This Gallery Filter is performing strangely.

Always welcome

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,359)