Power Automate: Automatically process new Excel rows

Many data and BI teams work with Excel files as a source for analyses and reports. Automatically processing new rows in Excel with Power Automate saves time and prevents errors. In this article you’ll learn how to create a Power Automate flow that detects new rows in an Excel file and immediately uses this data in your workflow. This is relevant for teams that want to automate their data entry and respond faster to new information.

What you need

• An Excel file with a table where new rows are added

• The table must contain a unique column (for example an ID or timestamp)

• Power Automate connector for Excel (OneDrive or SharePoint location)

• A clearly defined trigger, such as “When a row is added”

Step 1: Set up a trigger for new Excel rows

The first step is setting up a trigger that starts the flow as soon as a new row is added to your Excel table. This is important to respond to new data in real time or periodically.

Use the “When a row is added” trigger from the Excel Online (Business) connector. Select the correct location, document library, file, and table name. This trigger automatically retrieves the data from the newly added row.

Step 2: Use data from the new row in the flow

After the trigger you can use the column values of the new row in subsequent actions. For example to send an email, create an item in SharePoint, or process data in another application.

Use dynamic content from the trigger, such as column names, to select the correct values. For example, if you have a “Customer name” column, add it to the email message or in another action.

Step 3: Test and optimise the flow

Test your flow by adding a new row to the Excel file. Check whether the flow starts correctly and the actions are performed with the correct data. Optionally optimise by adding error handling or building in extra checks, such as checking for empty fields.

Tips & common mistakes

• Tip: Make sure your Excel table has a clear name and unique columns for reliable triggers.

• Mistake: Do not use Excel files that are edited simultaneously by multiple users without version control, as this can cause flow errors.

• Tip: Use the Power Automate portal to manage and monitor your flow clearly.

Example / mini use case

Suppose you have an Excel file with a table where sales staff enter new orders daily. With this flow an email is automatically sent to the responsible manager as soon as a new order is added, including all relevant order data. This keeps the team immediately informed without manual actions.

Conclusion

With this practical Power Automate approach you easily automate the processing of new Excel rows and improve the efficiency of your data workflows. For creating and managing flows, set this up via the Power Automate portal.

Our tip: Make sure the Excel file is closed when the flow is active and writing data. An open file can block write access and leads to error messages in the flow. Preferably use SharePoint as the storage location, as this is better suited for simultaneous access by multiple users.