How to make a list of values of a column in an other table

Hi appsheet,

I have used this expression in a virtual column of the table Personnes:
SELECT(
Registration[Equipe],[ID Personne]=[ID])-LIST()

What I would like to do:
In table Personnes I want to make a list of the different values in [Equipe] of the table Registration, and this for the rows in table registration where its column [ID Personne] = the column [ID] of the table Personnes.

When I add the expression above in a virtual column in my table Personnes itโ€™s comparing column [ID Personnes] and column [ID] from my table Registration. (and not [ID] from table Personnes)

Any ideas?
Greetings, Bram

0 8 1,954
8 REPLIES 8
Top Labels in this Space