Announcements
Hello,
I have a SP list that I am trying to use is Powerapp Gallery and filtering to it show only items for that login user, also that list item is originally is created by managers and I want user to knowledge their process so I have created a Power app that user can go and update. I have tried using filter function to show items matching with login user but its not working. it ends up creating new line item in the original list. Please help !!
Hi @jasminepatel90 ,
Try This Code In gallery Item Property
Filter(YourSPList, 'Created By'.Email = User().Email)
Fuel our success! 🚀 Give a thumbs up and click 'Solution Accepted' to supercharge our community. Your actions speak volumes!Warm regards,Muhammad Ali
@M_Ali_SZ365 thank you for quick response but my issue is that the list item is created my other manager so I cannot filter by Created by I do have a people picker field that Manager uses to enter employee name and I tried filtering that filed using same formula as above but it says we didn't find any data.
Filter(ProgressReport,EmployeeName.Email = User().Email)
@jasminepatel90 ,
For filtering a gallery by a people picker field in SharePoint, use:
Filter(ProgressReport, EmployeeName.Email = User().Email)
Ensure 'EmployeeName' is the internal name of the people picker field and contains the correct email. If no data is found, verify the field's data and the match with User().Email.
@M_Ali_SZ365 thank you so much I am able to pull up the current user and I also have edit form which I am connecting to current gallery so it shows me same list item and user can make changes that will only that list item but when I try to click on the acknowledgment toggle and save it creates new item in the list instead of updating current selected item. Please Help
Hi @jasminepatel90
To fix the issue of the edit form creating a new item, ensure the form is in edit mode and linked to the selected item in your gallery. Set the form's DefaultMode to FormMode.Edit, and its Item property to GalleryName.Selected. Also, use SubmitForm(FormName) in your submit button's OnSelect property.
@M_Ali_SZ365 thank you so much it worked ! you're Awesome !
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 530
WarrenBelz 459 Most Valuable Professional
Haque 314
