Function Problems

Fix Excel Custom Function #NAME? Errors in Power Automate Table Rows

Muhammad TalhaMuhammad Talha Nov 12, 2026 870 views

Question details

The user needs to troubleshoot an Excel Office Add-in custom function that calculates in Excel but returns #NAME? when Power Automate retrieves a newly added table row.

Fix Excel Custom Function #NAME? Errors in Power Automate Table Rows
Product
Microsoft Excel Online and Power Automate
Device & OS
not provided
Scenario
A flow adds or reads a row in an Excel table, and a column uses a custom function supplied by an Office Add-in.
Observed behavior
The custom function works in an interactive Excel session but is unavailable or has not recalculated in the Excel Online session used by Power Automate, causing #NAME? in the retrieved row.
Before you start

Confirm that the affected cells are inside the Excel table and identify whether the formula uses an Office Add-in custom function rather than a built-in Excel function. Test the same workbook through Excel for the web, because Power Automate uses the Excel Online connector environment.

Solution 1Recommended

Replace the add-in custom function with a supported Excel formula or Office Script

Use this option when the flow must return a reliable calculated value without depending on an Office Add-in session.

Power Automate and the Excel Online connector may not load the Office Add-in that provides a custom function. Built-in Excel formulas and Office Scripts are more suitable for unattended flow processing.

1
Identify the custom function column

Open the workbook in Excel and select a cell showing the custom formula, such as =CONTOSO.MYFUNCTION([@Value]), to identify the calculation that must be replaced.

2
Use a built-in formula where possible

Select the table column, enter an equivalent built-in Excel formula using functions such as IF, XLOOKUP, TEXT, or SUMIFS, and allow Excel to fill the formula down the table.

3
Create an Office Script for unsupported logic

In Excel for the web, open the Automate tab and select New Script. Add script logic that reads the new row, calculates the required value, and writes the result to the target table column.

4
Run the script from the flow

In Power Automate, add the Excel Online (Business) action Run script after the row is added, select the workbook and script, then use Get a row present in a table only after the script finishes.

Replace the add-in custom function with a supported Excel formula or Office Script
Custom functions require their add-in: A custom function can show #NAME? whenever the add-in that defines it is not loaded in the Excel Online automation session.
Free Microsoft Office alternative

Use WPS Office for Everyday Excel-Compatible Workbook Editing

Power Automate and Excel Office Add-in custom functions depend on Microsoft cloud automation services, so WPS Office cannot repair add-in availability in that environment. For everyday spreadsheet creation and editing, WPS Office is a free, lightweight alternative with a familiar interface and straightforward migration for compatible workbook files.

Edit worksheets, tables, and standard spreadsheet formulas in a familiar interface.Open and save Microsoft Excel .xlsx and .xls files with broad format compatibility.Use built-in spreadsheet functions for portable calculations that do not rely on a cloud add-in session.Move existing workbook files into a lightweight office suite with minimal workflow disruption.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel custom function work in the desktop app but show #NAME? in Power Automate?

The function is supplied by an Office Add-in, and the Excel Online session used by the Power Automate connector may not load or support that add-in. Excel then cannot recognize the function name and returns #NAME?.

Will adding a Delay action fix a #NAME? error in a Power Automate flow?

A Delay action can help if Excel needs time to save or recalculate supported formulas. It will not fix #NAME? when the custom-function add-in is unavailable in the Excel Online automation environment.

What should I use instead of an Office Add-in custom function in an automated workbook?

Use a built-in Excel formula when the calculation can be expressed with standard functions. For more complex processing, create an Office Script from Excel for the web's Automate tab and run it with the Run script action in Power Automate.

Can Power Automate force Excel Online to load my custom-function add-in?

No standard Excel Online (Business) connector action guarantees that an Office Add-in custom function will load for a flow. Verify add-in support in Excel for the web and redesign the automation around supported formulas or Office Scripts if needed.

How do I make sure Power Automate reads the calculated result instead of the formula error?

Add the table row first, run an Office Script or allow a short Delay for supported calculations, and then place Get a row present in a table after that action. Use a unique key column to retrieve the intended row.