Enum list value show in user setting column

[Gunasuriya_Ravi]

I am having a table Role
I am having a column Members has enumlist and base type is ref from employee table
If i add a member in the Role Eg.(admin) and members(x,y,z)
I need to show each members user setting role column has admin
I getting error ,I am trying lookup the value of role in the user settings

[1minManager]

So I think the issue is you’re trying to compare lists and single items. Please reply with what [Rolename] and [Members] columns are (type).

[Gunasuriya_Ravi]

role name is text
Member is Enum list with the ref of employee table.

[1minManager]

What column type is the Employee key column?

What is the email address column name in the employee table?

[Gunasuriya_Ravi]

What column type is the Employee key column?

Text

What is the email address column name in the employee table?
Email ID

[Gunasuriya_Ravi]

Any suggestion ??

[Steve]

help.appsheet.com

IN()

Is item in list?

[Gunasuriya_Ravi]

I am using this Expression,cant get the values in the virtual column
I want the group members to display in this column ,when i select the group in the Reviewer column
Suggest any expression??I am not getting the values.

[Gunasuriya_Ravi]

What column type is the Employee key column?
Text

What is the email address column name in the employee table?
Email ID