Adding Rows to a Dynamic Excel File

[Anonymous]

Hi All,

I am creating a Power Automate flow with following requirement. 

Whenever a Microsoft form is submitted with set of responses, I need to capture response fields and insert to an Excel file. This Excel file is not a static file (Not an already available file in SharePoint or OneDrive). This Excel file will be a copy of a static base template file (Already available file in SharePoint or OneDrive). 

The problem I face is, when I set required fields of Add a row into a table activity it prompts with following error.

No table was found with the name 'Table1'.

But, when I check the file created there exists required table. This is not the case if I try to add the values into a table in an already available Excel file. 

Scenario 1 - Checking in an already available Excel file

Scenario 2 - In a dynamically created Excel file

The only difference I see here is the File field value. This field's value contains a forward slash (/) in Scenario -1 and no such forward slashes in Scenario - 2. I tried to insert a forward slash in setting the File field as well, it shows following error when I try to do it.

The parameter 'file' has an invalid value '/File-Name.xlsx'.

What am I doing wrong here? Any help would be highly appreciated.

[Anonymous · Accepted solution]

I was able to fix the error by setting File filed as below. (With Id of the file created - Not the name)

It is also worthy to note that we can use get tables activity to get the table name as well (instead of providing as Table1). 

[Anu_Gupta · Accepted solution]

Hello @Anonymous Yes, You can update the Excel table by passing the ID to the File Field in the Flow Actions, rather than going for the Name of it. This is as per the logic written.

[KarelVGH]

Since the Excel-connector has been updated (and therefore doens't allow body-entry), I found a great solution anno 2023 to solve this issue.

1. Take this worksheet/table as an example, I already know what the tableheaders are because it's a template that is duplicated in my flow:

2. You simply map the tableheaders inside a JSON object, then you add this object in the 'Row' parameter: