Filtering data user

[Harley525]

I want todo two things  one i want to filter my data for the user that has logged in and i want to not filter data for my app for the admin user.

I get one error on the first issue see attachments.

and for the second issue i don't know how to do this.

I hope to hear from you all how to solve this.

[zmansuri]

App: OnStart:

Set(varUser,Lower(User().Email));

Gallery Item:

Filter(DataSource,Lower(Office365Users.MyProfileV2().mail)=varUser);

if you have 1 or 2 admin and they are there for long time. You can hardcode their email id. Else you will have to create a table and provide them roles. or add roles to your existing user table.

Filter(DataSource,Lower(Office365Users.MyProfileV2().mail)=varUser || varUser=""xyz@gmail.com || varUser="abc@gmail.com");

that way if abc or xyz logs in they see all the data. but if someone else logs in they will see only their data

[Harley525]

When using the email of the user and your data source is growing i can only see 500 in the preview,

i have seen in a video of Shane Young that you can go around this with the user id as you can see in the attachment of my first question.