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))
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
We are excited for the next Super User season.
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021