Dynamically popluate JSON in Template Data

Documents
1

When using the Create XLSX/DOCX from Template Action in Flow, I'm trying to populate the Template Data with JSON held in a variable or JSON held in a SharePoint text field. The JSON needs to reference other dynamic content in the flow.

So as an example, I can succesfully paste into the action the following. All works fine.

"ProjectName": "@{body('Get_item')['Title']}"

But I want to load in the JSON above dynamically and I can't seem to get this to work. The "@{body('Get_item')['Title']}" does not seem to resolve via this route.

Any ideas?

2

Hello @elarifio,

Our Create XLSX/DOCX from Template Action accepts JSON held in a variable or you can combine static values and values from MS Flow dynamic content in a JSON. What do you mean "load in the JSON above dynamically"? Could you share screenshots with your flow and the content?

Best Regards,
Petr Bushuev
Plumsail Team