You’re offline. This is a read only version of the page.
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???
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.
Share
Report
All responses (
Answers (
Set(currentUser, User().Email);
Filter('Employees', Email = currentUser );
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?
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.
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.
#1
WarrenBelz
146,587
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,928
Most Valuable Professional
