Filtered Row not showing even if expression is True

Hi,

I have an App launcher (name, logo, appname) and a permissions table (email, appname) where I store my permissions. I have an expression IN(USEREMAIL(), [Related Permissions][Email]) that returns all rows that are true. But my slice doesnโ€™t show anything. I originally want this in a security filter but security filters didnโ€™t let me use reference tables.

Now upon testing my expression, the rows I wanted returned โ€œtrueโ€ in the expression test. But upon implementing it to my slice, no rows showed up.

0 2 172
2 REPLIES 2

This might be one to engage support@appsheet.com

I did a work around on this. I applied a USEREMAIL Filter to my Permissions table (so all it did return are relations of the user and apps). Then I used IN([AppName], Permissions[AppName]) in my security filter. This works, but Iโ€™m just not sure why the first one didnโ€™t work, since I think the logic behind it is correct since the test expression returned correct. (or am i missing something?)

Top Labels in this Space