cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Langemyr
Helper II
Helper II

Sum work houers

I have a list in sharepoint an want to display sum of users workhouers pr. project for logedin user.

The table look like this:

timer.PNG

When user1 start the app i want to display in a gallery, his workhouers.

like this

Gallery.PNG

Any ideas?

 

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User
Super User

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

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

4 REPLIES 4
RandyHayes
Super User
Super User

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

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

Langemyr
Helper II
Helper II

Fantasic 🙂

but i gruped by project 😉

now im going to sort witch projects i have worked on an how many houers each day 😉

weekdays.PNG

@Langemyr 

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.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,527)