cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CRMSample
Level: Powered On

MS Flow Trigger for onPremise SQl Server

Hi All,

 

Can we trigger MS flow on Insert/Update row in Onpremise SQL Server. I have read on some older blogs that trigger doesn't work for onPremise sql server but on latest Flow documentation it not mentioned anywhere .[https://docs.microsoft.com/en-gb/connectors/sql/#known-issues-and-limitations]

 

Actually i installed SQL Server on my local system and configured gateway. I can trigger MS flow on Insert/Update row for onpremise Sql server. Now Client  has shared a Sql Server connecction, i configured MS flow to trigger for this connection but its not triggering at all. After going through all the blogs i got confused whether trigger suppose to work or not for Onpremise sql server. Any help would be appriciated.  

10 REPLIES 10
CRMSample
Level: Powered On

Re: MS Flow Trigger for onPremise SQl Server

Hi all,

 

Can anyone please resond to the question. Is it possible to trigger MS flow for On premise SQL Server ? 

Community Support Team
Community Support Team

Re: MS Flow Trigger for onPremise SQl Server

Hi @CRMSample,

 

We could trigger MS flow on Insert/Update row SQL Server if you use Local Onpremise data gateway。

 

And as we can see in the link you have provided, SQL native query is not supported for on-premises SQL server.

 

You could make a test on your side.

 

Best regards,

Alice

CRMSample
Level: Powered On

Re: MS Flow Trigger for onPremise SQl Server

Thanks for the reply @v-yuazh-msft.

Actually before posting this qus, i tested it at my end using onpremise data gateway and it worked fine for me. But the issue i am facing is, third party vendors are managing onpremise database. They have configured the onpremise gateway and shared the connection with service account, using that service account i have configured the MS flow to trigger on insert/update of sql table. Now when we do a insert in sql table, MS flow doesn't trigger. Its not showing any failed or Error in run history. 

but I can see many "Skipped entry" in Checks(no new data) in run history section. Can you please help me on this issue.

After going through some blogs i was wondering whether trigger suppose to work or not for onpremise sql server.[https://flow.microsoft.com/en-us/blog/introducing-triggers-in-the-sql-connector/]

Since you have confirmed it, can you please advice me on some troubleshooting steps. Just to mention i am new to MS flow and trying to get all the helps to solve this issue. Many thanks !

  

A8Tony
Level: Powered On

Re: MS Flow Trigger for onPremise SQl Server

It is my understanding that it is not currently possible to trigger flow from an on-premise SQL server. The documentation you refer to in your last link describes functionality which is available to an SQL Azure database.

 

It is something I'm absolutely waiting for, as I have clients who use on-premise SQL databases (often multiple) and this would allow me to do even more with Flow 

CRMSample
Level: Powered On

Re: MS Flow Trigger for onPremise SQl Server

Hi A8Tony,

 

Actually Flow will trigger for On premise server as well but only for the latest version of sql server. I have tested it with the SQL version 2017. For earlier version it wont work (not sure about 2016)

 

A8Tony
Level: Powered On

Re: MS Flow Trigger for onPremise SQl Server

Thanks for this CRM Sample, I'll give this a go next week 👍
A8Tony
Level: Powered On

Re: MS Flow Trigger for onPremise SQl Server

Hi CRMSample,

 

I've tried a quick test this morning but have not successfully triggered a flow from a record being created.

 

Can you confirm that this is possible using the On Premise Data Gateway? And if so, did you have to make any specific settings on the SQL database configuration to allow this?

 

Thanks,

Tony

moutinhoabreu
Level: Powered On

Re: MS Flow Trigger for onPremise SQl Server

I would also love to know if it's already working.

 


kalor
Level: Powered On

Re: MS Flow Trigger for onPremise SQl Server

I have on prem triggers working here with SQL 2008, but it only works for add not modify, and only with a table that has an identity.

Highlighted
MickThornton
Level: Powered On

Re: MS Flow Trigger for onPremise SQl Server

@kalor is correct. I can also confirm that Flow connecting to SQL OnPrem through data gateway works for the create or add record to a table.  Updates to a record does not work (as of June 2019) through the data gateway to SQL OnPrem.  

 

Example: If status = "Under Review" for a record and a flow is set to send an email when the status = "Under Review". 

Could a person use the flow to "ping" the database every 15 minutes and look for a change in a field within a record in a table?  Or would that send an email every 15 minutes that the field currently has a specific value being looked for?  

 

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users Online
Currently online: 147 members 4,953 guests
Please welcome our newest community members: