Power Platform Community Forum Thread Details

Hello,
I am trying to author what I thought would be a very simple flow. I want my customers to complete a simple table like this in an Excel template:

Template Table

Rights Holder	Fee
John	£5
Paul	£10
George	£15
Ringo	£20

And for that table to be used to populate another table in a separate Excel file like this:

Master Table

Column 1	Rights Holder	Column 3	Column 4	Column 5	Column 6
	John			£5
	Paul			£10
	George			£15
	Ringo			£20

The template table contains a different number of rows each time but I have been able to get Power Automate to create tables of different lengths dynamically when the template sheet is saved to the designated OneDrive location.

The problem I have is mainly around getting Power Automate to add multiple rows (ie ALL the rows) from the original table into the Master Table.

I am trying to use Apply to Each to add a row into the Master table for every row in the Template table. Power Automate is telling me that it expects an Array in order to ‘Apply to Each’.

Does this mean I need to convert the JSON output to an array that I can loop through until all the rows have been added? Or is there another kind of table format I should use?

Here is the relevant part of my flow.