{"id":110825,"date":"2017-06-06T05:58:04","date_gmt":"2017-06-06T12:58:04","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/microsoft-forms-tables-flow-failures\/"},"modified":"2017-06-06T05:58:04","modified_gmt":"2017-06-06T12:58:04","slug":"microsoft-forms-tables-flow-failures","status":"publish","type":"power-automate","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/microsoft-forms-tables-flow-failures\/","title":{"rendered":"Get notified about flow failures, customize columns for tables, and more!"},"content":{"rendered":"

Email notifications on flow failures<\/h2>\n

Sometimes your flow can fail. With the new error handling actions <\/a>you could send yourself a notification for ever flow failure – but this requires explicitly adding the action to every flow. This week we are rolling out Flow failure emails that will be sent automatically. These emails don’t require any special set up – but you can of course choose to unsubscribe (or resubscribe) to the emails.\u00a0<\/p>\n

\"\"<\/p>\n

In addition, these failure emails will only be sent once a week — so if you have a flow that fails many times a week we won’t send you a bunch of emails. As a result, if there is a particular flow that is very important, and you want to be notified on every single failure, we still would recommend explicitly setting up a notification<\/a> error-handling step.\u00a0<\/p>\n

Use the new Select action to customize tables<\/h2>\n

With the new Create HTML table and Create CSV table actions<\/a> you can take a list of records and send them in a single email or to a single file (as opposed to using an Apply to each and having an action for every list item). However, until now there was no way to customize the set of columns that would appear in that HTML or CSV table. With the new\u00a0Select<\/strong>\u00a0action you can do just that!<\/p>\n

\"\"<\/p>\n

To use the\u00a0Select<\/strong>\u00a0action you will find it under\u00a0Data operations<\/strong>. Next, choose the list of items that you want to customize for the\u00a0From\u00a0<\/strong>field (using the\u00a0Add dynamic content<\/strong>\u00a0picker). Then, under\u00a0Map<\/strong>\u00a0you will enter the columns that you want. First (key<\/strong>), enter the headers of each of the columns. Second (value<\/strong>), enter the\u00a0dynamic content<\/strong>\u00a0that will appear in each row of that column. You can use this to even combine fields from multiple columns. Likewise, any columns that you don’t include will not appear in the table, meaning this is a quick and easy way to filter the set of columns that appear.<\/p>\n

Microsoft Forms connector<\/h2>\n

Microsoft Forms<\/a> is a new part of Office 365 Education that allows teachers and students to create custom quizzes quickly and easily, surveys, questionnaires, registrations and more. With Microsoft Forms and Flow you can do simple things like get an email notification when a survey is filled out (or via our new Microsoft Teams connector), to more advanced things like sending each form response out for Approval and then adding the approved items to a SharePoint list.<\/p>\n

\"\"<\/p>\n

Office 365 Enterprise K1 plan<\/h2>\n

As previously announced<\/a>, we have added new value to the Office 365 Enterprise K1 plan. This plan is designed to maximize the impact and contribution of frontline workers with tools for schedule and task management, communications and community, training and onboarding, and identity and access management.<\/p>\n

A core part of our expanded value proposition in Office 365 Enterprise K1 is the ability to use PowerApps and Microsoft Flow. Imagine a retail organization that has 1000 stores across the country, with each store having about 10 kiosks on an average. There is an IT team with 10 members, who creates business apps on PowerApps and Microsoft Flow. These app makers need a plan which give them ability to create apps on PowerApps and Microsoft Flow e.g. Office 365 E1, E3 or E5. (Learn about all the plans.) And the rest of the 30,000 frontline workers, with Office 365 Enterprise K1 plan already have what they need to play these apps and to run flows.<\/p>\n

More easily fill out HTTP actions<\/h2>\n

Finally, we have also made it easier to fill out the headers section of the HTTP action. Just like the\u00a0Select<\/strong>\u00a0action you can provide a header name and header value by just filling out the text boxes on the action.<\/p>\n

\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

Microsoft Flow will now send email notifications when a flow fails — so you can always know as soon as something goes wrong. In addition, when working with list of items, you can now customize the columns, for example, when generating an HTML email. This week we are also adding support for Microsoft Forms<\/a> – a new part of Office 365 Education that allows teachers and students to quickly and easily create custom quizzes, surveys, questionnaires, registrations and more. PowerApps and Microsoft Flow are now included with the Office 365 Enterprise K1 plan as well.<\/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-110825","power-automate","type-power-automate","status-publish","hentry","power-automate-category-product-updates"],"yoast_head":"\nGet notified about flow failures, customize columns for tables, and more! - 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\/microsoft-forms-tables-flow-failures\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Get notified about flow failures, customize columns for tables, and more! - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"Microsoft Flow will now send email notifications when a flow fails -- so you can always know as soon as something goes wrong. In addition, when working with list of items, you can now customize the columns, for example, when generating an HTML email. This week we are also adding support for Microsoft Forms - a new part of Office 365 Education that allows teachers and students to quickly and easily create custom quizzes, surveys, questionnaires, registrations and more. PowerApps and Microsoft Flow are now included with the Office 365 Enterprise K1 plan as well.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/microsoft-forms-tables-flow-failures\/\" \/>\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\/forms-failure-email.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\/microsoft-forms-tables-flow-failures\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/microsoft-forms-tables-flow-failures\/\",\"name\":\"Get notified about flow failures, customize columns for tables, and more! - 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\/microsoft-forms-tables-flow-failures\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/microsoft-forms-tables-flow-failures\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/forms-failure-email.png\",\"datePublished\":\"2017-06-06T12:58:04+00:00\",\"dateModified\":\"2017-06-06T12:58:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/microsoft-forms-tables-flow-failures\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/microsoft-forms-tables-flow-failures\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/microsoft-forms-tables-flow-failures\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/forms-failure-email.webp\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/forms-failure-email.webp\",\"width\":856,\"height\":699,\"caption\":\"graphical user interface, text, application, email\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/microsoft-forms-tables-flow-failures\/#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\":\"Get notified about flow failures, customize columns for tables, and more!\"}]},{\"@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":"Get notified about flow failures, customize columns for tables, and more! - 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\/microsoft-forms-tables-flow-failures\/","og_locale":"en_US","og_type":"article","og_title":"Get notified about flow failures, customize columns for tables, and more! - Microsoft Power Platform Blog","og_description":"Microsoft Flow will now send email notifications when a flow fails -- so you can always know as soon as something goes wrong. In addition, when working with list of items, you can now customize the columns, for example, when generating an HTML email. This week we are also adding support for Microsoft Forms - a new part of Office 365 Education that allows teachers and students to quickly and easily create custom quizzes, surveys, questionnaires, registrations and more. PowerApps and Microsoft Flow are now included with the Office 365 Enterprise K1 plan as well.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/microsoft-forms-tables-flow-failures\/","og_site_name":"Microsoft Power Platform Blog","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/forms-failure-email.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\/microsoft-forms-tables-flow-failures\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/microsoft-forms-tables-flow-failures\/","name":"Get notified about flow failures, customize columns for tables, and more! - 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\/microsoft-forms-tables-flow-failures\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/microsoft-forms-tables-flow-failures\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/forms-failure-email.png","datePublished":"2017-06-06T12:58:04+00:00","dateModified":"2017-06-06T12:58:04+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/microsoft-forms-tables-flow-failures\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/microsoft-forms-tables-flow-failures\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/microsoft-forms-tables-flow-failures\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/forms-failure-email.webp","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/forms-failure-email.webp","width":856,"height":699,"caption":"graphical user interface, text, application, email"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/microsoft-forms-tables-flow-failures\/#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":"Get notified about flow failures, customize columns for tables, and more!"}]},{"@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\/110825"}],"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=110825"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate\/110825\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=110825"}],"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=110825"},{"taxonomy":"power-automate-tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate-tag?post=110825"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=110825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}