{"id":110974,"date":"2018-08-14T11:52:31","date_gmt":"2018-08-14T18:52:31","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-microsoft-flow-integration-in-excel\/"},"modified":"2018-08-14T11:52:31","modified_gmt":"2018-08-14T18:52:31","slug":"introducing-microsoft-flow-integration-in-excel","status":"publish","type":"power-automate","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/introducing-microsoft-flow-integration-in-excel\/","title":{"rendered":"Introducing Microsoft Flow integration in Excel"},"content":{"rendered":"
We\u2019re pleased to announce that Microsoft Flow is now integrated into Excel. With this integration that uses the For a selected row trigger and the Flow launch panel, you can create and trigger on-demand flows for selected rows in any Excel table on spreadsheets hosted in SharePoint or OneDrive for Business. The Microsoft Flow for Excel add-in enables you to connect your data to a wide range of services such as SharePoint, Outlook 365, Dynamics 365, Teams, Visual Studio Online, Twitter, Approvals, etc. In this post, we\u2019ll walk you through this new capability with a hands-on example.<\/p>\n
Install the Flow Add-in<\/h1>\n
To get started, in Excel, go to the Insert tab in the ribbon and select Store. Then, in the dialog, search for Microsoft Flow. Then, click Add<\/strong>. \n<\/p>\n
\nScenario<\/h1>\n
Let\u2019s imagine that you work for Cronus Energy, a multi-national energy production company, which generates energy through wind turbines and hydroelectric power plants. Cronus is on the lookout for better ways to streamline and standardize internal processes to make things easier for their employees. They\u2019ve identified a key process they want to modernize:<\/p>\n
Transfer market data entered by Commercial Analysts (minimum energy to generate, maximum energy, and target energy based on revenue goals) to SharePoint so that the Operations team can decide which turbines to use for the week. After moving the data to SharePoint, they also want to send an alert to the team on Microsoft Teams and facilitate a discussion if needed. The Operations team uses a SharePoint list called Turbine Energy Distributions <\/strong>with the columns shown below.\u00a0 \n \n\u00a0 \nTheir development team is already short on resources, so they want to be able to stand up the solution quickly while avoiding as much custom development as possible. Let\u2019s see how Flow can help.<\/p>\n