Add a row into a table (Text/plain not supported)

(0) Share

Report

Posted on by tobiagioachino

Hi guys,

I'm building a flow which reads some data from a Sharepoint task list and then saves these data in a string which is converted into JSON format using "Compose". The second step is to save these rows in an Excel (For Business). So I have a delay trigger and then I use "Add a row into a table" in order to save these information. Unfortunately, this flow ends soon saying that "The request entity's media type 'text/plain' is not supported for this resource".

Does anybody know how to solve it?

Thank you.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

JamesDix_n 203 on at

Like (0)

Report

Hi there, it looks like others may have experienced this issue as below:
Add row to excel (Business) - Power Platform Community (microsoft.com)

Perhaps check your JSON syntax and excel column header names? I hope you are able to find a solution.

Was this reply helpful? Yes No
tobiagioachino 6 on at

Like (0)

Report

Thank you for the answer. I saw it before posting. Unfortunately, that solution doesn't fix my issue. Do you have any other ideas?

Was this reply helpful? Yes No
JamesDix_n 203 on at

Like (0)

Report

Sorry to hear that, please could post a screenshot of your flow in its current state?

Was this reply helpful? Yes No
tobiagioachino 6 on at

Like (1)

Report

Flow_2.PNG

Flow_1.PNG

Was this reply helpful? Yes No
JamesDix_n 203 on at

Like (0)

Report

Thank you - what does your 'Compose' syntax look like in your Flow_2 image as from you mentioned in your earlier post it sounded like the Flow was failing here?

Was this reply helpful? Yes No
CU20030332-0 on at

Like (0)

Report

Response?

Was this reply helpful? Yes No
Suggested answer

GezD 2 on at

Like (0)

Report

Hi,

I assume this has been solved, but for others who come across this issue.

I also had the same problem, running an Excel 'Add a row into a table' and getting
"The request entity's media type 'text/plain' is not supported for this resource"

In troubleshooting i cam across this post:
https://learn.microsoft.com/en-us/answers/questions/1181699/when-i-try-to-create-a-subscription-for-notificati

and it reminded me that the Row value expects a JSON input, not text. i updated my Row to a JSON structure:

and it worked as expected.

1 people found this reply helpful.

Was this reply helpful? Yes No
rzaneti 4,249 Super User 2025 Season 2 on at

Like (0)

Report

Hi @tobiagioachino,

Assuming that you're simply taking the Row variable and trying to transform it into a JSON, in a later Compose, the error seems to be the lack of curly brackets in the JSON string. Once you have it in place, Compose will be able to convert it to a JSON object.

Was this reply helpful? Yes No