I have an app where the home screen has several buttons. They are visible based on the user's access level (user, editor, admin). I've tested with my admin account and I can get all the buttons to appear. I've also changed the admin accounts access level to 'user' and only the user level buttons appear. That's all fine. Where I run into issues is with my test account. The permissions are set to 'user' and no buttons appear. If I change to 'admin' and still no buttons appear. I am thinking it might have to do with permissions on the role level but not really sure what permissions are needed if any.
This is the code I am using to check the user's access level
LookUp('App Users', 'Email Address' = User().Email And ('Admin Access' = "Yes" Or 'User' = "Yes"),true)
NOTE: I also put the users full name and email address on the screen with this code and this all works fine.
User().FullName
User().Email
As an additional test to see if the app is actually reading the table for this 'test' account I added a text box and used this code. It does not return the user's email address as expected.
LookUp('App Users', 'Email Address' = User().Email, 'Email Address')