Power Platform Community Forum Thread Details

Update Column Calculated SUM based on ID

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