How do we automatically trigger logic app in azure when the new record will get inserted in sql serv-CodePudding

I have one pipeline in ADF which I need to run through logic app in azure, so I need such a solution which will trigger my logic app automatically when the new record get inserted into the table of sql server.

I need to trigger my logic app in azure when the new record get inserted in the table of sql server.

CodePudding user response：

Did you try the SQL Server trigger?

Now Pick When an item is created(V2)

Enter all the details like Server name, Database Name and Table name.

Add the next step to the logic app flow, select SQL Server and select Insert Row(V2) Action.

In the insert row step, add the SQL connection, enter database and destination table where data is inserted.

You test it by inserting a new record in SQL server table.

Reference - https://azsrini.com/2021/01/31/logic-apps-sql-connector-to-detect-record-insertion-and-trigger-workflow/