SQL server connection issue

[Anonymous]

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?

[v-yamao-msft · Accepted solution]

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

[moutinhoabreu]

On premises now is working if the table appears on trigger selection.

I believe those which appear are the ones with identity column