How to get the label column of the related table from the ID list of the Enumlist

AppSheet AppSheet Q&A
1

There are two tables.
The first table has an ID column and a name column, and the second table has an Enumlist column with a REF reference to the ID column of the first table.
I want to get the data of the name column of the row of IDs obtained by Enumlist in the second table.

I tried to write an expression like this, but it gives me an error

any(
select(
1stTable[NAME],.
[ID]=[_THISROW]. [Enumlist_Column],.
)
)

Cannot compare Text with List in([ID] = [_THISROW]. [Enumlist_Column])

When there are multiple values of Enumlist, what expression should I write to get the value associated with each one from the relation table?
Any advice would be appreciated.

1 Like
2

Lazy option, probably wont work, put [ID] inside a list, List([ID]), better option, you could use CONTAIN to check if the ID string is in the EnumList, CONTAIN([_THISROW].[Enumlist_Column],[ID])

1 Like
3

Tnank you so much!