Enum list has slice filter

[demo_demo]

I am having a Enum list with ref the employee table with Email Id has key ,i need to submit the record to approve , more than two Department head .
I want to filter row ,i need the record to be show only to the selecting the department head in the a separate view
How to filter the DH with USEREMAIL()
Suggest any expression

[LeventK]

help.appsheet.com

Limiting Users to Their Own Data

You can use Security Filters to control which records a user can see and update.

help.appsheet.com

Security: The Essentials

Security is vital because your data is exposed through your app.

[demo_demo]

I need to filter the record in the Slice

[LeventK]

So?

[demo_demo]

I am getting an error while using this expression

Reviewers is the Enumlist with ref of Employee.table with the key Email ID

[LeventK]

@demo_demo
SELECT() expression returns a List value. The row filter condition in the slice shall return a Boolean (TRUE/FALSE) value. As the error message indicates, you are trying to compare a List against an Email (which is basically a text value in essence).

[Steve]

help.appsheet.com

IN()

Is item in list?

[demo_demo]

Thank you steve ,its working