
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
SP List -2 (Child) connect with SP List-1 with Lookup Column IDCategory
Flow
and using update item for calculated SUM in SP List-1
Please advice for better flow
Thank you every one