Logic Apps SQL Trigger 'When Item is Modified' not running

Chris Lupton 1

I have 2 Stateful Logic App workflows looking at the same table.

One triggers on 'When an item is Created (v2)' and works fine when an insert creates a new record in that table.

The other should trigger on 'When an item is modified (v2)', but when I run an update on any of the existing rows in the target table, nothing happens.

As indicated, Item Creation triggers works, so I'm not sure what could be causing the Item Modified trigger to not pick up?

Thanks

Nitish Sharma 441 Reputation points

2025-01-07T15:21:01.6966667+00:00
Hi @Chris Lupton ,

Did you create your logic app using a template? If yes it might be using an old trigger, I have created a fresh logicapp and it seems to be working fine. You can try out below 2 things if that helps -

Refresh the connections in your logicapp and re-save the logicapp without making any changes to it.

Create a fresh version of logicapp to see if that works.

Also look at your logicapp trigger history if there is any error there or not.
Chris Lupton 1 Reputation point

2025-01-08T09:39:17.65+00:00

Hi Nitish,

It wasn't created from a template; clean workflow with the 'When an item is modified (V2)' trigger selected.

I've refreshed the connections and tried again, and no joy.

The trigger history doesn't show any errors, only where it's skipped (it thinks it needs to skip on every pass, but I know that I've run an update on the SQL record)
Nitish Sharma 441 Reputation points

2025-01-08T19:41:46.7166667+00:00

@Chris Lupton Do you have change tracking enabled on the database and table?

Also, please can you confirm the below things:

What SQL version are you using?

After making an update in your table, please can you SQL query first on the database directly to see whether you are able to detect changes.

Is ROWVERSION column defined as it is required?

Please have a look at known issues and limitations with triggers at the below link:

https://learn.microsoft.com/en-us/connectors/sql/#known-issues-and-limitations
Nitish Sharma 441 Reputation points

2025-01-08T19:46:47.9333333+00:00

@Chris Lupton Please can you share some more details for the below points:

Which SQL version are you using?

Have you enabled change tracking on your database and also the SQL table?

Please run your query on your database first after making changes to ensure that those updates are being captured.

Does your table have a primary key?

Is ROWVERSION column defined as its required?

Please go through known issues and limitations with the connector too:

https://learn.microsoft.com/en-us/connectors/sql/#known-issues-and-limitations

1 answer

Maksym Abramchenko 5 Reputation points

2025-01-10T08:08:00.7166667+00:00

Table must have an IDENTITY column for the When an item is created trigger (V2)

Table must have a ROWVERSION (a.k.a. TIMESTAMP) column for the When an item is modified trigger (V2).

Try to create a new table with these added columns and recreate the API connection again in your logic app and verify if you are able to see the tables in the dropdown.
Please sign in to rate this answer.

1 person found this answer helpful.
Chris Lupton 1 Reputation point

2025-01-14T08:27:13.9866667+00:00

@Maksym Abramchenko - thankyou! That was it, I was missing a rowversion table in the column. Having now added that, it triggers accordingly.

Many thanks.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Logic Apps SQL Trigger 'When Item is Modified' not running

1 answer

Your answer