You’re offline. This is a read only version of the page.
60
Hello , i have a table with 2 columns. One with Email addresses called "Person" and one column with a total of minutes called "Minutes". How do i get a gallery with 2 columns. The first column with the distinct values of the email addresses. For the second column i need the calculated sum for all the "minutes" for that email addres.
Example :
bla@gmail.com | 5
bla@gmail.com | 5
gru@gmail.com | 20
Will result in :
bla@gmail.com | 10
gru@gmail.com | 20
referencing a SPList with that structure you can set a gallery items to
Share
Report
All responses (
Answers (
GroupBy(SharePointListName, "Person", "recordList")
In the gallery place two controls, one with the Text Value of
ThisItem.Title
and the other
Sum(ThisItem.recordList, Minutes)
