Hi there
I am wanting to add row into a table by getting the excel file dynamically. There has been a bit on this and I wonder if it is still not possible.
IF create an excel file where the name of the worksheet and the table get the name from the GroupTitle. Lets say its called "Urawa2020" So my excel worksheet is Urawa2020.xlxs, the table is called Urawa2020.
I get the SP list with "get items" and use an ODATA filter for the "GroupTitle " .
Then I wish to "Add a row into a table" sheet using Dynamic content like the image below
I get the following error.
{
"error": {
"code": "",
"message": "The request entity's media type 'text/plain' is not supported for this resource."
},
"debugInfo": "clientRequestId: 73379038-6228-4daa-962a-ea11c7d42cd8"
}
Does this mean we cannot dynamically call excel files to Automate?