web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Calculations in SP lis...
Power Automate
Unanswered

Calculations in SP list from other SP list (sumif, averager...)

(0) ShareShare
ReportReport
Posted on by 2 Moderator

Hello,

 

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.

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard