When a item is modified logic apps trigger does not works

Question

i have created a logic app with trigger when an item is modified in SQL server on premise (installed gateways are connected when an item is created it is working fine) but using trigger when an item is modified not triggering the logic apps

Answer 1

Hello @Kumaresan P , Can you confirm if you have a ROWVERSION column in your SQL table? as it is required as per the Known issues and limitations for SQL server connector. The SQL connector uses the rowversion column of a row to easily determine whether an update statement has been run against the row since the last time it was read.

Answer 2

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.