Answered

Filter Browse Gallery by current user email and gallery item

(0) Share

Report

Posted on by ddas

I have a gallery that is populated by a sharepoint list. I want to filter the list by the info that is in the gallery and the user that logs in to view it. For instance, if the manager of a user views the gallery. I only want the manager to view the info that is for him. Right now I have this SortByColumns(Filter('Review Form', StartsWith(Reviewer_x0020_Name, TextSearchBox1.Text)), "Reviewer_x0020_Name", If(SortDescending1, Descending, Ascending)) which sorts by Reviewer name. If the Reviewer Name matches the Display Name of the logged in user then I only want it to show what is for the Reviewer.. Any help would be greatly appreciated. Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @ddas,

There is a function User().FullName that will return the name of the current user. If you set the filter on your gallery to: Filter('Review Form',Reviewer_x0020_Name=User().FullName) I believe that should do it. You don't need the sort because the gallery will only show one reviewer. The User() function can also show the email address: User().Email if you want to filter by that.

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like (0)

Report
Copy link

Link copied!

Hi @ddas and @Drrickryp
Please be aware of serious performance issues of the User() function when used for filtering etc.
These can be overcome with something like this:
https://baizini-it.com/blog/index.php/2017/08/29/powerapps-user-function-cache-current-user-onstart/

Was this reply helpful? Yes No
ddas 78 on at

Like (0)

Report
Copy link

Link copied!

Hi @Drrickryp

Thanks for the quick response and the help. It doesn't seem to be working for me. I added what you suggested Filter('Review Form',Reviewer_x0020_Name=User().FullName) and my data in the gallery disappears and is empty? Any suggestions on why that might be happening?

Was this reply helpful? Yes No
ddas 78 on at

Like (0)

Report
Copy link

Link copied!

Hi @Meneghino,

I understand and thanks for the info.

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@ddas,

the gallery will be empty if your User().FullName does not exactly match a name in the Reviewer_x0020_Name column. Put a label on the screen and set its Text to User().FullName and see if there isn't a Reviewer with the same name.

Was this reply helpful? Yes No
ddas 78 on at

Like (0)

Report
Copy link

Link copied!

@Drrickryp

One of the letters was lower case in the name and that's why it wasn't populating. Thanks for the help. I really appreciate it.

Was this reply helpful? Yes No