web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Calculate Remaining Bu...
Power Automate
Unanswered

Calculate Remaining Budget SharePoint Lists + Power Automate

(0) ShareShare
ReportReport
Posted on by

Hello, 

 

I would like to calculate columns in one SharePoint list based on the entries in another SharePoint list. I have two lists created, one contains expense details, let's call this "Budget 1", the other holds the various supplier budgets, "Budget 2". The column we want to map to in both lists is the "Supplier" column. I know SharePoint is non-relational, so I'm hoping Power Automate can help me update columns in Budget 2 based on the entries in Budget 1. Just an FYI there is no approval process in this workflow, it's simply when an item coded to a certain supplier is created using the "Spend" columns, that being said, the spend may be updated when accounting processes the invoice at a later time, so I would like the flow to run in all instances of changes after the item in created as well. Please let me know if you need any other information to help with this request, thanks in advance for the help. 

SharePoint Budget 1.JPG

SharePoint Budget 2.JPG

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard