{"id":110705,"date":"2016-07-02T05:03:32","date_gmt":"2016-07-02T12:03:32","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/more-june-updates\/"},"modified":"2016-07-02T05:03:32","modified_gmt":"2016-07-02T12:03:32","slug":"more-june-updates","status":"publish","type":"power-automate","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/more-june-updates\/","title":{"rendered":"More June Updates for Flow"},"content":{"rendered":"<p>The past two weeks we have released a few new features worth highlighting. As a quick recap, this month we have previously released:<\/p>\n<ul>\n<li>An<a href=\"https:\/\/flow.microsoft.com\/en-us\/blog\/mobile-ios-launch\/\"> iPhone app for monitoring your flows and receiving push notifications for interesting events<\/a>. <a href=\"https:\/\/go.microsoft.com\/fwlink\/?LinkID=808725&amp;clcid=0x409\">Go here to download the app<\/a> and you can <a href=\"https:\/\/flow.microsoft.com\/en-us\/services\/shared_flowpush\/push-notification\/\">check out the templates available for push notifications here<\/a>.<\/li>\n<li><a href=\"https:\/\/flow.microsoft.com\/en-us\/blog\/mail-and-all-activity\/\">Track the activity of your flows.<\/a> A new notification center is available in the portal that shows you failures (such as when a connection is no longer working or a flow has failed), and the All activity page shows you everything that has happened (good or bad).<\/li>\n<\/ul>\n<h2>Google Sheets support<\/h2>\n<p>In the past, we have had both the ability <a href=\"https:\/\/flow.microsoft.com\/en-us\/services\/shared_excel\/excel\/\">to use Excel<\/a>, as well <a href=\"https:\/\/flow.microsoft.com\/en-us\/services\/shared_googledrive\/google-drive\/\">as Google Drive<\/a>, but this week we are adding native Google Sheets support. <a href=\"https:\/\/flow.microsoft.com\/en-us\/services\/shared_googlesheet\/google-sheets\/\">Check out all the templates here.<\/a><\/p>\n<p><img decoding=\"async\" alt=\"Available Google Sheets templates\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/more-june-google-sheets.png\" style=\"width: 398px; height: 296px;\"\/><\/p>\n<p>There are a few interesting types of scenarios I&#8217;d like to highlight as useful with Google Sheets (these all apply to Excel as well):<\/p>\n<ol>\n<li><strong>Collect data from a service on the internet and save it into a sheet.<\/strong> One of <a href=\"https:\/\/flow.microsoft.com\/en-us\/galleries\/public\/templates\/49e29754b224468fb3db9605f8110913\/save-tweets-to-a-google-sheet\/\">the most popular examples of this is Twitter<\/a> &#8211; so you can track tweets about your company. Another popular example is <a href=\"https:\/\/flow.microsoft.com\/en-us\/galleries\/public\/templates\/2450bd95476343aa9114de8be885cbb9\/rss-feed-to-a-google-sheet\/\">RSS to collect news articles<\/a>.<\/li>\n<li><strong>Create entries in your CRM from rows in a sheet.<\/strong> For example, you may get a list of sales leads in a sheet, and you want to quickly get those leads into your CRM system. With flow, you can easily get these leads moved from the sheet right into <a href=\"https:\/\/flow.microsoft.com\/en-us\/galleries\/public\/templates\/13b99a4fbf0246f7bb2e28b3181a6f34\/create-salesforce-leads-from-a-google-sheet\/\">Salesforce<\/a> or <a href=\"https:\/\/flow.microsoft.com\/en-us\/galleries\/public\/templates\/cfcdf369658d427caea0c92f053690c9\/create-dynamics-crm-leads-from-a-google-sheet\/\">Dynamics<\/a>.<\/li>\n<li><strong>Use a sheet as a mailing list for sending our emails<\/strong> (or any other form of communication). <a href=\"https:\/\/flow.microsoft.com\/en-us\/galleries\/public\/templates\/f3a5f1186e0e4db2aad1c0665ee910b4\/email-new-files-in-dropbox-to-a-mailing-list-in-google-sheets\/\">This template will<\/a> watch your Dropbox for a new newsletter, and when it&#8217;s added get a list of email addresses from a sheet and send each person in that mailing list the newsletter.\u00a0<\/li>\n<\/ol>\n<h2>Get started more quickly from templates<\/h2>\n<p>We have also made same optimizations to the way you can start from templates. Now, you can select what accounts you want to use for a template right inline on the template page:<\/p>\n<p><img decoding=\"async\" alt=\"Starting from templates improvements\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/more-june-new-templates.png\" style=\"width: 401px; height: 450px;\"\/><\/p>\n<p>Another improvement for using templates is <strong>single-sign-on<\/strong>. If you want to use SharePoint, Office 365, OneDrive for Business etc&#8230; (any service that uses Azure Active Directory), now you no longer have to enter your password the first time you connect &#8211; we will automatically pick up your sign-in information from how you connected to the Flow portal.<\/p>\n<h2>No expiring authorization for SharePoint and Office 365<\/h2>\n<p>Up until this week, for Azure Active Directory-based services (SharePoint, Yammer, Office 365 etc&#8230;), whenever you changed your password you would have to re-authorize Microsoft Flow to continue to have access. The most common reason this happened was most companies have policies that you need to update your password every ~60 days, and this would break your flows. Now, Microsoft Flow will automatically renew your access, so all of your flows will continue working across password changes. There are still scenarios where Microsoft Flow&#8217;s authorization can expire (if you company changes certain auth policies), but it should be very rare going forward.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Earlier this month we <a href=\"https:\/\/flow.microsoft.com\/en-us\/blog\/mobile-ios-launch\/\">released a new mobile app<\/a> and <a href=\"https:\/\/flow.microsoft.com\/en-us\/blog\/mail-and-all-activity\/\">the ability to track your flows&#8217; activity<\/a>, but we had even more updates in June: <a href=\"https:\/\/flow.microsoft.com\/en-us\/services\/shared_googlesheet\/google-sheets\/\">native support for Google sheets<\/a>, making templates faster to get started, and non-expiring authentication for Azure Active Directory. <\/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-110705","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>More June Updates for Flow - 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\/more-june-updates\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"More June Updates for Flow - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"Earlier this month we released a new mobile app and the ability to track your flows&#039; activity, but we had even more updates in June: native support for Google sheets, making templates faster to get started, and non-expiring authentication for Azure Active Directory.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/more-june-updates\/\" \/>\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\/more-june-google-sheets.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\/more-june-updates\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/more-june-updates\/\",\"name\":\"More June Updates for Flow - 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\/more-june-updates\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/more-june-updates\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/more-june-google-sheets.png\",\"datePublished\":\"2016-07-02T12:03:32+00:00\",\"dateModified\":\"2016-07-02T12:03:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/more-june-updates\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/more-june-updates\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/more-june-updates\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/more-june-google-sheets.webp\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/more-june-google-sheets.webp\",\"width\":398,\"height\":296},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/more-june-updates\/#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\":\"More June Updates for Flow\"}]},{\"@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":"More June Updates for Flow - 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\/more-june-updates\/","og_locale":"en_US","og_type":"article","og_title":"More June Updates for Flow - Microsoft Power Platform Blog","og_description":"Earlier this month we released a new mobile app and the ability to track your flows' activity, but we had even more updates in June: native support for Google sheets, making templates faster to get started, and non-expiring authentication for Azure Active Directory.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/more-june-updates\/","og_site_name":"Microsoft Power Platform Blog","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/more-june-google-sheets.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\/more-june-updates\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/more-june-updates\/","name":"More June Updates for Flow - 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\/more-june-updates\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/more-june-updates\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/more-june-google-sheets.png","datePublished":"2016-07-02T12:03:32+00:00","dateModified":"2016-07-02T12:03:32+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/more-june-updates\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/more-june-updates\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/more-june-updates\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/more-june-google-sheets.webp","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/more-june-google-sheets.webp","width":398,"height":296},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/more-june-updates\/#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":"More June Updates for Flow"}]},{"@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\/110705"}],"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=110705"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate\/110705\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=110705"}],"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=110705"},{"taxonomy":"power-automate-tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate-tag?post=110705"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=110705"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}