SQL Insert or Update does not trigger Logic Apps

Post by: syed hussain in All Azure Logic Apps Tips

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
Tags:
13 Sep 2020
0