Others

How to Add an Excel Table Total Row with Power Automate

Adam Davis Oct 15, 2026 870 views

Question details

The user needs to add a total row to an Excel table and sum specific columns using Microsoft Power Automate.

How to Add an Excel Table Total Row with Power Automate

Product: Microsoft Excel, Power Automate
Device & OS: not provided
Scenario: Automating the addition of a total row and calculating sums for selected columns in an Excel table via a cloud flow.
Observed behavior: Seeking the correct logic, Office Scripts, or flow actions to successfully automate this table summary task.

Before you start

Ensure your Excel file is saved in OneDrive for Business or SharePoint so Power Automate can access it, and verify your data is properly formatted as an official Excel Table.

Solution 1Recommended

Use an Office Script with Power Automate

Since standard Power Automate actions do not directly toggle a total row, combining the flow with a custom Office Script is the most effective approach.

Power Automate's native Excel connectors primarily handle adding, updating, or deleting rows. To manipulate table properties like the Total Row, you must write a script in Excel on the web and trigger it from your flow.

Create the Office Script

Open your workbook in Excel on the web, navigate to the Automate tab, and select New Script. Write a TypeScript snippet to toggle the total row on your target table.

Set up your Power Automate flow

Log into Power Automate, create a new flow with your desired trigger, and add a new action.

Add the Run Script action

Search for the 'Excel Online (Business)' connector and select the 'Run script' action.

Configure the script execution

Select the location, document library, and file path of your Excel workbook, then choose the script you created in the first step to run automatically.

Use an Office Script with Power Automate

Scripting Requirement: You will need basic TypeScript knowledge to configure the Office Script to sum the exact columns you need before passing the automation to Power Automate.

Solution 2

Consult the Microsoft Power Automate Community

If your flow requires complex dynamic ranges or advanced logic, seek help from dedicated automation experts and Microsoft engineers.

Free Microsoft Office alternative

Need a simpler way to manage spreadsheets? Try WPS Office

While Power Automate handles complex cloud workflows for Microsoft Office, WPS Office offers a lightweight, free alternative for everyday spreadsheet tasks. Easily manage data, toggle total rows instantly, and enjoy high compatibility with Microsoft Excel formats without the heavy subscription fees.

1. Download WPS Office: Install WPS Office for free from the official website and open WPS Spreadsheet.
2. Open your Excel file: Open your existing .xlsx or .xls file directly in WPS Spreadsheet with full formatting preserved.
3. Enable the Total Row: Select your table, navigate to the Table Tools tab, and check the 'Total Row' box to instantly sum your columns.

Highly compatible with Microsoft Excel (.xlsx, .xls) formats.Built-in one-click Total Row feature for easy data summarization.Free, lightweight, and fast to launch on any operating system.Familiar user interface makes switching completely seamless.

microsoft office alternative - wps office

Frequently Asked Questions

Can Power Automate natively add a Total Row without Office Scripts?

Currently, standard Excel Online actions in Power Automate do not have a direct toggle for the Total Row. You typically need to use the 'Run script' action with a custom Office Script to modify structural table properties.

How do I create an Office Script to sum columns?

Open Excel on the web, go to the Automate tab, and select New Script. You can write TypeScript code to get the table object, toggle the total row, and set the summary function (like SUM or AVERAGE) for specific columns.

Where can I find my Power Automate run history to debug my Excel flow?

In Power Automate, go to 'My flows', select your specific flow, and check the '28-day run history' section to see detailed inputs and outputs for your Excel actions and script executions.

Office Quick Solutions