Help with an updated Sharepoint list.

[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.

[v-yuazh-msft]

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

[DTutt]

Here is the flow....

[DTutt]

So I should add this....

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

[ScottShearer]

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

[DTutt]

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.

[ScottShearer]

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

[DTutt]

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?

[ScottShearer]

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

Scott

[ScottShearer]

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

Scott

[DTutt]

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

[ScottShearer]

@DTutt- One thing that should be changed that I can see is that you are using Get Items VS Get item - that's why you have the loop.

I have created and successfully tested a Flow that you can use an an example.  The Flow starts when a new item is created.  When approved, an email is sent using the Send Email With Options action.  I have only one Option - OK.  The email tells IT to click on OK when they have updated the SharePoint list.  The Flow pauses until IT clicks on OK.

Then, I use Get Item to retrieve the updated data and start the second approval.  The second approval references data returned from Get Item.

  

 

  

If this solves your issue, please mark you post as Solved.

Scott

[DTutt]

Still getting a blank total. I must be doing something wrong. When I do a "get item" here is what I am entering.

I was able to successfully add the option to cause the run to pause till hitting OK. It is still pulling old data and not the updated. Obviously I am doing something wromng wrong. How do you tell the thing to grab the updated data instead of the old. Below is what I am entering for the second email that should have the updated total.

Thaank you by the way, I really appreciate your help.

[ScottShearer]

I assume that the Get Item action is placed after the send email with options - correct?

Can you verify where the data is coming for your second approval - did you change the column references to get the data from Get Item in Dynamic properties?

Have you looked at the run history?  Does it generate any errors?  Does it provide any clues?

Scott

[DTutt]

Yes, the get item is placed after the send email with options. Where do I verify where the data comes from? Forgive my ignorance.

"did you change the column references to get the data from Get Item in Dynamic properties?"

Not sure what this refers to. Again, forgive my ignorance.

Run history says run successful. In looking at the output for Get Item, it shows the updated quote

Outputs

Body

{
  "@odata.etag": "\"2\"",
  "ItemInternalId": "19",
  "ID": 19,
  "Title": "Test",
  "Employee_x0020_Name": "Donald Tutt",
  "Job_x0020_Title": "IT",
  "Location": "Nashville",
  "Equipment_x0020_Requested": "laptop",
  "Quantity": 1,
  "Why_x0020_do_x0020_you_x0020_nee": "test",
  "Cost_x0020_Center": {
    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
    "Id": 13,
    "Value": "114 Tennessee"
  },
  "Cost_x0020_Center#Id": 13,
  "Quote": 199.99,
  "Modified": "2018-07-19T16:15:04Z",
  "Created": "2018-07-19T16:12:22Z",
  "Author": {
    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
    "Claims": "i:0#.f|membership|donald.tutt@tenn.com",
    "DisplayName": "Donald Tutt",
    "Email": "donald.tutt@cgtenn.com",
    "Picture": "https://cgidd.sharepoint.com/teams/Caregiver IT/_layouts/15/UserPhoto.aspx?Size=L&AccountName=donald.tutt@tenn.com",
    "Department": null,
    "JobTitle": null
  },
  "Author#Claims": "i:0#.f|membership|donald.tutt@tenn.com",
  "Editor": {
    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
    "Claims": "i:0#.f|membership|donald.tutt@tenn.com",
    "DisplayName": "Donald Tutt",
    "Email": "donald.tutt@tenn.com",
    "Picture": "https://cgidd.sharepoint.com/teams/Caregiver IT/_layouts/15/UserPhoto.aspx?Size=L&AccountName=donald.tutt@tenn.com",
    "Department": null,
    "JobTitle": null
  },
  "Editor#Claims": "i:0#.f|membership|donald.tutt@tenn.com",
  "{Identifier}": "Lists%252fEquipment%2bRequest%2bForm%252f19_.000",
  "{Link}": "https://cgidd.sharepoint.com/teams/Caregiver%20IT/_layouts/15/listform.aspx?PageType=4&ListId=b63b3781-0aae-4384-b1be-e35a6575b180&ID=19&ContentTypeID=0x0100BE1F34A0DADDE04EA7C8943D58528FE5",
  "{Name}": "Test",
  "{FilenameWithExtension}": "Test",
  "{Path}": "Lists/Equipment Request Form/",
  "{HasAttachments}": false
}

And the output for the email that should have the qoute

Outputs

Body

{
  "response": "Approve",
  "responseSummary": "Approver: Donald Tutt, donald.tutt@tenn.com\r\nResponse: Approved\r\nRequest Date: Thursday, July 19, 2018 4:16:17 PM\r\nResponse Date: Thursday, July 19, 2018 4:18:55 PM",
  "title": "Quote for new equipment for Donald Tutt",
  "details": "Donald Tutt is requesting laptop and the estimated cost is  ",
  "responses": [
    {
      "responder": {
        "id": "6c1a7cbd-3f47-4bb4-ad0e-b3607e20092b",
        "displayName": "Donald Tutt",
        "email": "donald.tutt@tenn.com",
        "tenantId": "2f743003-3661-48d2-a92a-76064d529ef8",
        "userPrincipalName": "donald.tutt@tenn.com"
      },
      "requestDate": "2018-07-19T16:16:17.445197Z",
      "responseDate": "2018-07-19T16:18:55.0495538Z",
      "approverResponse": "Approve"
    }
  ]
}

Response

Approve

Response summary

Approver: Donald Tutt, donald.tutt@tenn.com Response: Approved Request Date: Thursday, July 19, 2018 4:16:17 PM Response Date: Thursday, July 19, 2018 4:18:55 PM

Title

Quote for new equipment for Donald Tutt

Details

Donald Tutt is requesting laptop and the estimated cost is

Responses

[
  {
    "responder": {
      "id": "6c1a7cbd-3f47-4bb4-ad0e-b3607e20092b",
      "displayName": "Donald Tutt",
      "email": "donald.tutt@tenn.com",
      "tenantId": "2f743003-3661-48d2-a92a-76064d529ef8",
      "userPrincipalName": "donald.tutt@tenn.com"
    },
    "requestDate": "2018-07-19T16:16:17.445197Z",
    "responseDate": "2018-07-19T16:18:55.0495538Z",
    "approverResponse": "Approve"
  }

[ScottShearer · Accepted solution]

So in your seond approval, I want to know where your point to when you grad the values to display in the approval.  You need to select them from the Get Item Dynamic properties.  I suspect you are grabbing the stale values from the "When an item, is created" Dynamic properties.

See screen shot:

[DTutt]

Scott you are correct. I was just thinking that during my last response. I do not have the "get item" listed. That is why I am pulling from the "when an item is created" list. How do i get that "get item " list to show?

[DTutt]

I went in and created a new one from scratch and was able to select "get items" from dynamic library. Lesson learned, if you go back and delete a step and enter a new one, it does not update the dynamic library.

Thank you so much for your assistance.