{"id":110977,"date":"2018-07-23T06:57:09","date_gmt":"2018-07-23T13:57:09","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/excel-bpf-todo-and-more\/"},"modified":"2018-07-23T06:57:09","modified_gmt":"2018-07-23T13:57:09","slug":"excel-bpf-todo-and-more","status":"publish","type":"power-automate","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/excel-bpf-todo-and-more\/","title":{"rendered":"Flow is available in Excel and the Outlook Web App, introducing Business process flows, and more!"},"content":{"rendered":"
With the new Flow button, create and trigger automations from Flow on your table data in Excel to automate data processing or the copying\/importing of data. You can create and run on-demand flows for selected rows in any Excel table on spreadsheets hosted in SharePoint or OneDrive for Business.<\/p>\n
To get started, in Excel, go to the Insert <\/strong>tab in the ribbon and select\u00a0Store<\/strong>. Then, in the dialog, search for Microsoft Flow<\/em>. You can then Add <\/strong>the Add-in.<\/p>\n <\/p>\n Once you’ve installed the Flow add-in, you can select the Flow button on the Data tab. From the Flow launch panel, build your flow by using the For a selected row trigger, or start from one of the templates:<\/p>\n After the flow is created, select a row, and then select the Play button to see your flow in action.<\/p>\n <\/p>\n Now you can model human-driven business processes in Microsoft Flow, in addition to the rich automated workflows that have always been possible.<\/p>\n The Business process flow<\/strong> is a new type of stateful, human-interactive flow, based on the Common Data Service for Apps. Use these new flows to define a set of stages or steps for people to follow. Unlike automated workflows, they can move forward and backward as needed. In addition, the flow creator can define any number of inputs that are required for each stage. These inputs are collected on entities stored in the Common Data Service for Apps, meaning that you can build other rich processes and applications on the data.<\/p>\n For example, you can configure flows to support common sales methodologies that can help your sales groups achieve better results. For service groups, flows can help new staff get up to speed more quickly and avoid mistakes that could result in unsatisfied customers.<\/p>\n Since Business process flows store the inputs on each stage of the flow, they require a CDS database to work. This makes them different from the other types of flows in Microsoft Flow, and introduce some additional requirements to get started:<\/p>\n Once you have your database set up, select the Business process flows<\/strong> tab on the My flows<\/strong> page and select Create from blank<\/strong>. Note: We do not yet support creating Business process flows from a template.<\/p>\n In the form, give your new flow a name, and then select which entity you want to use for storing the information of the Business process flow.<\/p>\n <\/p>\n Select OK<\/strong> – the flow will take a few seconds to create, and then will appear in the flow list. When you create a Business process flow, it is off by default because you first need to define the stages that you want in the process. Click the pencil icon to design your flow.<\/p>\n When you click edit, you’ll see a new UI designer with each of the stages in the flow;<\/p>\n <\/p>\n Each stage contains a group of steps. Each step represents a field where data can be entered. People advance to the next stage by using the Next Stage button. You can make a step required, so that people must enter data for the corresponding field before they can proceed to the next stage. This is commonly called \u201cstage-gating.\u201d In addition, you can call classic Common Data Service workflows from inside a Business process flow.<\/p>\n To see more details about designing your flow, read this detailed article<\/a>. This article covers both how to add stages, condition, and how to share this flow with other people in the environment so they can participate in it.<\/p>\n Once you have created and shared the flow you can run it in the context of a Model-driven app. For example, this is what a Business process flow looks like:<\/p>\n <\/p>\n You can read more about building Model-driven apps here<\/a>.\u00a0Finally, in addition to running the flow in an app, you can create dashboards and views to understand the overall progress of all runs of the flow.<\/p>\n A popular feature in Outlook is the sender’s ability to explicitly call out a person on the recipient list to draw his or her attention to the email. This is done by including the at sign (@) before the name of the person, which causes the name of the recipient to be highlighted in the email and the recipient’s email to be automatically included in the To line. By @mentioning someone in an email, you can call the recipient’s attention to an action item assigned to them.<\/p>\n Now, with just a few clicks, create a flow that automatically creates a task in Microsoft To-Do whenever someone is @mentioned in an email message. That way, tasks they need to follow up on are centrally located in the Microsoft To-Do app.<\/p>\n <\/p>\n The task contains the context from the email for reference, such as the sender and the body of the email. The recipient can add additional context, such as the, due date and categorization, from within the To-Do app.\u00a0At this time, this functionality is available only for Outlook Web App (OWA).<\/p>\n Microsoft IoT Central is the first true highly scalable IoT software-as-a-service (SaaS) solution that offers built-in support for IoT best practices and world-class security along with the reliability, regional availability, and global scale of the Microsoft Azure cloud. Microsoft IoT Central allows companies worldwide to build production-grade IoT applications in hours\u2014without having to manage all the necessary back-end infrastructure or learn new skills. In short, Microsoft IoT Central enables everyone to benefit from IoT.<\/p>\n Now, IoT users can reduce costly scheduled maintenance by proactively detecting and resolving issues remotely with Microsoft Flow. The Microsoft Flow connector enables you to create workflows that are triggered when an alert is fired. Like with any flows, you can drag and drop actions from hundreds of other systems in the library of published connectors. For example, create a new work order in Dynamics 365 Field Service, send a message using Twilio SMS, send a message to a Microsoft Teams channel in response to a new event in IoT. These are just a few examples of what you can do in Flow. To learn more, please visit documentation page<\/a>.<\/p>\n SharePoint views allow you to show or hide different columns in SharePoint lists (as well as to apply different formatting rules). For example, you could have a SharePoint list with a Detailed view<\/strong> that has many different columns:<\/p>\n <\/p>\n At the same time, you could have a much simpler view with just a few columns:<\/p>\n <\/p>\n This simpler view helps people using the list to focus on just the details that are important to them. Views can now also make flows easier to build. On any trigger or action in SharePoint that gets items from a list, there is a new setting under Show advanced options<\/strong>: Limit Columns by View<\/strong>:<\/p>\n <\/p>\n When you select a view, in subsequent actions in the flow, the outputs of the trigger or action will be filtered to what shows up in that view (plus a few standard columns like Path<\/strong>, Identifier<\/strong>, and Link to item<\/strong>):<\/p>\n <\/p>\n We also have three other new connectors in the past week:<\/p>\n There are two new flow integrations: with the new Flow button in Excel, you can create and trigger automation directly on tables in your worksheets, and, you can now create flows that sync tasks to Microsoft ToDo in the Outlook Web App. Second, we are introducing a new type of flow: the Business process flow — a stateful, human-interactive flow based on the Common Data Service for Apps. Finally, Microsoft Flow has four new connectors: Azure IoT Central, Survey 123, LMS365 and ProjectWise Design Integration, and, improvements to the SharePoint connector.<\/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-110977","power-automate","type-power-automate","status-publish","hentry","power-automate-category-product-updates"],"yoast_head":"\n\n
Create Business Process Flows<\/h2>\n
Business process flow requirements<\/h3>\n
\n
\n<\/li>\n
\n<\/li>\n
\n<\/li>\nCreate your first Business process flow<\/h3>\n
Designing the flow<\/h3>\n
Using the flow<\/h3>\n
Create a flow for Microsoft To-Do in Outlook Web App<\/h2>\n
Azure IoT Cental connector in Flow<\/h2>\n
Limit columns by view in SharePoint<\/h2>\n
Three new partner connectors<\/h2>\n
\n