Trigger Azure logic app when row is inserted

0
votes

I have created Azure logic app. It's aim is to send an email and SMS each time when record is inserted to a table in Azure SQL database. I can see that many records are inserted into this table (I use Azure functions to populate it). Could you let me know what I have done wrong?

enter image description here

1
azureazure-logic-apps
Could you please click on Overview -> Runs history and give us a screenshot of the execution result of the logic app? Something like this. This helps us reproduce your problem. - Frank Gong
From the runs history, I want to confirm weather the trigger is not triggered at all. - Frank Gong

1 Answers

0
votes

Make sure that your temperature_events table contains an identity column as required by the SQL Connector

  1. When invoking triggers, we have the following limitations:
    • A ROWVERSION column is required for OnUpdatedItems
    • An IDENTITY column is required for OnNewItems