Struggling to get this to work when trying to create a new file. It works fine if I have an Excel template already set up. However when I try to create a new spreadsheet based on a template (so with the same Table name etc) I get errors.
Using "Get File Contest using path" and then "Create File" - both these work and a new file is created in the right place.
But my "Add a row into a table" does not
I am having to custom code the Table name - as it does not know it. But using the correct table name.
Getting this error
"status": 400,
"message": "A value must be provided for item.\r\nclientRequestId: 17006e0c-ce6e-4d34-a6d5-02cc6346b6ca",
"error": {
"message": "A value must be provided for item."
},
"source": "excelonline-ne.azconn-ne-003.p.azurewebsites.net"
}
I am stumped - based on Youtube video from @rezadorrani
