{"id":110862,"date":"2017-06-16T01:32:56","date_gmt":"2017-06-16T08:32:56","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/seven-connectors-and-html\/"},"modified":"2017-06-16T01:32:56","modified_gmt":"2017-06-16T08:32:56","slug":"seven-connectors-and-html","status":"publish","type":"power-automate","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/seven-connectors-and-html\/","title":{"rendered":"Seven new connectors and other new features like converting HTML to plain text"},"content":{"rendered":"<h1>Content Conversion service<\/h1>\n<p>This week we have added a new connector that can convert HTML content to plain text, which was <a href=\"https:\/\/powerusers.microsoft.com\/t5\/Flow-Ideas\/Get-the-text-from-an-email-instead-of-the-HTML-content\/idi-p\/1641\">a top ask on our community<\/a>. For example, when you receive emails that are HTML formatted, you may want only the plain text representation of that email.<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/seven-connectors-html-to-text.png\" style=\"width: 460px; height: 238px;\"\/><\/p>\n<p>The conversion to plain text will remove all formatting, although it will attempt to preserve some aspects like Tables and Links so that the content is still readable. To find this new action, just search for <strong>HTML <\/strong>when you add an action.<\/p>\n<h1>Three read-only database connectors<\/h1>\n<p>Next, Microsoft Flow has added support for:<\/p>\n<ul>\n<li><strong><a href=\"https:\/\/flow.microsoft.com\/services\/shared_mysql\/\">MySQL<\/a><\/strong>\u00a0&#8211; an open-source relational database management system.<\/li>\n<li><strong><a href=\"https:\/\/flow.microsoft.com\/services\/shared_postgresql\/\">PostgreSQL<\/a>\u00a0&#8211;\u00a0<\/strong>a relational database management system developed by PostgreSQL Global Development Group.<\/li>\n<li><strong><a href=\"https:\/\/flow.microsoft.com\/services\/shared_teradata\/\">Teradata<\/a>\u00a0&#8211;\u00a0<\/strong>a relational database management system from Teradata Corporation, typically used to support large data warehousing operations.\u00a0<\/li>\n<\/ul>\n<p>These all can be used to connect to your on-premises databases and read data using the <strong>Get row<\/strong>\u00a0or <strong>Get rows<\/strong> operations. Note that in order to use these three new services you will need to install the\u00a0<strong>On-premises<\/strong>\u00a0<strong>data gateway <\/strong>(even if the service is available for the cloud).<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/seven-connectors-mysql.png\" style=\"width: 461px; height: 340px;\"\/><\/p>\n<p>At this time, we do not currently support writing data into these databases (although that is on our product backlog).\u00a0<\/p>\n<h1>Azure Application Insights<\/h1>\n<p>If you have a Web application, <a href=\"https:\/\/azure.microsoft.com\/services\/application-insights\/\">Application Insights<\/a> is a great way to monitor and analyze your performance and usage. To get started with Application Insights you&#8217;ll first have to get a new API Key from\u00a0<a href=\"https:\/\/portal.azure.com\"><strong>portal.azure.com<\/strong><\/a>. Select the application you&#8217;re interested in and find\u00a0<strong>API Access<\/strong>\u00a0in the\u00a0<strong>Configure<\/strong>\u00a0section<strong>\u00a0<\/strong>(it&#8217;s near the bottom). Then create a new API Key and ensure it has permissions to Read telemetry.<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/seven-connectors-api-key.png\" style=\"width: 390px; height: 145px;\"\/><\/p>\n<p>Now you can copy the\u00a0<strong>Application ID<\/strong>\u00a0and\u00a0<strong>API Key<\/strong>\u00a0for when you create a connection in Microsoft Flow. There are currently two actions:<\/p>\n<ul>\n<li><strong>Run Analytics query<\/strong> &#8211;\u00a0Runs an Analytics query on the specified Application Insights resource<\/li>\n<li><strong>Visualize Analytics query<\/strong> &#8211;\u00a0Creates a visualization from the results of an Analytics query<\/li>\n<\/ul>\n<p>With the second action, for example, you can generate an email that gets sent with charts or HTML tables about your application&#8217;s analytics:<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/seven-connectors-pie-chart.png\" style=\"width: 410px; height: 294px;\"\/><\/p>\n<h1>Two new partner connectors<\/h1>\n<p>In addition to the above connectors we have two more partner services:<\/p>\n<ul>\n<li><strong><a href=\"https:\/\/flow.microsoft.com\/connectors\/shared_calendly\/\">Calendly<\/a><\/strong> &#8211; Calendly helps you easily schedule meetings based on participants availability.<\/li>\n<li><strong><a href=\"https:\/\/flow.microsoft.com\/connectors\/shared_teamwork\/\">Teamwork Projects<\/a><\/strong> &#8211; Keep all your team&#8217;s tasks in one place. Collaborate and work in real time for real results. Teamwork Projects is a powerful and simple way to collaborate with your team.<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/seven-connectors-calendly.png\" style=\"width: 230px; height: 115px;\"\/><\/p>\n<h1>Other usability improvements<\/h1>\n<p>Finally, we have made some other helpful usability improvements, including:<\/p>\n<ul>\n<li>Better visualization for error handling steps &#8212; steps that run after errors are now shown with red dotted arrows so you can easily identify which steps run after a failure:<br \/>\n<img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/seven-connectors-error.png\" style=\"width: 425px; height: 80px;\"\/><\/li>\n<li>When a flow fails there is now a new right-hand pane that contains some helpful steps for how to correct your flow:<br \/>\n<img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/seven-connectors-pane.png\" style=\"width: 400px; height: 159px;\"\/><\/li>\n<\/ul>\n<p>Please let us know <a href=\"https:\/\/go.microsoft.com\/fwlink\/?LinkId=787467&amp;clcid=0x409\">on our community<\/a> what other areas we can make usability improvements in.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This week we have introduced seven new connectors: <a href=\"https:\/\/flow.microsoft.com\/services\/shared_applicationinsights\">Azure Application Insights<\/a> &#8211; an extensible analytics service that helps you understand the performance and usage of your live web application, <a href=\"https:\/\/flow.microsoft.com\/services\/shared_calendly\/\">Calendly<\/a>, <a href=\"https:\/\/flow.microsoft.com\/services\/shared_conversionservice\/\">Content Conversion<\/a> for converting HTML content, such as from emails, to plain text, <a href=\"https:\/\/flow.microsoft.com\/services\/shared_mysql\/\">MySQL<\/a>, <a href=\"https:\/\/flow.microsoft.com\/services\/shared_postgresql\/\">PostgreSQL<\/a>, <a href=\"https:\/\/flow.microsoft.com\/en-us\/services\/shared_teamwork\/teamwork-projects\/\">Teamwork Projects<\/a>, and <a href=\"https:\/\/flow.microsoft.com\/services\/shared_teradata\/\">Teradata<\/a>. <\/p>\n","protected":false},"author":347,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","power-automate-category":[2752],"power-automate-tag":[],"coauthors":[2913],"class_list":["post-110862","power-automate","type-power-automate","status-publish","hentry","power-automate-category-product-updates"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Seven new connectors and other new features like converting HTML to plain text - 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\/seven-connectors-and-html\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Seven new connectors and other new features like converting HTML to plain text - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"This week we have introduced seven new connectors: Azure Application Insights - an extensible analytics service that helps you understand the performance and usage of your live web application, Calendly, Content Conversion for converting HTML content, such as from emails, to plain text, MySQL, PostgreSQL, Teamwork Projects, and Teradata.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/seven-connectors-and-html\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/seven-connectors-html-to-text.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=\"Stephen Siciliano\" \/>\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\/seven-connectors-and-html\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/seven-connectors-and-html\/\",\"name\":\"Seven new connectors and other new features like converting HTML to plain text - 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\/seven-connectors-and-html\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/seven-connectors-and-html\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/seven-connectors-html-to-text.png\",\"datePublished\":\"2017-06-16T08:32:56+00:00\",\"dateModified\":\"2017-06-16T08:32:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/seven-connectors-and-html\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/seven-connectors-and-html\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/seven-connectors-and-html\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/seven-connectors-html-to-text.webp\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/seven-connectors-html-to-text.webp\",\"width\":920,\"height\":477,\"caption\":\"graphical user interface, text, application, email\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/seven-connectors-and-html\/#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\":\"Seven new connectors and other new features like converting HTML to plain text\"}]},{\"@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":"Seven new connectors and other new features like converting HTML to plain text - 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\/seven-connectors-and-html\/","og_locale":"en_US","og_type":"article","og_title":"Seven new connectors and other new features like converting HTML to plain text - Microsoft Power Platform Blog","og_description":"This week we have introduced seven new connectors: Azure Application Insights - an extensible analytics service that helps you understand the performance and usage of your live web application, Calendly, Content Conversion for converting HTML content, such as from emails, to plain text, MySQL, PostgreSQL, Teamwork Projects, and Teradata.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/seven-connectors-and-html\/","og_site_name":"Microsoft Power Platform Blog","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/seven-connectors-html-to-text.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 min read","Written by":"Stephen Siciliano"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/seven-connectors-and-html\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/seven-connectors-and-html\/","name":"Seven new connectors and other new features like converting HTML to plain text - 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\/seven-connectors-and-html\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/seven-connectors-and-html\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/seven-connectors-html-to-text.png","datePublished":"2017-06-16T08:32:56+00:00","dateModified":"2017-06-16T08:32:56+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/seven-connectors-and-html\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/seven-connectors-and-html\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/seven-connectors-and-html\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/seven-connectors-html-to-text.webp","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/seven-connectors-html-to-text.webp","width":920,"height":477,"caption":"graphical user interface, text, application, email"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/seven-connectors-and-html\/#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":"Seven new connectors and other new features like converting HTML to plain text"}]},{"@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\/110862"}],"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\/347"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=110862"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate\/110862\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=110862"}],"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=110862"},{"taxonomy":"power-automate-tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate-tag?post=110862"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=110862"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}