Dynamically get an excel file

(0) Share

Report

Posted on by StuCundy

377

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?

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-bacao-msft on at

Like (0)

Report

Hi @StuCundy ,

Please check the limitations of Excel connector in this link:

https://docs.microsoft.com/en-gb/connectors/excelonlinebusiness/#known-issues-and-limitations

We should fill File’s id or File identifier in the File field if you want to configure this field manually instead of pick file from the file picker.

Best Regards,

Was this reply helpful? Yes No