When a item is modified logic apps trigger does not works

Kumaresan P 6 Reputation points
2020-08-25T17:17:51.56+00:00

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.
3,197 questions
{count} vote

1 answer

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

    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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.