Create excel template from sharepoint list

What is the JSON code to create template data for multiple sharepoint items?
The examples here show static data. How to write in JSON for accessing the dynamic content from sharepoint list items?

Hello @mljcw and thank you for the question.

MS Flow allows selecting a dynamic content in your JSON. So, firstly you get the items using standard SP action. On the next step, select the dynamic content in JSON like

“yourVariable”: select dynamic content from previous step here

Please give it a try and let me know if you have any further questions.

Best regards,
Petr Bushuev
Plumsail Team


Is there anyway of doing the above dynamically? I want to load in the whole JSON definition (from another file or Variable) with dynamic content from SharePoint included. For example, I can successfully paste the following into Template Data and all works fine.

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

But I want to load in the JSON above from a file or variable and I can't seem to get this to work.

Any ideas?