When an item si modified updates the item immediately.

[Piettro13]

Hi,

trying to build a simple flow (Update Status) for Microsoft Lists where I want my status to change from "New" to "In Progress" when a user changes anything in the item.

I use "When an item or file is modified" (Sharepoint).

The problem is I also use "Update item" and "Send an HTTP request to SharePoint" actions for the same item when creating it because I generate unique Case ID, create folder and send link back to MS Lists. 

I guess it is enough for the "When an item or file is modified" trigger to think that the item was actually modified and changes the status to "In Progress".

What I need for the "When an item or file is modified" is to start watching for changes only after the first round of updates. 

Something like a condition "Modified" is grater than "Created" + 2min would do it. But I cant figure out how to add time to the dynamic content (Created)

Thanks 

Piettro

[annajhaveri]

@Piettro13  so you dont want the flow to trigger when the flow itself updates the item?

[Piettro13]

Hello Anna,

yes, correct. I dont want the second flow to trigger when the first flow updates the item.

I have two flows. The first flow generates unique ID and updates the item with this new ID. Then I have this second flow that is supposed to update the status. But I want the satus to be updated only after someone (me or another user) changes something manually in the Lists.

thanks.

[annajhaveri · Accepted solution]

@Piettro13  if you use a service account for your flow connection, then you can add trigger condition as below to prevent the flow run when service account updates the list item

@not(equals(triggerOutputs()?['body/Editor/Email'],'accountname@domain.com'))

If order to check changes are made to specific column in list you can add Get Changes action, using it you can check if specific column value has changed or not.

[Piettro13]

So the „Get Changes“ action seem to be the solution for me.

First I check with the condition that CaseID was modified. That is the automated action triggered when the item is created. If the condition is true, then I dont want anything to happen.

If there is any other change for the item it checks whether the „O/C“ value is New, if yes, it updates the field to „In progress“, if not, it does nothing…

So far all the test worked. Thank you Anna.