I am trying to get a relational, select list of the Teams in the Teams column for each of the People in the People table (by referencing the Team Members column in the Teams table) .
Grateful for any advice please!
I am using this formula in the relational column Teams In the People table but it is not displaying anything.
Teams.Filter([Team members].contains(thisRow))
Hi Andre,
You almost got it, just needed to add .people at the end → Teams.Filter([Team members].contains(thisRow)).people
The rows in the People table are still just rows, even if the Display field is a people column. That’s why the filter didn’t work before, since [Team members] contains people objects and not rows from the People table.
Pablo
Thanks Pablo, that makes sense and I have applied it to the Teams row of the People table in the doc I linked to above but still see no content.
Hi @Andre_Head
The process works the opposite way. You are trying to return all the teams that a specific person is part of.
What @Pablo_DV pointed out is that your “Team Members” column in the “Teams” table does not hold a relation to the “People” table—it is a people column linked to the users. On the other hand, the “People” table has a relation to the “Teams” table.
Therefore, what you need to search for is the “People” column in the “People” table within the “Team Members” column of the “Teams” table. The result should be a set of rows from the “Teams” table.
The formula must be something like this:
Teams.Filter([Teams member].contains([thisRow].People))
Best regards,
Arnhold
You are right Felipe, my explanation doesn’t match the formula I wrote, don’t know what I was thinking!
