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.
