Announcements
Hi all.
Another follow on from this thread about filter gallery and calculating hours (https://powerusers.microsoft.com/t5/Building-Power-Apps/Calculate-filtered-Gallery-values-based-on-logged-in-user/m-p/2090615#M522531)
Now I have managed to calculate total hours within a filtered list, into a text label in the app I need to update a column in a SharePoint list with said hours.
So Each logged in person has an entry in the SharePoint list, their payroll ID is the unique item in the list.
I have tried to use a patch function, however I don't have the option to select ThisItem, as seen below:
What am I missing here?
Many thanks
Are you trying to patch to a new list? For example something like:
Patch(WeeklyHours, {name: [username], hours: [sum of hours in gallery], status: "unpaid"})
Or are you trying to update specific entries in the same list you had in your last question?
@mmollet i am trying to update specific entries in the list from my last question
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.
WarrenBelz 76 Most Valuable Professional
Haque 69
Kalathiya 38 Super User 2026 Season 1
