Fill copied Excel file with CSV or JSON content

Fill copied Excel file with CSV or JSON contentFollow
Fabian Heil
Fabian HeilMay 31, 2022 04:00 AM
Hi, i want to fill an excel template with content coming from a PowerApp. I have an Excel template …
1. Fill copied Excel file with CSV or JSON content

Fabian Heil
Posted May 31, 2022 04:00 AM
Hi,

i want to fill an excel template with content coming from a PowerApp.
I have an Excel template with a formatted table and the column headers.
When starting the workflow, i hand over a collection in JSON structure.

So, i copy the template file and want to fill this copy with the data. But when i add the action “add row into a table”, i need to define the file and table name dynamically.
So, it cannot show the single columns of the file. It only shows a field “row”.

What structure is expected in the field “Row”?
How can i fill a json structure into a copied excel file?

——————————
Fabian Heil
——————————

2. RE: Fill copied Excel file with CSV or JSON content

Top Contributor
Will Page
Posted Jun 01, 2022 12:27 AM
Edited by Will Page Jun 01, 2022 12:30 AM
Try specifying the template file, configuring the columns then changing the file identifier back to your dynamic content.

If that doesn’t work, you could specify the template, then after the file is populated, copy it then roll the template back to previous version using SharePoint API

You could also try doing get file content, then populate the template, copy it then update file content using the output of the get file content from earlier.

Remember to add a 2 minute delay after updating the excel file before copying it. There’s a delay between adding rows and seeing them in the file.

——————————
Will Page
Technical consultant
Christchurch, NZ
——————————