Power Platform Community Forum Thread Details

I am attempting to populate tables in multiple identical excel templates (a different file for each client) with various different increments of data from two source workbooks.

This is something I have been attempting for a few weeks now and seem to be getting no closer. I have tried various methods but keep getting stuck along the way.

The empty table is my template - which I am having to populate with data from the attached sample of data file. As you can see, each different site has an inconsistent amount of rows of data, so I'm guessing I'm going to need to write some sort of JSON script which instructs the automation to begin populating the next file when the name in the 'Development' column becomes different from the previous one (I have written a formula which changes the name in the '0' cell to the first name in the 'Development' column.

It's important that I populate the template file as opposed to create a new file, as the template contains various bits that are integral to the finished product.

If anyone could offer some advice or point me in the right direction for how I can achieve this - I would be eternally grateful.