Security Filter causes records not to load

AppSheet AppSheet Q&A
1

Hi,

I tried adding this security filter in my table to limit the view of who sees what…

LOOKUP(USEREMAIL(), “UserMaster”, “xEmailAdd”, “Role”) = “HR Admin”

This always causes appsheet to get stuck in this screen

kenz188188_0-1715053013158.png
kenz188188_0-1715053013158.png379×727 8.69 KB

2

Try this IN(LOOKUP(USEREMAIL(),“UserMaster”, “xEmailAdd”, “Role”),LIST( “HR Admin”))