Answered

Using Sum and GroupBy to retrieve the person with the most hours

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi.

I have a list of Employees and I'd like to retrieve which one has done the most hours. I want to Group the list by 'Prénom et nom', then calculate the sum of 'Heures' and to finish with I'd like to calculate the maximum using the Max functions. Then I can compare which employee is in the returned collection and know which one of them has done the most hours.

I know what I want and the steps to achieve it, but since I'm new to PowerApps I don't really know in what order I have to procede.

Thanks a lot ! Here's a screenshot of a part of my sharepoint list. And after, the type of collection I'd like to retrieve.

Name and surname	... other columns ...	Sum of the hours
Alexandre Sommer	...	The sum of his hours
Alec Pelletier-Dubuc	...	The sum of his hours

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

slerch 59 on at

Like
a
(1)

Report
Copy link

Link copied!
Whether you use a gallery or a ClearCollect statement, the items will look something like this
Sort( AddColumns( GroupBy( SpListName, "Name", // any number of columns can be used for your Group By "Hours" // this column is a table of hours ), "totalHours", Sum( Hours, Hours ) ), totalHours, Descending )
This will give you the sum of all the hours (after being grouped by your selected columns) and sort it with the most hours on top.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a lot ! unfortunately I can't try right now but as asson as I implement your solution I'll accept it (if it works but what I'm seeing seems correct so there shouldn't be any problem)