Security Filters on Database structure not working on all USERMAIL()

Good day All

I am struggling to figure out why this basic security filter is only working on my USERMAIL().

If I preview it as another USERMAIL() it is not showing any rows with this USERMAIL().

The filter is USEREMAIL() = [Account Manager].[Email]

Not showing rows that contains this email

I am using the native Appsheet database.

Double check that USEREMAIL() is actually returning the previewed-as email, instead of your original one. Can’t remember if it changes or not.