Restrict Users to view only their specific records in Gallery

[gumgih]

Hi All,

I'm new in PowerApps development, want to build a functionality to show manager specific records in Gallery based on their email address stored in SharePoint list.

for e.g. if Mike logins than he can only see his pending records in Gallery, not other managers' records stored in the Sharepoint list.

currently filtering the gallery based on 2 dropdowns (Manager and User) selections, using the below function. attached is the screenshot for the same.

Search (Filter ('DS05.02.17_Review_database_accounts','Manager Mail Id'=Dropdown1_2.Selected.Result && 'Request Status' = Dropdown1.SelectedText.Value),Dropdown2.Selected.Result,"User_x0020_Name")

Thanks,

Mayank

[VijayTailor · Accepted solution]

Hi @gumgih ,

You can use like below.
varCurrentUser.Email= User().Email

Thanks,

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay

[gumgih]

@VijayTailor  Thank you 🙂