Unanswered

Calculate remaining budget on Sharepoint Lists via Power Automate Flow

(0) Share

Report

Posted on by Community Power Pla...

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 😊

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sutherland on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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.

Was this reply helpful? Yes No