Hello all, I would like some help on searching on a gallery. I have a simple app and am using a SP List as a data source ('Applications').
Ideally, this would be a Filter of items from a Choices column, that can be further narrowed down by a Search of multiple text fields. And maybe throw a further filter in for good measure. Can change the Choices for a text box if easier. I have watched multiple videos, read multiple articles, but every suggestion doesn't seem to work for me ☹️.
Each function works splendidly well on its own:
Filter(Applications,Status=StatusDropdown.Selected.Value) //Changed this from Choice to Text column & 'hardcoded' in the Items: In progress, Approved, Rejected
Search(Applications,SearchBox.Text,"Surname","Company","Email") // I can also use Filter with StartsWith and multiple conditions, and all of these are good.
If the above two could be combined into one, that would do. Colleagues will be using it by focusing on those In Progress and then using Search for specific criteria. Bear in mind there will be over 100 applications at any one time.
Assignee is a Choice column on the List, if that could be integrated as an additional optional filter, that would be grand.
Ideal solution: Filter by Status; then narrow down using Search; with final Assignee filter; all should be able to work independently, and together.
Every combo I try I get errors: Search then Filter, using And/Or, and various others. It may be a syntax thing as I'm struggling with that; but even copying exactly from, eg Reza's videos, gives the unspecific 'your formula has errors'.
Any pointers appreciated! Happy to provide more info.
