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))
User | Count |
---|---|
257 | |
110 | |
97 | |
52 | |
39 |