Forum Discussion
SP Online Lookup SUM of Another List
I have two lists, Budget and Purchases.
In my Budget list I have the columns;
- budget
- actual
In my Purchases list I have the columns;
- amount
- status
- code
I would like to populate the Budget list with a value from Purchases. I would like this update to happen automatically whenever an item is added or modified in the Purchases list.
The values I would like is the 'SUM of amount where status = complete and code = 123'
How can I achieve this?
1 Reply
jonboylib This is not possible using out of the box capabilities of SharePoint.
You need customized solution for this, either using Power apps or power automate. You can run a power automate flow on item creation/update in Purchases list which will get the list items using "Get list items" action (you can apply Status equal to Complete & code equal to 123 filter in action).
Then you can get the sum of amount using expressions in power automate flow using which you can add/update the item in Budget list (using Create item or Update item actions in flow).
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
