Answered

Help with an updated Sharepoint list.

(1) Share

Report

Posted on by DTutt

I have created a flow that pulls information from a sharepoint list. Basically a user creates a new equipment request on sharepoint. It goes to their manager for approval. If approved, it sends an email to IT which creates a ticket and requests a quote. IT then goes into Sharepoint and adds the qoute amount. This triggers Flow to send another approval email to the manager with the qoute added. However, it is not sending the updated information, it sends pre update information. For example, I create a request and leave the qoute blank. IT updates and adds a cost of say 100.00. The email leaves will leave the space for the qoute blank. If I put a value in the original request of 1, and then update with a cost of 100.00. The email for approval puts a 1 for cost instead of 100.00. Basically it is not pulling the updated price. Does anybody kow why? Does anyone know how to correct? The flow works perfectly from start to finish, just is not updating the cost.

Categories:

General topics

I have the same question (0)

All responses (17)

Answers (1)

v-yuazh-msft on at

Like (0)

Report

Hi @DTutt,

Could you please share a screenshot of the configuration of your flow?

What is the

I afraid that you choose a qoute dynaimc content of the original request in the approval action.

You could add a "get item" action before the approval action,and then choose the qoute dynaimc content of the original request in the approval action.

Please make sure youi have choose a qoute dynaimc content of the updated request in the approval action.

Best regards,

Alice

Was this reply helpful? Yes No
DTutt 28 on at

Like (0)

Report

Here is the flow....

Was this reply helpful? Yes No
DTutt 28 on at

Like (0)

Report

So I should add this....

and then I am not sure what you metioned after that.

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

I believe that you need to use a Get Item action (and remove the When an item is created or modified trigger) after your condition and retrieve the current values of the list columns. Your second approval is referencing values from when the item was created which is stale data. Change the reference in the second approval to values from the Get Item action.

To be honest, I am suprised that you can use a trigger inside of a Flow (other than to start the Flow of course) and suspect that this may be a bug.

Scott

Was this reply helpful? Yes No
DTutt 28 on at

Like (0)

Report

If I remove the When an item is created or modified, the fow will go all the way to the end before I even have a chance to update data on Sharepoint. As it is, it gets to that step and waits till an update is made. The flow works great except for not grabbing the updated value.

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

For your original post:
"Basically a user creates a new equipment request on sharepoint. It goes to their manager for approval. If approved, it sends an email to IT which creates a ticket and requests a quote. IT then goes into Sharepoint and adds the qoute amount. This triggers Flow to send another approval email to the manager with the qoute added."

The bottom line is that you need to retrieve the data in the Flow after it has been updated. There are a variety of ways of accomplishing this. For example, use a "Send email with Options" action to send the email to IT. The Flow will pause until IT responds to the email - they should not respond until they update the SharePoint list. Then the Flow can continue, use the Get Item action and start the second approval.

Scott

Was this reply helpful? Yes No
DTutt 28 on at

Like (0)

Report

Ok I added the following get item after adding a "send email with options" and it still returned a blank quote.

Did I do the "get item" incorrectly?

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

Could you post a screen shot of entire Flow? Don't know why you are in a loop - should not be.

Scott

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

Could you post a screen shot of entire Flow? Don't know why you are in a loop - should not be.

Scott

Was this reply helpful? Yes No
DTutt 28 on at

Like (0)

Report

Here it is. Let me know if you need to see inside of each step.

Was this reply helpful? Yes No