SELECT function to select items from a column which is ENUMLIST type

[Sanjaykumar]

Hi community,

I am facing an issue with the SELECT function in which I am trying to select row items according to the matching category. Below is my syntax in ‘Suggested Values’ ,

Select (Complaints[Preliminary Cause], ([complaint]=[_THISROW].[complaint]))

Here, both ‘Preliminary Cause’ and ‘Complaint’ column are ENUMLIST type.
I am getting below error,

I cannot convert the complaint column to ENUM or TEXT, I need multiple selection of items in dropdown.

Below is my table.

[Marc_Dillon]

help.appsheet.com

IN()

Is item in list?

[Sanjaykumar]

Hi Marc, Thanks for responding.
I believe IN() 's return value is boolean (TRUE/FALSE). How will the result help me?
Can you please elaborate?

Thanks

[Joseph_Seddik]

Sanjay:

I believe IN() 's return value is boolean (TRUE/FALSE).

Exactly as your expression: [complaint]=[_THISROW].[complaint]