Calculate remaining budget on Sharepoint Lists via Power Automate Flow

[Anonymous]

Hello everyone,

I have a flow which is;

It's created for approving expense request & changing its status. However, I also need to calculate remaining budget and see it right after approve every request. If I reject it, it should be the same amount. I couldn't figure out what kind of a new step solve my problem. May you help me?

Thank you 😊

[Johnnyg]

Hello BAT,

I read your description, but I reckon the follow-up action should be carried out according to your business logic. Since your trigger is 'when an item is created' in Sharepoint, after the budget item is approved, we usually use a hardcode total budget value minus the approve budget value and then store it in the sharepoint item field .

But these processes are different for different business needs, mainly depends on how you need to calculate the total budget and each budget item

[Anonymous]

Hello @Johnnyg ,

Actually, all I need is "we usually use a hardcode total budget value minus the approve budget value and then store it in the Sharepoint item field ." providing it. I want the payment that I approve to be taken out of the budget always. First time, I opened ticket in SharePoint community but they conducted me to Power Automate community. If you share your hardcode or settings in SharePoint to calculate remaining budget after every payments, I would be grateful.

Thank you for your interest,

Sincerely.