Fix Excel Custom Function #NAME? Errors in Power Automate Table Rows
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.

- 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.
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.
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.
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.
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.
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.
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.

Add recalculation time and verify the add-in automation environment
Use this option when you must temporarily retain the existing custom function while confirming whether it can run in the Excel Online session.
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.

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.




