Basic Table Filter Function

[Jimmy_C]

Hi guys,

This is probably basic but cant seem to figure it out. I have 2 tables in separate sections (Profiles, Groups).
Profiles table is a list of names and Groups is a list of groups. Using a table look with multiple select I am able to link multiple profile names from Profiles to associated groups in the Groups table.

What I would like to do now is display list of groups associated with each profile, presumably with a filter function on the column. Please see below example.

Thanks guys!

[mallika]

Hi @Jimmy_C,
Can you try changing the format of Groups to text and using this formula

Groups.Filter(Profiles.Contains(thisRow)).Name