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

 

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 Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (4,768)