Answered

SQL server connection issue

(0) Share

Report

Posted on by Community Power Pla...

I have set up a Flow to trigger when an item is added to a SQL table (azure db).

The flow correctly picked up the columns to populate the dynamic content, so connectivity is good. However the flow does not run when I insert data into the table. It hasn't run at all, so I don't have any error logs to look at. Any suggestions?

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yamao-msft on at

Like (1)

Report

Hi BenWattProdata,

When using triggers in the SQL connector, there are following limitations:
1.It does not work for on-premises SQL Server
2.Table must have an IDENTITY column for the new row trigger
3.Table must have a ROWVERSION (a.k.a. TIMESTAMP) column for the modified row trigger

While you can kick off your Flow or Logic Apps whenever a row is inserted or modified in a SQL Azure Database table.

Please make sure you are not using on-premise SQL Server, and the table do have the two required columns.

Please check more details in this blog:
https://flow.microsoft.com/en-us/blog/introducing-triggers-in-the-sql-connector/

Best regards,
Mabel Mao

Was this reply helpful? Yes No
moutinhoabreu 170 on at

Like (0)

Report

On premises now is working if the table appears on trigger selection.
I believe those which appear are the ones with identity column

Was this reply helpful? Yes No