Template Syntax Overview

The 'Populate Excel' Power Automate action enables you to populate a Microsoft Excel file (XLSX) with data derived from a JSON document.

Basic 'Populate Excel' Example

To use the 'Populate Excel' Power Automate action, you'll need to pass the following information:

  1. File Content: The Microsoft Excel (XLSX) to populate.
  2. JSON Data: The JSON data to populate the file with.

If you are not familiar with JSON we recommend the following resource: JSON Introduction

Consider the following simple JSON object:


Configuring an Excel file to receive this data is very simple, just simply use this syntax to add a 'token':


NB: the property / token name must start with a letter, not a number.

Example Slide: Encodian - Template Syntax.xlsx

Configuring Power Automate is also very simple, consider the following flow:

Upon executing the flow, the Encodian population engine will automatically detect all tokens which should be replaced with the data contained within the JSON data provided, see below:

Content Formatting

Example Slide: Encodian - Template Syntax - Formatting.pptx

The data added to the spreadsheet will automatically assume the formatting which has been applied to the token, for example:

Will generate the following output:

You must ensure the formatting is applied to the token and not the property inside the token, for example, the following will not work:

Have more questions? Submit a request


Please sign in to leave a comment.
Powered by Zendesk