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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Update Column Calculat...
Power Automate
Unanswered

Update Column Calculated SUM based on ID

(0) ShareShare
ReportReport
Posted on by 230

I created flow with joined 2 SP List. Wheres it is SP List-1 is parrent and SP List is child.

Both of them is connected with lookup column is IDCategory. On SP List-2 it is  amount  transaction which will calculated with SUM on SP List-1.

However, SP List-1 have more than 2 ID, and on SP List-2, will be input by user every amount of transaction, where is on SP List-2 have column of IDCategory SP List-1 ( this column connect with lookup column).

But where i created flow , flow it works sucess but there is problem if SP List-2 is enter amount, is will be updated Calculated all column IDCategory on SP List-1 and not based on IDCategory is choosed on SP List-2.

 

Here is my picture hope this can explain better

SP List-1 (Parent), update all IDCategory, is not based on IDCategory is choose on SP List2

Lucas_Ignatius_0-1627364614792.png

 

SP List -2 (Child) connect with SP List-1 with Lookup Column IDCategory

Lucas_Ignatius_1-1627364741704.png

 

Flow

Lucas_Ignatius_4-1627363283740.png

and using update item for calculated SUM in SP List-1

Lucas_Ignatius_5-1627363494822.png

 

Please advice for better flow

 

Thank you every one

Categories:
I have the same question (0)
  • Lucas_Ignatius Profile Picture
    230 on at
    Re: Update Column Calculated SUM based on ID

    hi, can anyone help me ?

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard