SQL Trigger Issue - 'Update Row (V2)' is not triggering 'When an item is modified (V2)'

[RyanW7]

I have 2 Microsoft Flows built:

One that triggers off 'When an item is created (V2)' and then conditionally updates that SQL row

One that triggers off 'When an item is modified (V2)' and then processes

The first flow will run, detect the new SQL entry, process, and terminate

The second flow will never run, even though I am modifying SQL entries in the first flow

Does 'Update Row (V2)' not exhibit the same behavior that 'When an item is modified (V2)' is looking for?

Is this a timing issue, if so any suggestions to resolve?

[v-litu-msft · Accepted solution]

Hi @RyanW7,

You could try to create a Timestamp column in SQL then try to use the trigger again.

For more about this trigger, you can refer to this document:

https://docs.microsoft.com/en-us/connectors/sql/#when-an-item-is-modified-(v2)

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

[PU1]

I'm having exactly the same issues.  Did this get resolved?  Is it a bug?

[PU1]

You need to create a timestamp field in your source table.  Sounds strange but works.  See the link below
https://powerusers.microsoft.com/t5/Webinars-and-Video-Gallery/Using-the-When-an-Item-is-modified-tr...