cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alicito
Level: Powered On

Using Flow to create Petty cash, ist possible ? two number calculation

Hi there, 

 

We are moving from G-suit and we have used sheets for our purchase order, petty cash and cash payment forms.

I have worked a way to use PO and its working fine.

 

The issue creating Petty cash is I can't do any manual edit on Excel /or when I do the order numbers changes. (using forms to fill excel)

 

Steps: 

Assuming in petty cash there is $1000

1-Using forms

2-When a person want to get some cash out of Petty cash will submit a form with money out 100

3- Flow will update the SharePoint list column with $100 under column money out 

how do I get the calculation to deduct the total of 1000 -100 and or if the person adding 100

Petty cash, Adding flow

 

Now how to calculate 

2 REPLIES 2
Highlighted
Power Automate Staff Audrie-MSFT
Power Automate Staff

Re: Using Flow to create Petty cash, ist possible ? two number calculation

Your business scenario definitely seems doable. Without having a lot of detail on your implementation, it looks like you need help with calculations using Flow. So here are a few articles to help you.

https://powerusers.microsoft.com/t5/General-Flow-Discussion/Math-Functions-microsoft-flow/td-p/18725...

https://flow.microsoft.com/blog/calculate-running-totals-and-tracking-maximum-values-in-flow/ 

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference 

 

If you need additional help, please also share a screenshot, and maybe repro steps, showing us what you are doing so we can target the answer to the part of the solution where you need help.

 

Thank you,

Audrie

 

P.S. If the hyperlinks in this post helped you with your calculations, please mark it as a solution so others will benefit as well.

Alicito
Level: Powered On

Re: Using Flow to create Petty cash, ist possible ? two number calculation

Thanks for your input the two links are not working, I want to use Form with user input of money in and money out, then transfer them to the list, the issue is can work the calculation to be at the same time the user add the information. 

 

this is how we are using it with G-suit ( Excel and forms) 

 

This is for Cash payment

1-An Amount is being added to branch by Manager (only once)  Ex: $1000

2- There is Funds in ,Funds out  and Balance

3-If funds in added by staff it should be calculated as + in the total for Ex staff added $100 total will be $1100

4-Fund out added by staff is $50 it should be - the total which will be $1050

 

The formula I used before in excel sheet :

=if(A2="", "",I2+E3-F3) If cell A2 is empty I2(Total) +E3 (Funds in) - F3 (Funds out ) 

Manually added F2=$1000

 

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,419)