how to check if item is edited or new item

[muralikrishna00]

Hi friends,

we have a requirement on sharepoint list.

we need to write a flow for above requirement.

1. When user add an item flow has to trigger an email for approval.

2. In between approvals, if user edit the item flow has to terminate no more action required from approvals

I have completed some part till send aprovals emails,

but dont know how to check if item is edited/modified then terminate flow instance.

kindly help me

Thanks,

Murali 

[Pstork1]

There really isn't a way to check whether something has been re-edited while the Flow is running. You can check if an item that triggered a Flow is new or edited by comparing the Created and Modified dates.  If they are the same then its new, otherwise its edited. But that would be in a different Flow and there would be no way to cancel an existing Approval in a different Flow from that Flow.

[muralikrishna00]

First of all Really thanks for your reply,

"You can check if an item that triggered a Flow is new or edited by comparing the Created and Modified dates.  If they are the same then its new, otherwise its edited"

Ok it seems really good idea.

But 

after comparison can i stop current item instance ..?

Example 

New item is added 

Approver 1 is approved 

Approver 2 is approved 

Approver 3 is Pending(Not yet)

In this case can we terminate/stop/cancel the item flow instace ...?

means when approver 3 is couple of days back to approve (opned link) by any chance can we get error or no task list to approve since he modified.

kindly reply with your idea here if possible just give me a flow(attach that flow image) that make sence to me follow.

Thanks,

Murali krishna.

[yashag2255 · Accepted solution]

Hi @muralikrishna00 

Currently there is no direct way of cancelling a flow like that. You can use the terminate action but then depends on the scenario that you are trying to build. For example: Trigger: When an item is created-> flow is running. Maybe in between you can add a delay and use the get item action to get this item and check the modified vs created date and then use the terminate action to kill the flow. makes sense? 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[v-alzhan-msft · Accepted solution]

Hi @muralikrishna00 ,

As @yashag2255 said, there is no any way to close a flow when it has run.

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pstork1]

YOu can set a timeout on the Approvers and take action after that timeout fires.  But as I said, there is no way within that Flow running the approval to know that the document has been modified. When a trigger fires, yes you can compare the dates and terminate the Flow if its not a new document. But this would be in a different Flow than the original one sending out the Approvals. So I don't think that will be of any use to you.

[MikeInCairns]

You CANNOT compare Created date and modified date if your new item has attachments.  Adding attachment to a new item seems to create a delay such that created DOES NOT EQUAL modified.  Furthermore you cannot test if item is new by testing the version.  A new item with 2 attachments will automatically start as version 3.

[ahohman]

Just learned this one the hard way!  Sheesh.  Could not figure out why created did not match modified on new item until I saw this comment.  Thanks!