SQL Insert or Update does not trigger Logic Apps

1 min read

Summary

There is a known limitation with the SQL trigger connector in Azure Logic Apps where a table must contain two additional columns:

  • A ROWVERSION column is required for OnUpdatedItems
  • An IDENTITY column is required for OnNewItems

Without these columns Logic Apps will not trigger on a SQL record Update or Create.

ROWVERSION

ALTER TABLE [dbo].[Persons]
ADD LastChange ROWVERSION

IDENTITY

ALTER TABLE [dbo].[Persons]

ADD ID INT IDENTITY(1,1) NOT NULL

You must be logged in to post a comment.