Match enumlist value in other table

[BOMEXPORT_ADMIN]

Hello Community,

I’m trying to find a way in order to compare a value by another value hat exists in a different table (wich is an Enumlist type).

Please advise

[Arthur_Rallu]

Hi @BOMEXPORT_ADMIN

Your expression will need to retrieve the Enumlist values from that other table, so you’ll need to use a SELECT statement in the expression (see SELECT() | AppSheet Help Center).

I think you’ll need to provide a little bit more info so people can help you further.

[BOMEXPORT_ADMIN]

IN(
[PAYS],SPLIT(
DETAILS CONVENTIONS[NOM DU PAYS],","
)
)

I find it after many tries and researchers on the community platform

Thank you for your answer