Power Platform Community Forum Thread Details

Calculate Remaining Budget SharePoint Lists + Power Automate

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