Hi
I have developed a Power App with a gallery and a working search function.
The current working formula used is :
Search('Letters Forecast',SearchBox2.Text,"ProductCode","Form_x002f_LetterName")
However, I want to add another filter to this search. I don't wont the gallery to show any results where the Progress Status box says "Completed", as they may be various submissions with the same product code or letter name.
I have made the following formula as a starter but it does not seem to be acceptable by Power Apps:
Search(Filter('Letters Forecast', If('Progress Status'="Completed",true,false)),'Letters Forecast',SearchBox2.Text,"ProductCode","Form_x002f_LetterName")
All these formulas have been entered in the 'Items' section of the gallery, but im not sure this is the right area for this additional request