Updating a calculated value based on aooroval

[UB400]

Using the example of the vacation approval demos of MS Flow. Would it be possible to update the value of columns such as "days of vacation remaining" and "number of days taken" columns in a Sharepoint list?

In other words if a User asks for a 5 day vacation and had a balance of 10 days available, once the vacation gets approved, how can we update the respective Sharepoint columns with the new leave balance and days used columns?

I would want to start from PoweApps to create the vacation request and then use Flow to send the approval e-mails. How do I then update the respective columns in Sharepoint?

My apologies for repeating the question several times in this post, I'm just trying to make it clear.

Thanks.

[abm]

Hi @UB400,

Please see this https://powerusers.microsoft.com/t5/Flow-Forum/Add-total-to-existing-field/m-p/14591#M3405

Thanks

[abm]

Some more http://www.o365dude.com/2016/05/07/making-a-vacation-request-flow-with-microsoft-flow-preview/

[Anonymous]

I am trying to do the same things and I am not able to figure this out.  I was able to calculate the number of days requested but I am not able to update the remaining days.  I don't find any information in the forum either.  

[abm]

Hi @Anonymous,

Can you please post your update flow?

Thanks

[Anonymous]

The number of request days is not a flow. It is a calculated column.  The flow is just a standard approval flow.  I am trying to use the number of day in the calculated column to create a flow for the remaining day.

[UB400 · Accepted solution]

In the end I went a different route. I used a button in PowerApps to trigger the flow, so rather than creating the record and then seeking approval, you can do it in a more logical manner i.e. User hits the button, which in turn triggers the Flow, passing the exact values you want it to update the record with.

See this article in PowerApps site https://powerapps.microsoft.com/en-us/tutorials/using-logic-flows/

You can pass multiple values simply by separating them with commas. I assigned all values to TextBoxes and then passed on the values to the flow via the TextBoxes. I haven't tested it with ContextVariables nor Collections but I can't see any reason why it would not work. Below is what the resulting formula looks like for the button that triggers the Flow.

PowerAppsbuttonleaverequest.Run(TextBox9.Text,TextBox18.Text,TextBox15.Text,TextBox18.Text,TextBox14.Text)

So my issue has now been resolved using the method I've stated here. I'm happy to answer any questions you may have. I even tested to make sure that if the User closes the app while the approval is pending , Flow takes care of it once the approval is given.