Easy Tech TutsHow to Trigger a Power Automate Flow From Excel Easily 2026
By Impran M N
Excel holds a lot of the data that business workflows depend on, but manually acting on that data wastes time. This guide shows how to connect Excel to Power Automate so changes in a workbook can kick off a flow automatically. You'll see the main ways to set up the trigger and how to pass Excel data into the automation that follows.
01Prepare your Excel workbook
Store your workbook in OneDrive or SharePoint and format the relevant data as an Excel table, since table-based triggers are the most reliable way for Power Automate to detect changes.
02Connect Excel to Power Automate
In Power Automate, choose a trigger built around Excel Online (Business), such as one that fires when a row is added or modified in your table.
03Configure the flow trigger
Point the trigger at the correct file location and table, and decide whether the flow should run on new rows, edited rows, or both.
04Pass Excel data into the flow
Use the dynamic content from the trigger to feed row values into subsequent actions, such as sending notifications, updating records, or generating reports.
05Test the automation with real data
Add or edit a row in the Excel table and confirm the flow runs as expected before relying on it for business processes.
Frequently asked questions
Does the Excel file need to be in OneDrive or SharePoint?
Yes, the file-based Excel triggers in Power Automate require the workbook to be stored in OneDrive for Business or SharePoint rather than a local drive.
Can I trigger a flow from a desktop Excel file?
Not directly from a purely local file. You would need to sync it to OneDrive or SharePoint, or use Office Scripts, for Power Automate to detect changes.
What's the difference between using Excel tables and Office Scripts?
Excel tables work well with row-based triggers for simple add or update scenarios, while Office Scripts give you more control when you need custom logic run against the workbook.
Can this automate approvals or reports?
Yes, once the flow is triggered by Excel data, you can chain in actions for approvals, notifications, or automated reporting based on that data.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
