cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stapes
Post Prodigy
Post Prodigy

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
eka24
Super User
Super User

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
eka24
Super User
Super User

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

Brilliant @eka24  - this works a treat:

 

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

Always welcome

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,029)