Help! How can I create a view of matching records?

Hi all, I have an app which is a bit like a User Directory where users create a profile adding information about themselves (name, location, email, role, interests). I’d like to set up a view where the user can see other users with the same interests. All of the data is captured in a main table ‘Data’, however the ‘interests’ are selectable from a list in another table called ‘Interests’. I’m stuck on how to create this view. I’ve tried creating a slice using ‘FILTER(“Data”,([Interests] = [_THISROW].[Interests]))’ but I get the error ‘The expression is valid but its result type ‘List’ is not one of the expected types: Yes/No’. Any ideas?

Solved Solved
1 38 1,481
1 ACCEPTED SOLUTION

Could you please try an expression something like below in the slice filter

AND(COUNT( INTERSECT( [Interests], SPLIT(SELECT(Data[Interests],[Email] = USEREMAIL()), “,”)))>0 , [Email]<> USEREMAIL())

Have not tested it.

Minor edits in expression done.

View solution in original post

38 REPLIES 38
Top Labels in this Space