Microsoft forms output with " in the message

(0) Share

Report

Posted on by Sjon

All,

Simple question:

We have a form that goes into Excel and in an HTTP request email. But every time someone uses the "quotation marks" the flow stops at the http request. The error is saying Unable to read JSON request payload. Please ensure Content-Type header is set and payload is of valid JSON format.

So can somebody explain me why the " text" is not working?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Rhiassuring 8,690 Moderator on at

Like (0)

Report
Copy link

Link copied!

Because it thinks it's another passed value that's missing a key, I think.

Here's the same issue as yours:

https://powerusers.microsoft.com/t5/Building-Flows/Double-Quotes/td-p/569666

There are two ways to solve it - either remove the quotes entirely using replace, or, replace them with escaped quotes, as shown here:

Was this reply helpful? Yes No
Sjon 29 on at

Like (1)

Report
Copy link

Link copied!

I will add this in the flow, for the meant time nobody is aloud to use the "" for the time being.
Still i find it weird that a input (plain text) can screw up it so easily.

Was this reply helpful? Yes No