Trigger: when a row is created/updated/deleted in SQL Server Table
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/
I want to start my flows by SQL Server database inserted/modified/deleted.
Now Microsoft Common Data Model, SharePoint List have trigger for inserted, modifed.
Ideas for Trigger.
1. SQL Server - When a row is inserted.
2. SQL Server - When a row is modified.
3. SQL Server - When a row is deleted.
Could the addition of an SQL trigger be added to the trigger selection menu? I am confused why it is not already there as there are prebuilt templates for SQL functions ex:
-Send an email to audience when SQL Row is added
-Send an email to audience when SQL Row meets a particular range of values.
We are working on triggers for rows added/updated. We don't have any plans for triggers on rows deleted.
Wow, Status "STARTED"
I as well need this to build a flow from an SQL database to Dynamics when a new entry is added to the third party database
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
I would like this very much as well. Any estimates on when it will be added?
@Stephen any update on this flow idea (row added to be exact)?
I need this as well - need to monitor database for changed values and then push those values into Power Bi.