Others

How to Fix InvalidTemplate Error in Power Automate Create HTML Table

Huda Qurayshi Sep 30, 2026 868 views

Question details

The user is unable to run a Power Automate flow because the Create HTML Table action throws an InvalidTemplate error when using the output of a Filter Array.

How to Fix the InvalidTemplate Error in Power Automate Create HTML Table

Product: Power Automate
Device & OS: not provided
Scenario: Filtering an array of rows (usually from an Excel table) and passing the filtered data into a Create HTML Table action to format the results.
Observed behavior: The flow fails due to an InvalidTemplate error. The system auto-inserts the expression outputs('Filter_array')['body/value'], but the action only supports the 'body' property.

Before you start

Review your recent Power Automate flow run history to confirm that the error specifically points to the Create HTML Table action and note the exact expression causing the failure.

Solution 1Recommended

Correct the Filter Array Output Expression

Manually replace the auto-inserted, buggy expression with the correct property name to resolve the schema mismatch.

There is a known UI bug in Power Automate where selecting the dynamic content for a Filter Array output incorrectly appends '/value' to the body property. The Create HTML Table action does not recognize 'body/value', which triggers the InvalidTemplate error.

Open the Create HTML Table Action

Navigate to your flow in edit mode and click on the 'Create HTML Table' action card.

Remove the Invalid Dynamic Content

Delete the dynamic content pill that was automatically inserted into the 'From' field.

Enter the Correct Expression

Click the 'Expression' tab in the dynamic content menu and type exactly: outputs('Filter_array')['body']

Save and Test the Flow

Click 'OK' to apply the expression, save your Power Automate flow, and run a test to ensure the InvalidTemplate error is resolved.

Correct the Filter Array Output Expression

Solution 2

Use Item Expressions for Excel Columns

Prevent template errors when filtering by writing manual item expressions instead of picking raw Excel columns from dynamic content.

Free Microsoft Office alternative

Need a Simpler Way to Manage and Format Spreadsheets?

While Power Automate handles complex cloud automation, dealing with expression bugs can be frustrating. If you just need a reliable, lightweight tool to filter data and create formatted tables locally, WPS Office offers a free and highly compatible alternative to Microsoft Excel with a familiar interface.

1. Download the Installer: Visit the official WPS Office website and download the free application for your operating system.
2. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx files. All data and table structures will remain perfectly intact.
3. Filter and Format Locally: Use the intuitive ribbon menu to apply auto-filters, sort data, and instantly generate beautifully formatted tables without writing complex code.

Fully compatible with Microsoft Excel (.xlsx) file formatsFamiliar user interface for seamless migrationBuilt-in data filtering and quick table formatting toolsLightweight, fast, and completely free to download

microsoft office alternative - wps office

Frequently Asked Questions

What causes the InvalidTemplate error in Power Automate?

The InvalidTemplate error occurs when an action receives a data format or property that does not match its expected schema. In the case of Create HTML Table, it happens because it is fed an invalid property path like 'body/value' instead of a standard array.

Why does the Filter Array output automatically insert 'body/value'?

This is a known dynamic content bug within the Power Automate interface. When you click the output of a Filter Array, the UI incorrectly appends '/value' to the expression, which you must manually correct.

How do I reference an Excel column name containing spaces in an expression?

You can reference it by placing the exact name inside single quotes within the item expression. For example, if your column is named 'Order Date', you should write: item()?['Order Date'].

Can I test my Power Automate expressions before running the full flow?

Yes, you can use the 'Test' button in the upper right corner of the Power Automate editor to run the flow using data from a previous run. This allows you to quickly verify if your newly typed expression resolves the InvalidTemplate error.

Office Quick Solutions