Showing results for 
Search instead for 
Did you mean: 
Advocate I
Advocate I

Status 415 - Unsupported Media Type when updating Excel row



When attempting to update a table in an existing Excel spreadsheet stored on SharePoint, I am able to successfully access the dynamic location of the file, create a table with headers. This being a dynamically placed document, meaning it's path will never be the same but filename will be, I am attempting to update the existing table range with one row of data using Update a Row. So far, my attempts have failed with the status 415; Unsupported media type. Has anyone else encountered and successfully done this? Do I need to convert the value into a different content-type before attempting to update the range?


Below is the Flow result:

"error": {
"code": "",
"message": "The request entity's media type 'text/plain' is not supported for this resource."
"debugInfo": "clientRequestId: 32b894f5-d04d-44d0-8ca7-93931b643964"
2020-03-20 23_08_03-Inbox - - Outlook (Unlicensed Product).png
Many thanks, in advance!
Super User
Super User


Just for troubleshooting purposes, I would replace temporarily the dynamic content from your 'Update a row' item entry and use a dummy static entry value and reexecute the flow. THis way you can figure out of the error came from assigning dynamic content to "File" input or to "item" input.


Please also note maybe there is a mismatch format between your item column and the dynamic content you are trying to assign to it. What is stored inside "Legal entry: M...", I mean which is its format? Integer, array, object, string...

You can easily inspect it by adding a dummy Compose action block before your Update a row, assign this same dynamic content as its input, then reexecute the flow


Each time you click on any of our inspiring answers 'Thumb up' icon... ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!

Escribo sobre Power Automate en:

Proud to be a Flownaut!

Community Support
Community Support


Hi @Alan_Sanchez ,


I am afraid that this requirement may not be achieved currently.

When we configure Excel connector related action, it is best to pick exist files and tables.


According to your descriptions, you want to dynamic configure Update a row action.

When you configure this action, the table does not yet exist. The table is created only after the above action is executed, so you cannot get the fields and configure them.


Please check the link and get known-issues-and-limitations about this connector:


Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I created a separate flow copying this one to test static paths and files and can confirm the update works using static methods. This included a compose to confirm the correct value is being pulled from the SharePoint list and passed to Update Row. I am also able to confirm the dynamic file and table is being accessed correctly.


Allow me to give more background on what it is I'm trying to do and that may help with this one.


I will be storing customer intake data in a SharePoint list. In certain scenarios, I need to send back a prepared template XLSX containing two tables: table 1) contains basic customer info taken from the Sharepoint list; call it a 'header' table, and table 2) headers only to be filled out by the customer.


My existing flow creates the Sharepoint list item, copies atemplate XLSX to a newly created customer folder stored on SharePoint. From here, it locates and accesses the newly copied filed before inserting basic customer info in the 'header' table, sourced from the Sharepoint list item created in an earlier step. The final step will be to take the prepared customer template and email it back to the customer.


Shifting gears a bit from the original 415 status code....


Due to this being a dynamic spreadsheet that could potentially be updated at the same time by two submissions, I am choosing to first copy the template to the customer file before updating it. In doing this, the filepath and table are both dynamically filled into the Update Row and/or Add Row to Table steps. In either scenario, however, I keep getting stuck at actually passing the data to be saved in the table.


I suspect the best approach to do this will be via an HTTP request via Sharepoint since the existing connector does not appear to support what I am trying to do. Unfortunately I new to using HTTP requests and are not yet sure how to get that to work. As far as I've come to understand from online reading and videos, I need to use Patch, point to the file in the URI, then send the data in the body. Would you agree with this approach and be able to offer some guidance on how this could be accomplished?


2020-03-23 05_21_28-Edit your flow _ Power Automate.png





Thanks for that link, I've been looking for documentation that explains what each field was looking for; I was stumped on Item.


Provide the item properties.

Provide the item properties.


So the Excel connector may be limited, but it sounds like an HTTP Request to SharePoint should be capable of such a dynamic edit. Recall from my previous post that despite the file patch changing each time, the workbook contents are identical every time. Therefore I would think if the table name and key ID are provided to the API, it should be able to make the change.


OMG I am truly sorry, I just thought 'File' was the name of an excel column

Let me look again into this

Sorry again

Each time you click on any of our inspiring answers 'Thumb up' icon... ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!

Escribo sobre Power Automate en:

Proud to be a Flownaut!

Hi again!

There are two posts from John Liu and Peter Veenstra that might help

Please note Extra tip #2, whch I believe is part of what you are looking for. It's a pity John did not explain it in detail

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon... ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!

Escribo sobre Power Automate en:

Proud to be a Flownaut!

Advocate I
Advocate I

I realise this was a while ago, but I didn't spot a solution online, so am adding this here.

This is definitely possible - I spent quite a while trying to get it to work, but it does work.

The problem is not with the dynamic file selection (file id attribute from SharePoint works fine).

The unsupported media type error is solved by sending a JSON record as the item properties for the update a row action.

So add a compose action before the update a row action, with the column name(s) and value(s) you want to update (excluded columns will be ignored):



"Column2": "<dynamic value here>"
"Column3": "<dynamic value here>"

Then use the output of the compose action as the value for "Provide the item properties"

Screenshot 2020-08-13 at 15.41.58.png


Works for me.

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,491)