Chart & Visualization Issues

Fix Power Automate Errors Exporting Multiple Excel Charts via Office Scripts

Olivia Miller Oct 1, 2026 868 views

Question details

The user needs to export multiple Excel charts as images to a Word template using Office Scripts and Power Automate, but encounters execution errors when attempting to process a second chart.

How to Export Multiple Excel Charts Using Office Scripts and Power Automate

Product: Microsoft Excel, Power Automate
Device & OS: not provided
Scenario: Automating document generation by extracting multiple chart images from an Excel workbook and inserting them into a Word template via Power Automate.
Observed behavior: The automation successfully exports the first chart image, but returning and processing a second chart within the same script causes workflow errors.

Before you start

Ensure that your Office Script is saved in Excel on the web and that your Power Automate flow has the appropriate permissions to read from the target Excel workbook.

Solution 1Recommended

Use an Array to Return Multiple Chart Images

Consolidate the exported chart images into a single array within your Office Script so Power Automate can process them sequentially.

Office Scripts can only return a single final output object to Power Automate. If you attempt to return multiple standalone image variables, the flow will fail to parse the output correctly. Storing the base64 image strings in a single JavaScript array solves this issue.

Edit your Office Script

Open Excel on the web, navigate to the 'Automate' tab, and open the Code Editor for your existing Office Script.

Update the return statement

Modify your script to store the images in an array. For example: `function main(workbook: ExcelScript.Workbook) { const sheet = workbook.getWorksheet("Sheet1"); const charts = sheet.getCharts(); return [charts[0].getImage(), charts[1].getImage()]; }`

Update Power Automate inputs

In your Power Automate flow, update the subsequent actions to expect an array instead of a single string. Pass the returned array into an 'Apply to each' loop.

Process each image separately

Inside the 'Apply to each' loop, add your 'Populate a Microsoft Word template' action to handle each image dynamically based on the current item in the iteration.

Use an Array to Return Multiple Chart Images

Verify Chart Existence: Confirm that both charts (e.g., charts[0] and charts[1]) actually exist in the specified worksheet before calling getImage() to prevent runtime 'index out of bounds' errors.

Free Microsoft Office alternative

Looking for a Free, Lightweight Alternative to Microsoft Excel?

If you are managing complex datasets, reports, and charts but prefer a highly compatible and cost-effective solution, WPS Office provides robust spreadsheet capabilities without the heavy subscription fees.

1. Download WPS Office: Install WPS Office for free from the official website and launch WPS Spreadsheet.
2. Open Your Workbooks: Open your existing .xlsx files directly; all your original charts, data, and formatting remain intact.
3. Export and Share Easily: Use the built-in 'Export to Picture' or 'Export to PDF' features to quickly share your charts without needing complex external automation flows.

Fully compatible with Microsoft Excel (.xlsx, .xls) files and chart formats.Rich built-in data visualization tools and chart templates for quick reporting.Extremely lightweight software that runs smoothly on Windows, Mac, and Linux.Free to use with a familiar user interface, ensuring a zero-learning-curve migration.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Automate fail when I return multiple single chart images?

Office Scripts are designed to return one primary output object. Attempting to return multiple independent output definitions conflicts with the schema Power Automate expects. Grouping them into a single array ensures the flow receives a valid, single JSON array object.

How do I handle a variable number of charts in the Office Script?

Instead of hardcoding indices (like charts[0] and charts[1]), you can use a loop or the .map() method in your script to iterate over the entire array returned by sheet.getCharts() and dynamically extract all available images.

Why are my extracted Excel charts returning as blank images?

This can happen if the script executes before dynamic data connections have refreshed or finished rendering the chart. Adding a brief delay in your flow or ensuring data connections are fully resolved before running the script usually resolves this.

Can I export these chart images to a PDF instead of a Word document?

Yes. Once you pass the array of base64 images to Power Automate, you can use HTML to Word or directly use HTML to PDF conversion connectors to generate a PDF containing all the charts.

Excel & Data Problems