Announcements
I have a list in sharepoint an want to display sum of users workhouers pr. project for logedin user.
The table look like this:
When user1 start the app i want to display in a gallery, his workhouers.
like this
Any ideas?
@Langemyr
You can utilize the GroupBy function for this and then add a column to your resultant table with the sum.
Ex.
AddColumns( GroupBy( Filter(yourDataTable, user=loggedInUserName), "user", "_recs" ), "hourSum", Sum(_recs, hours) )
I hope this is helpful for you.
Fantasic 🙂
but i gruped by project 😉
now im going to sort witch projects i have worked on an how many houers each day 😉
Yes, sorry, I meant to group by Project and not user.
For the daily sums, you will need to employ the same grouping concept except you will group on the Date instead.
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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 226 Super User 2026 Season 2
WarrenBelz 191 Most Valuable Professional
Mohsin Ali 167