cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lucas_Ignatius
Helper V
Helper V

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
Lucas_Ignatius
Helper V
Helper V

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?

 

Lucas_Ignatius
Helper V
Helper V

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

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,391)