Sum of points according to logged User

[Miguel36]

Hello,

I want to update the following gallery:

To show the sum of the points stored in the Sharepoint Timesheet:

However, I also want to filter it by Logged User (which is also already stored in the same timesheet table)

What is the best way of doing this?

Thank you!

[PowerRanger]

@Miguel36

So you want your gallery to show one line per User and have its points summed up? 

[PowerRanger]

@Miguel36 

Is this what you are looking for?

Use this for the Iems property of the gallery

GroupBy(Filter('Item Details','User Email'= User().Email),"User Email","groupedcolumns")

Use this for a label inside the gallery

Sum(ThisItem.groupedcolumns,'Item Points')

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Miguel36]

Let me try to explain it in more depth:

There are 2 Sharepoint Timesheets were the data from the gallery must come.

The first timesheet: "User Details" ---> used to save a one time record of each user that has already used the app by adding a record.

The second timesheet: "Item Detalils" ---> used to save all the records made by each user. It has a column named "User Email" in order to distinguish a record from User A from a record from User B.

So, this Gallery should get the name and mail from the "User Details" timesheet, and the sum of the points from the "Item Details" timesheet, which has a column named "Item Points". This column records the points for each individual record (not the sum for each user, but the record points).

I want the gallery to have all the users (scoreboard), and the sum of the items points for each individual user.

The gallery should show for example:

John, 63 points

Anna, 20 points

If I insert the Gallery Property has 'User Details' the names are already good, by using ThisItem.'User Name' in the text property of the name label in the gallery. Now I need the Text property for the label that will show the sum of the points for each user.

Using the function you gave before for the Gallery Items Property, will disable the Users Names from the 'User Details' Timesheet.

Thank you for all the help to this point, highly appreciated!