cancel
Showing results for 
Search instead for 
Did you mean: 

Trigger: when a row is created/updated/deleted in SQL Server Table

Trigger: when a row is created/updated/deleted in SQL Server Table

Status: Completed

You can now trigger based on new or updated SQL rows, read more about it here: https://flow.microsoft.com/en-us/blog/q3-2017-update/

Comments
New Member

We have several applications waiting on this type of functionality.  I hope there is something in the near future. 

Frequent Visitor

Definitely waiting on this. Need to trigger a flow when a record is added or updated in SQL!!

Regular Visitor

Hello

 

When will be trigger with deleted?  I want to start with my flows by SQL Server database, I must monitor database for raports in Power BI ?

Power Automate
Status changed to: Completed

You can now trigger based on new or updated SQL rows, read more about it here: https://flow.microsoft.com/en-us/blog/q3-2017-update/

Memorable Member

Thank you @Stephen , for the Trigger when a row is created / updated / deleted in SQL Server

 

Advocate II

As usual for Microsoft, a half-baked solution claimed as a completed.

 

As per my comment, "Full CRUD (add, update, delete, read irrelevant) trigger for SQL. I want to provision SharePoint sites / libraries / folders based on rows added, updated, or deleted in a SQL table on-premises via the Data Management Gateway", we wanted a complete implementation.


Yet the so called solution doesn't support on-premises SQL tables.

 

Why do you always do this, Microsoft?  You never complete a product, and just leave it as a three legged chair, just about able to claim the thing is chair-like but still unable to sit on it.  And then make annoying announcements like "Completed", "Solved", etc. in your forums claiming victory.

 

THIS IS NOT COMPLETED.  The request as per the above commentary specifically stated on-premises to be supported.  You simply haven't delivered.

 

Please remove the "completed" status and keep this open until the on-premises SQL tables are supported.

 

 

New Member

I am new to Power Automate, and I am working on creating an item in Microsoft 365 SharePoint list when an item is created in my On-Prem SQL table. I have the gateway and connection working. I can write the conditions that I need, but it is duplicating the primary key  in the SharePoint List.

 

Could anybody please help? Thanks.

Regular Visitor

HI Stephen,

 

I'm new to Power Automated and I know this is an old post.  Is there any status on the delete trigger for SQL?   

I tried the following and that did not work.

Capture. Delete TriggerPNG.PNG

 

 

 

 

 

 

 

If there is alternative way, could you share the example or link?

 

Thanks,

Steve