values ​​from another column enum list

[jdaf_2412]

Good day
if I have a [Table_1], with three columns:
*id,*column_1,*column_2
and in a field type enumlist *Permissions, from [Table_2] in which I select values ​​that come from *Column_2...... Table_1[Column_2]

How could I bring in another physical or virtual field, a list of the values ​​of *Column_1 that coincide with the ones I just chose?
Something like a lookup, but with more than one element.
Thank you.

[Marc_Dillon]

You lost me here:

Maybe this?

https://help.appsheet.com/en/articles/961544-dropdown-from-valid_if

or

https://help.appsheet.com/en/articles/2357314-select

[jdaf_2412]

Thanks for answering

What I want is to generate a list in another column (either physical or virtual), of the fields of [Column_2], depending on what I enter in [Permissions].
Attached image of what I'm looking for (highlighted in yellow)

[Steve · Accepted solution]

SELECT(
  Table_1[Column_2],
  IN([Column_1], [_THISROW].[permissions])
)