Unanswered

Filter a galley by user- Power App

(0) Share

Report

Posted on by AN-23071134-0

I am looking to filter a Power App Galley by the current user. I have a SharePoint list that contains the email address of everyone who will be using this power app. It is assumed that the user did not create the data in the Sharepoint list. The Sharepoint list has over 4,000 records, so any current solution I have doesn't work.

Does anyone know how to filter a gallery pulling for a large SharePoint list by the user, where the user is not the creator of the data in the SharePoint???

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

1) Store the Current user email in a variable using Set(currentUser, User().Email)

2) Filter the gallery based on some field that matches the current user email. I'm assuming this is where you say the list contains the email address of everyone.

The question is what field do you want to filter on since you can't use Created By if the user didn't create the item in SharePoint.

Was this reply helpful? Yes No
AN-23071134-0 on at

Like (0)

Report

Thank you for your response.

I have a field in my SharePoint list called "Email" which I would like to filter by. The Goal is when the user logs in, the list in the gallery is filtered by that users email. The Gallery should display only the row in the SharePoint associated with that matching email.

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

Then store the user's email as I mentioned and Filter the Items property of the gallery using the Email column is equal to the CurrentUser variable.

Was this reply helpful? Yes No
AN-23071134-0 on at

Like (0)

Report

Thank you again!

What would the formula for the filter be? This is what I am currently using and it is not returning any values:
Filter('Employees', currentUser = 'Email')

The SP list is named "Employees" and the column on that list with the email addresses is "Email".
Do you see my error?

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report
The condition is backwards and you need to set the value of CurrentUser. Also double check on the column name. If it doesn't have a space then it probably won't use single quotes.

Set(currentUser, User().Email); Filter('Employees', Email = currentUser );

Was this reply helpful? Yes No