Answered

Filtering By User

(0) Share

Report

Posted on by UrquidiAlex

I have the filter below on a gallery, and would like to add an additional filter to filter by user but don't know where to add it. The goal is to only allow users to view their own request.

SortByColumns(Filter([@ClientReassignmentRequest],If(StatusFilter.Selected.Value="All",true,Status.Value=StatusFilter.Selected.Value), StartsWith(Summary, TextSearchBox1.Text)), "Created", If(SortDescending1, Descending, Ascending))

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

BCLS776 8,994 Moderator on at

Like (0)

Report
Do you have some sort of Username column in your table you can use in the Filter against the currently logged-in user? If so, you could insert the code where indicated:

SortByColumns( Filter([@ClientReassignmentRequest], If(StatusFilter.Selected.Value="All", true, Status.Value=StatusFilter.Selected.Value ), StartsWith(Summary, TextSearchBox1.Text) , // Insert your user filter term here e.g. UserName = User().FullName ), "Created", If(SortDescending1, Descending, Ascending) )

Hope that helps,

Bryan

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @UrquidiAlex,

Based on the issue that you mentioned, do you want to filter the gallery based on the current user?

Could you please share a bit more about your scenario?

Actually, if you sue the User() function to define the current login user, please refer to the Email parameter.

Modify your formula as below:

SortByColumns(Filter([@ClientReassignmentRequest], If(StatusFilter.Selected.Value="All",true,Status.Value=StatusFilter.Selected.Value), StartsWith(Summary, TextSearchBox1.Text), User().Emai=RequestedBy.Email), // Here I assume that you have a Person column to store the user info who requested. "Created", If(SortDescending1, Descending, Ascending) )

Or, if you use the auto-generated column CreatedBy column to save the requester, I think you could just modify as below:

SortByColumns(Filter([@ClientReassignmentRequest], If(StatusFilter.Selected.Value="All",true,Status.Value=StatusFilter.Selected.Value), StartsWith(Summary, TextSearchBox1.Text), User().Emai='Created By'.Email), // Here I assume that you have 'Created By' column to store the user info who requested. "Created", If(SortDescending1, Descending, Ascending) )

Hope it could help you at some degree.

Was this reply helpful? Yes No