Build and run flows from Excel

Note

These release notes describe functionality that may not have been released yet. To see when this functionality is planned to release, please review Summary of what’s new. Delivery timelines and projected functionality may change or may not ship (see Microsoft policy).

With the new Flow button, you can create and trigger automations from Microsoft Flow on your table data in Microsoft Office Excel (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 in spreadsheets hosted in SharePoint or OneDrive for Business.

To get started, select the Insert tab from the Excel ribbon, and then select Store from Add-ins. Next, search for Microsoft Flow, and then select the Add button.

A screenshot of the add-in in the store

Add Microsoft Flow from the store

Once you have the Microsoft Flow add-in, you can select the Flow button on the Data tab. From the Microsoft Flow launch panel, build your flow by using the For a selected row trigger, or start from one of the templates:

  • For a selected row > send email
  • For a selected row > create an entity in Dynamics
  • For a selected row > send for approval
  • For a selected row > post a message to Teams
  • For a selected row > create a row in another spreadsheet
  • For a selected row > post a message to Twitter

After the flow is created, select a row, and then select the Play button to see your flow in action.

A screenshot of Excel, showing how to create a new on-demand flow

Create a new on-demand flow in Excel