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?
Solved! Go to Solution.
Brilliant @eka24 - this works a treat:
Filter(FinishedGoodsMaster, (SearchInput_2.Text in stDescLine1) , (SearchInput_2.Text in stCodeParent) , (txtQrCode2.Text in stCodeParent))
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.