Add rows to an excel table - Error

[kevinsa]

Hi folks, 

I'm building a flow that will essentially take data from a SQL server (using Get Rows V2) and populate an existing Excel file with a table. 

I'm having issues trying to get the output from SQL to populate the excel table. One part I have a feeling could be contributing to this problem is I want to use a friendly column name vs. what I currently have in SQL but I don't know what else could be missing. Does anyone have some thoughts how I could accomplish this? I'm interested in using this existing spreadsheet and pre-formatted table to allow our team to quickly print as needed. 

Thanks

[Mira_Ghaly]

@kevinsa 

If my understanding to your problem is correct; then it means you have an excel formatted as a table, so if I am correct you need to add and Apply to each loop to the output of Get Rows and then use Add Row in a table action as below:

[kevinsa]

Hi @Mira_Ghaly 

Glad I was on the right track. I've added the apply to Each control, and this is the error I am being returned:

Everything up to that point looks good. I'm using the output from Select to add the rows into the Excel Table. 

[Mira_Ghaly]

@kevinsa 

Can you please share where are you getting the error exactly?

[kevinsa]

@Mira_Ghaly , that error is being thrown on Add Row into a Table

[Mira_Ghaly]

@kevinsa 

What is the value you are using here?

[kevinsa]

@Mira_Ghaly ,

I'm following the guide here:

Power Automate – Excel Dynamic Filename – Flow Alt Delete – Josh Cook [Microsoft MVP]

Since I need to use a pre-formatted table, I can't just create a table in a new file within the flow. That value in 'Table' is first(outputs('Get_tables')?['body/value'])['id'], where after the file is copied to Sharepoint I'm using an HTTP request to get the file ID to use in Get Tables in a previous action.