Populate Excel

** AVAILABLE APRIL 2024 **

Overview

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

Populate Excel Syntax

Please refer to these articles providing detailed guidance and examples for configuring the input Excel workbook and JSON data: Template Syntax for Populate Excel

Default Parameters

The default 'Populate Excel' flow action parameters are detailed below:

  • File Content: The Microsoft Excel workbook (PPTX) to populate
  • JSON Data: The JSON data to populate the Microsoft Excel wookbook with

Please refer to the Obtaining the 'File Contents' Parameter article for guidance on how to obtain a 'File Content' parameter ready to provide to an Encodian flow action.

Advanced Parameters

The advanced 'Populate Excel' Power Automate action parameters are detailed below:

  • JSON Parse Mode: Sets the JSON parsing mode for simple values (null, boolean, number, integer, and string).
    • Standard: JSON simple values are determined upon parsing of their string representations. For example, '{ "example": "69" }' is determined as an integer in this mode.
    • Strict: JSON simple values are determined directly from the JSON notation. For example, '{ "example": "69" }' is determined as an string in this mode.
  • Calculate Workbook: Automatically calculate formulas upon population
  • Use Excel Data Types: When enabled data is added to the workbook using corresponding Excel data types as opposed to a string data type
  • Allow Missing Values: Sets the engine to allow missing values 'JSON Data'
  • Inline Errors: Produces errors within the resultant file as opposed to rejecting the request with a HTTP 4** error
  • Remove Empty Paragraphs: Sets the engine to automatically removes any empty paragraphs upon execution
  • Date Time Formats: Set one or more specific formats for parsing DateTime values
  • Culture Name: This setting is used to set the culture for the document prior to conversion. Please refer to the Culture Names article for a list of supported culture

Return Parameters

The 'Populate Excel' flow action returns the following data. 

Action Specific Return Values

  • File Content - The populated Excel file (Base64)

Standard Return Values

  • OperationId - The unique ID assigned to this operation.
  • HttpStatusCode - The HTTP Status code for the response.
  • HttpStatusMessage - The HTTP Status message for the response.
  • Errors - An array of error messages should an error occur.
  • Operation Status - Indicates whether the operation has completed, has been queued or has failed.
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk