Issues combining two formulas together

[Anonymous]

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. 

[EddieE · Accepted solution]

@Anonymous 

Have tried replacing the Filter() <data source> with the entire 2nd formula, ie

’Post Interview Feedback’ — becomes — ForAll(…)

[Anonymous]

That's worked perfectly, thanks @EddieE really appreciate the help!