SQL triggers

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I am trying to create my first ever MS Flow, I want to achieve a simple task to send an email when a new record is inserted in a SQL table. But the trigger is not working.

I have read on blogs before posting this question that there are some limitations to it. One is that trigger doesn't work on On-Premise SQL server (standard 2016). Is this true? Whats the point of installing On-Premise Data Exchange Gateway then?? Its able to connect to my DB. It is able to access all tables and fields in the DB, its just that its not able to detect an event of new record being inserted. The flow even triggers when I do a Test and select "Use SQL Data" it works. But not when a record is inserted in the table. The Identity column and timestamp column are present on the table.

Any alternate solution or workaround are welcome!

All responses (1)

Answers (0)

Pstork1 65,906 Most Valuable Professional on at

Like (0)

Report

Re: SQL triggers

The proactive trigger requires the use of Webhooks, which aren't available in on-premises. The on-premises environment through the gateway operates using a Polling mechanism. So as the documentation states the new record trigger does not function on-premises. You could use a recurrence trigger to retrieve new records and process them on a timed basis. However, if the period is set really short you will probably run into issues with throughput quotas.