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.
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?)
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |