Gallery item filter current user

[jasminepatel90]

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 !!

[M_Ali_SZ365]

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

[jasminepatel90]

@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)

[M_Ali_SZ365]

@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.

Fuel our success! 🚀 Give a thumbs up and click 'Solution Accepted' to supercharge our community. Your actions speak volumes!
Warm regards,
Muhammad Ali

[jasminepatel90]

@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

[M_Ali_SZ365 · Accepted solution]

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.

Fuel our success! 🚀 Give a thumbs up and click 'Solution Accepted' to supercharge our community. Your actions speak volumes!
Warm regards,
Muhammad Ali

[jasminepatel90]

@M_Ali_SZ365 thank you so much it worked ! you're Awesome !