cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Calculated SUM in SharePoint List Parent

I've case about calculated in SharePoint List-2(TransactionBudgetMasterCategory)  will be update and SUM on SharePoint List-1 (BudgetMasterCategory).

Which SharePoint List-2 had connected column in SharePoint List-1 with Column type Lookup (IDBudgetCategory).

Problem how calculated sum in SharePoint List-1 column name "Realisasi" where is Column will be SUM from column name "Amount" from SharePoint List-2 (TransactionBudgetMasterCategory).

I give my picture SharePoint List, I hope my description can easy to understanding.

 

SharePoint List-1 (BudgetMasterCategory)

Lucas_Ignatius_1-1627290235599.png

SharePoint List-2 (TransactionBudgetMasterCategory)

Lucas_Ignatius_2-1627290372915.png

 

2 ACCEPTED SOLUTIONS

Accepted Solutions

I was success with this flow for SUM Calculated column in SharePoint List (SP List)

 

My flow

Lucas_Ignatius_4-1627357852813.png

 

And this flow I break down for more detail

Lucas_Ignatius_5-1627357949621.png

Lucas_Ignatius_7-1627358136616.png

 

And flow will be sucessfull

Lucas_Ignatius_9-1627358428383.png

 

 

This is my SPList,

Lucas_Ignatius_8-1627358256269.png

I Hope this can help anybody with same problem with me

 

View solution in original post

CheckMate
Resolver I
Resolver I

add(variables('number2'),variables('number1'))
CheckMate_0-1627356526965.png

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution.
If you have found my response helpful, please give it a thumbs up.

View solution in original post

5 REPLIES 5
CheckMate
Resolver I
Resolver I

https://sharepoint.uservoice.com/forums/329214-sites-and-collaboration/suggestions/13981188-allow-lo...

 

workaround is to create a flow ...

1. when an item is created for List1

2. get item from list1

2. get item from list 2

3. update item in list2, id field enter the list where the item was created in(list1), and add sum amount field in list2(with fx)

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution.
If you have found my response helpful, please give it a thumbs up.

 

 

 

 

Hi @CheckMate ,

 

Can you help about fx formula to sum?

 

I was success with this flow for SUM Calculated column in SharePoint List (SP List)

 

My flow

Lucas_Ignatius_4-1627357852813.png

 

And this flow I break down for more detail

Lucas_Ignatius_5-1627357949621.png

Lucas_Ignatius_7-1627358136616.png

 

And flow will be sucessfull

Lucas_Ignatius_9-1627358428383.png

 

 

This is my SPList,

Lucas_Ignatius_8-1627358256269.png

I Hope this can help anybody with same problem with me

 

CheckMate
Resolver I
Resolver I

add(variables('number2'),variables('number1'))
CheckMate_0-1627356526965.png

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution.
If you have found my response helpful, please give it a thumbs up.

Hai @CheckMate ,

 

If there is have 2 ID, is can possible to update based on ID? Because i tried will be update all ID on SharePoint List-1

 

SP List-1 , have 2 IDCategory but update all IDCategory

Lucas_Ignatius_1-1627364528717.png

 

SP List-2 based on IDCategory

Lucas_Ignatius_0-1627364440119.png

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,907)