Pdf from html-Template remains blank in Power-Automate-flow

I created a Flow to selecet data from an Excel-Sheet (on sharepoint) and pass the result to a document generation process to create a pdf-file. The document generation process is based on an html-file.

Process works when testing it on plumsail (via from), given data fill placeholders. When used in the powerautomate flow, the pdf file brings all template details but does not fill the placeholders with data from Excel-Sheet.
Extraction from Excel-Sheet works as I use this data later in the process to automatically send an E-Mail. Entire process is claimed to be sucessful in power-automate.

What I have tried so far:

  1. Copy the process in plumsail and renew connection to power-automate.
  2. Create a new process in plumsail and renew connection to power-automate.
  3. Create a new api connection.
  4. Tested in "active" as well as in "testing" mode.

json-Content for input looks ok to me:

{
    "host": {
        "connectionReferenceName": "shared_plumsail_1",
        "operationId": "FlowV1ProcessesFlowJobsExecuteProcessWithGeneratedDataPost"
    },
    "parameters": {
        "processId": "1nwqqjs",
        "data/jsonContent": [
            {
                "Vorname": "Joost",
                "Nachname": "Hartwig",
                "StraƟe": "SchleiermacherstraƟe",
                "Hausnummer": "12",
                "PLZ": "64283",
                "Stadt": "Darmstadt",
                "Datum": "Test",
                "Bearbeiter": "Test",
                "Anmeldedatum": "44927",
                "Lehrgang": "Energieberatung WohngebƤude - Basis und Vertiefung"
            }
        ]
    }
}

Json-Content for output looks like this:

{
    "statusCode": 200,
    "headers": {
        "referrer-policy": "strict-origin-when-cross-origin",
        "Date": "Thu, 05 Jan 2023 10:28:16 GMT",
        "Content-Length": "69469",
        "content-disposition": "attachment; filename=Teilnahmebescheinigung-2.pdf; filename*=UTF-8''Teilnahmebescheinigung-2.pdf",
        "Content-Type": "application/pdf"
    },
    "body": {
        "$content-type": "application/pdf",
        "$content": "Content omitted - to long"
}
}

Im not sure about the status code "200".
Thank you for any ideas or advice.

Ok, found a solution: Use the "Start document generation process with json" process and "body" from the Excel-Data and it works.

1 Like