{"id":110898,"date":"2017-09-25T08:37:38","date_gmt":"2017-09-25T15:37:38","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-triggers-in-the-sql-connector\/"},"modified":"2017-09-25T08:37:38","modified_gmt":"2017-09-25T15:37:38","slug":"introducing-triggers-in-the-sql-connector","status":"publish","type":"power-automate","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-triggers-in-the-sql-connector\/","title":{"rendered":"Introducing triggers in the SQL Connector"},"content":{"rendered":"<p>The SQL Database Connector in Logic Apps and Flow is one of the most popular connectors, and we have just added a highly requested feature \u2013 triggers.\u00a0 Now, you can kick off your Flow or Logic Apps whenever a row is inserted or modified in a SQL Azure Database table.<br \/>\n<img decoding=\"async\" alt=\"Triggers for the SQL Connector\" src=\"https:\/\/connectorasset.blob.core.windows.net\/public\/sqlTrigger1.png\" style=\"border: 0px currentColor; border-image: none; width: 912px; height: 216px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" title=\"Triggers available for the SQL Connector\"\/><\/p>\n<p>Using the trigger is straightforward.\u00a0 Select the appropriate trigger.\u00a0 Create your connection (if you have not already) or select an existing connection.\u00a0 Then, select the table from the drop-down. [If you don\u2019t see your table, see the notes below.]\u00a0 You can also choose to further limit the rows returned by specifying a filter.<br \/>\n<img decoding=\"async\" alt=\"When an item is created - SQL Trigger\" src=\"https:\/\/connectorasset.blob.core.windows.net\/public\/sqlTrigger2.png\" style=\"border: 0px currentColor; border-image: none; width: 918px; height: 409px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" title=\"When an item is created - SQL Trigger\"\/><\/p>\n<p>Once you configure the trigger, you can now use the output from the trigger in any action in your Flow or Logic App.\u00a0 The trigger will make available the columns of the selected tables.<br \/>\n<img decoding=\"async\" alt=\"The trigger provides dynamic schema\" src=\"https:\/\/connectorasset.blob.core.windows.net\/public\/sqlTrigger3.png\" style=\"border: 0px currentColor; border-image: none; width: 510px; height: 724px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" title=\"The trigger lists the columns in the table\"\/><\/p>\n<p>You can now save the flow, and it will kick off whenever a row is added to (or modified in) the selected SQL Database table.<br \/>\n<img decoding=\"async\" alt=\"The run output of the trigger\" src=\"https:\/\/connectorasset.blob.core.windows.net\/public\/sqlTrigger4.png\" style=\"border: 0px currentColor; border-image: none; width: 644px; height: 724px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" title=\"The run output of the trigger\"\/><\/p>\n<p>That\u2019s it.\u00a0 You now have a working flow that you can use to monitor and automate whenever rows are added or modified in your SQL table.<\/p>\n<p>\u00a0<\/p>\n<h2>Limitations<\/h2>\n<p>The triggers do have the following limitations:<\/p>\n<ul>\n<li>It does not work for on-premises SQL Server<\/li>\n<li>Table must have an <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/create-table-transact-sql-identity-property\">IDENTITY<\/a> column for the new row trigger<\/li>\n<li>Table must have a <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/data-types\/rowversion-transact-sql\">ROWVERSION<\/a> (a.k.a. TIMESTAMP) column for the modified row trigger<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<h2>A Brief note on the design and on the limitations<\/h2>\n<p>Some of you might have noticed that this feature has been available for some time now as a limited preview feature of Logic Apps in the East US 2 region.\u00a0 Designing and implementing a trigger is more complex than adding actions.\u00a0 This is because, the trigger needs to monitor and track changes.\u00a0 In the case of SQL Databases, unfortunately, there is no mechanism of tracking changes that will work for all tables.\u00a0 Therefore, specific tables must have specific column types which are designed for change tracking.\u00a0 In order to track changes like addition or modification of rows in a table, <em><strong>the table must have a column whose value is unique and whose value increases (or decrease) monotonically each time such a change is made<\/strong><\/em>.\u00a0 This is satisfied by having an IDENTITY column for tracking creation, and ROWVERSION (a.k.a. TIMESTAMP) column for tracking modification .<\/p>\n<p>So, what happens when there is no such column in a table?\u00a0 Those tables will not be listed when you try to use the trigger.\u00a0 And, it will not work if you do try to type the table name manually.\u00a0 The only workaround then is to externalize the state yourself and use the \u201cGet rows\u201d action to query for the changes.<\/p>\n<p>\nWe would, of course, like to hear your feedback.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The SQL Database Connector in Logic Apps and Flow is one of the most popular connector, and we have just added a highly requested feature \u2013 triggers. Now, you can kick off your Flow or Logic Apps whenever a row is inserted or modified in a SQL Azure Database table.<\/p>\n","protected":false},"author":149,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","power-automate-category":[2752],"power-automate-tag":[2513,2789],"coauthors":[2351],"class_list":["post-110898","power-automate","type-power-automate","status-publish","hentry","power-automate-category-product-updates","power-automate-tag-connector","power-automate-tag-sql-flow"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Introducing triggers in the SQL Connector - Microsoft Power Platform Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-triggers-in-the-sql-connector\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Introducing triggers in the SQL Connector - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"The SQL Database Connector in Logic Apps and Flow is one of the most popular connector, and we have just added a highly requested feature \u2013 triggers. Now, you can kick off your Flow or Logic Apps whenever a row is inserted or modified in a SQL Azure Database table.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-triggers-in-the-sql-connector\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"og:image\" content=\"https:\/\/connectorasset.blob.core.windows.net\/public\/sqlTrigger1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 min read\" \/>\n\t<meta name=\"twitter:label2\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data2\" content=\"Sameer Chabungbam\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-triggers-in-the-sql-connector\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-triggers-in-the-sql-connector\/\",\"name\":\"Introducing triggers in the SQL Connector - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-triggers-in-the-sql-connector\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-triggers-in-the-sql-connector\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/connectorasset.blob.core.windows.net\/public\/sqlTrigger1.png\",\"datePublished\":\"2017-09-25T15:37:38+00:00\",\"dateModified\":\"2017-09-25T15:37:38+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-triggers-in-the-sql-connector\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-triggers-in-the-sql-connector\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-triggers-in-the-sql-connector\/#primaryimage\",\"url\":\"https:\/\/connectorasset.blob.core.windows.net\/public\/sqlTrigger1.png\",\"contentUrl\":\"https:\/\/connectorasset.blob.core.windows.net\/public\/sqlTrigger1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-triggers-in-the-sql-connector\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power Automate\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Introducing triggers in the SQL Connector\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Introducing triggers in the SQL Connector - Microsoft Power Platform Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-triggers-in-the-sql-connector\/","og_locale":"en_US","og_type":"article","og_title":"Introducing triggers in the SQL Connector - Microsoft Power Platform Blog","og_description":"The SQL Database Connector in Logic Apps and Flow is one of the most popular connector, and we have just added a highly requested feature \u2013 triggers. Now, you can kick off your Flow or Logic Apps whenever a row is inserted or modified in a SQL Azure Database table.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-triggers-in-the-sql-connector\/","og_site_name":"Microsoft Power Platform Blog","og_image":[{"url":"https:\/\/connectorasset.blob.core.windows.net\/public\/sqlTrigger1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 min read","Written by":"Sameer Chabungbam"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-triggers-in-the-sql-connector\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-triggers-in-the-sql-connector\/","name":"Introducing triggers in the SQL Connector - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-triggers-in-the-sql-connector\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-triggers-in-the-sql-connector\/#primaryimage"},"thumbnailUrl":"https:\/\/connectorasset.blob.core.windows.net\/public\/sqlTrigger1.png","datePublished":"2017-09-25T15:37:38+00:00","dateModified":"2017-09-25T15:37:38+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-triggers-in-the-sql-connector\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-triggers-in-the-sql-connector\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-triggers-in-the-sql-connector\/#primaryimage","url":"https:\/\/connectorasset.blob.core.windows.net\/public\/sqlTrigger1.png","contentUrl":"https:\/\/connectorasset.blob.core.windows.net\/public\/sqlTrigger1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-triggers-in-the-sql-connector\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Power Automate","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/"},{"@type":"ListItem","position":3,"name":"Introducing triggers in the SQL Connector"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate\/110898"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/power-automate"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/149"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=110898"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate\/110898\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=110898"}],"wp:term":[{"taxonomy":"power-automate-category","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate-category?post=110898"},{"taxonomy":"power-automate-tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate-tag?post=110898"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=110898"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}