[HELP] Lookup a list on a table that contains a value from another table

[borgir]

Hi, please help in creating an expression for the following problem (been scratching my head for hours now):

I have 2 tables, <Table 1> and <Table 2>.

<Table 1> contains a fruit, say "Mango". I want to match a record from another table, <Table 2>, which has a column that each contain a list which has a different list of fruits: [Mango, Orange, Apple]. 

What expression should I use such that I can connect both records that contain just 1 of the element from the list?

[dbaum]

Here's a draft expression to accomplish what I think you're asking:

SELECT(Table2[ID], IN([_THISROW].[Fruit], [Fruit_List]))

Depending on the need you're trying to address via the particular technique you ask about, there may be more effective data designs or a more direct suggestion using your current data design. In particular, consider whether you have implemented AppSheet's powerful References between tables - AppSheet Help.