I have two filters that I’m trying to use on a gallery, one to remove duplicate items within the SharePoint list from view, and the other is a search function. The formulas are:
- Filter('Post Interview Feedback',StartsWith('Unique Role ID'.Value,'JD Search_3'.Text))
- The reason I’m using a filter formula rather than a standard search is that I’m using a SharePoint lookup column and was having a nightmare trying to enable the search function to work correctly.
- ForAll(Distinct('Post Interview Feedback','Unique Role ID'.Value),LookUp('Post Interview Feedback','Unique Role ID'.Value=Result))
- This filter means that each ‘Unique Role ID’ only appears once within the gallery.
I’ve tried quite a few variants to combine these two formulas, however have been unable to make it work.
What would be the approach here to combine both formulas together, please?
Data source: Post Interview feedback
Let me know if you need any more information.
