Flow Template: Excel

PowerDoc supports replace data in cells and tables and hiding sheets.

In the PowerDoc Document Flow add a variable of type “object” and set as value as json object. The values can be hard coded or retrieved in one or more (Dataverse) actions before. The properties in the json object should refer to the correct sheet and cell or table. See tips & trics for usage value expressions.

Example:

The Excel template has 3 sheets (Company with some cells and Data with a table with the name Table1).

{
  "sheets": {
    "Company": {
      "cells": {
        "A2": "Contoso",
        "B2": 5.95,
        "C2": "2024-04-29T22:00:00.000Z"
      }
    },
    "Data": {
      "tables": {
        "Table1": [
          {
            "id": 1,
            "name": "Cars"
          },
          {
            "id": 2,
            "name": "Bicycles"
          }
        ]
      },
      "hide": true
    }
  }
}