SQL Insert or Update does not trigger Logic Apps
1 min read
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.
ALTER TABLE [dbo].[Persons] ADD LastChange ROWVERSION
ALTER TABLE [dbo].[Persons] ADD ID INT IDENTITY(1,1) NOT NULL