Basic Table Filter Function

Jimmy_C · June 18, 2019, 2:14am

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 · June 19, 2019, 7:12am

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

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

Topic		Replies	Views
Filter by User() group based on lookup table	1	491	September 17, 2020
Filtering using multiple lookups from a table	13	2415	August 26, 2019
Filtering or looking up across multiple columns	3	378	August 28, 2021
Reference filtered column in another table	2	474	May 17, 2020
A filter formula is driving me nuts	4	944	March 5, 2020

Basic Table Filter Function

Related Topics