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))
Check out the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.