Answered

Updating a calculated value based on aooroval

(0) Share

Report

Posted on by UB400

356 Microsoft Employee

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.

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @UB400,

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

Thanks

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

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

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

Can you please post your update flow?

Thanks

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

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

UB400 356 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No