Unanswered

Subtraction operation

(0) Share

Report

Posted on by Community Power Pla...

Hello community,
I anew to power automate and i am building the leave management system where end user can apply for the leaves every thing is working in good manner but i am struggling in deducting the amount of days leave taken from the leave balance which is in excel. any help i am stuck very badly not able to figure out the way.

Thank in Advance

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Naveen_772 208 on at

Like (0)

Report

Can you tell us more about the part where you're stuck? Or some screenshot of the flow for better context.
Is it related to getting data from the excel file or performing the subtraction operation in Power Automate?
Also if there is any execution of the flow, then please drop the error message.

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

Like (0)

Report

Thanks for spontaneous reply @Naveen_772 ,
I have created the table in my online excel with name email id and annual leave balance (default value =15).now i have created the approval flow for the leave and i need to subtract the amount of days leave taken from the balance.
how can i achive that . i have attached the screenshot of the flow for the reference.

Thanks in advance

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

Like (0)

Report

Hello @Naveen_772 ,
Any solution ? i am stuck very badly need help from experts like you .
Thanks

Was this reply helpful? Yes No
Naveen_772 208 on at

Like (0)

Report

@Anonymous

First : You need to get the number of days a person is going to take a leave. Also you need to make sure that you're excluding the weekends days.

Second: Once we have the number of days you can subtract it from the leave balance entry.

I am attaching a flow that you can import into your environment. You can use this as a reference. I have attached notes at the appropriate steps. I hope this helps.

Adding some screenshot too.

Link for flow :https://drive.google.com/file/d/1rZlXhDI39WCfnFH1ECww5kiYWxlaif9O/view?usp=sharing

Please Accept this as a solution if I am able to solve your issue. Give a thumbs up if it helps you a little bit.

Was this reply helpful? Yes No
Naveen_772 208 on at

Like (0)

Report

@Anonymous Any Luck?

Was this reply helpful? Yes No