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 / Update Sharepoint list...
Power Automate
Answered

Update Sharepoint list column based on sum of another sharepoint list

(0) ShareShare
ReportReport
Posted on by 754

I have a SharePoint list that has projects and project totals PROJTOT

ctedesco3307_0-1661617253483.png

 

I have another SharePoint list that has roles and hours for those projects PROJDETAIL

 

ctedesco3307_1-1661617253488.png

 

When the users add rows to the SharePoint list PROJDETAIL I want to trigger a power automate flow to update the contract total

In PROJTOTS to sum all the Role_Totals for that project in PROJDETAIL

 

MasterProjID field in PROJDETAIL  is a lookup to the ID in PROJTOT –

 

I see lot of similar posts on this, and I've tried them but none working. thx in advance 

Categories:
I have the same question (0)
  • Verified answer
    David- Profile Picture
    1,254 on at

    I am doing something similar to generate a weekly report of purchase requests submitted, which includes the total amount.

    1. In your Get items action, use a filter query to filter it by your project id field.
    2. Initialize a variable of Float type with whatever name you want to give it.
    3. Add an Apply to each action and set the data to the value of your get items.
    4. In the apply to each add an Increment variable action with the value from the role total (at least I think that is the field you want to total).

    That will generate your total.

    David_0-1661623222069.png

     

  • ctedesco3307 Profile Picture
    754 on at

    @David-  Hi David - thanks for the reply.  Worked like a charm!!! Much appreciated!! 

  • ctedesco3307 Profile Picture
    754 on at

    @David- one quick question - I updated the flow to work with a different calculated column in my list, Role Amt. - the column is set to currency data type - same as the Role Total. but when I switch to Role Amt I get this error : I switch back to Role total, which is also set as currency, it works fine. Any workarounds for this? Variable is still set to float.   thx 

    ctedesco3307_0-1661789036411.png

    ctedesco3307_1-1661789090220.pngctedesco3307_2-1661789125290.png

     

  • David- Profile Picture
    1,254 on at

    Unfortunately I have not encountered this problem because I do not use the currency type in SharePoint lists for my solutions. I work for a large multinational, so we deal in various currencies, so everything uses the number type. In my forms such as for purchase requests there is a drop-down to choose the currency type. I suspect you will need use an expression in the Increment variable action to convert the currency value in your SharePoint list to a float value. I looked in the forums and found people asking the same question, but I have not found one with a solution.

  • ctedesco3307 Profile Picture
    754 on at

    @David- - Thanks for the response. I actually figured out a solution - I did a workaround populating the text column with an update action then running this against the text column. I think the problem was that the column I ended up changing to was a calculated column, more then a currency.  Fun fact .. I also tried to change the datatype in the increment variable to float - which got me past the error - but instead of summing the unique roleAmt column values for each row  that had that ID, it applied the same RowAmt value of the row I was adding and posting that to the totals list. So short story - the error went away but the calculations were wrong. If I tinkered it for a bit more I prob could have gotten it to work.... but  I moved on with the workaround. 🙂 

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
Haque Profile Picture

Haque 308

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 226 Most Valuable Professional

Last 30 days Overall leaderboard