When a item is modified logic apps trigger does not works

asked 2020-08-25T17:17:51.56+00:00
Kumaresan P 1 Reputation point

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

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
1,803 questions
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2020-08-25T22:17:53.06+00:00
    ChaitanyaNaykodi-MSFT 9,866 Reputation points Microsoft Employee

    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.

    No comments