CODEWITHSUNDEEP
azureazure-sql-databaseazure-logic-apps
Zack Widdoss
Zack Widdoss

Reputation: 69

Azure Logic Apps - Issues with trigger being when Item is created in SQL

I use logic apps frequently, but always with a time based trigger. Trying to set one up that triggers when an item is added to a SQL table. Below are parameters - it just doesn't seem to be working. I am positive there are items being added to these query results at least every half hour, but it never seems to trigger. Any thoughts on what i might be doing wrong?

enter image description here

Upvotes: 0

Views: 3255

Answers (1)

Ecstasy
Ecstasy

Reputation: 1864

Thank you, Anonymous and v-alzhan-msft. Posting your suggestion as an answer to help community members.

When invoking triggers, we have the following limitations:

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

So, if you don't have an IDENTITY column, create one and it should work. That column will auto-increase by definition. CREATE TABLE (Transact-SQL) IDENTITY (Property)

You can refer to "When an item is created" trigger (SQL in Azure) not working and SQL connectors - Known issues and limitations

Upvotes: 1

Related Questions