Share
Report
2Hello,
I have
a list of 10 projects that are being evaluated. (list name "Projects")
a list of 8 evaluators who evaluate each project (list name "evaluators")
a list of 80 evaluations, one item for each project and evaluator (list name "evaluations") I populate the third list via Power Automate from the first 2.
My evaluators use a Power App to fill in the evaluations in the third list.
I want to show the sum (and the average) of the points that each project has got (which are listed in "evaluations" in a column for the list "Projects"
In Excel that would be easily doable with sumif referencing the Title of the current item in the table "Projects" , the Title column in the table "Evaluations", returning the sum of the column "Points"
I have played around with calulated columns and lookup columns, both for the list and for the site, but I could only make calculations within one column or reference columns in a different list without any calculations.
The only thing I could come up with now is to have a flow do this whenever a row is changed, create a variable, filter the list for the data and for each item add the value of the field of that line to the variable. If that's the way to go, I'm unsure of how to go about this as the Get Row action requires me to have the ID.
I really hope there is a very simple way that I am missing. Being able to do Excel-like data operations in SharePoint lists would help me out quite a bit.
All responses (
Answers (
