cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RyanW7
Advocate II
Advocate II

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
v-litu-msft
Community Support
Community Support

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.

View solution in original post

3 REPLIES 3
v-litu-msft
Community Support
Community Support

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.

View solution in original post

PU1
New Member

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

PU1
New Member

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,118)