JSON

(0) Share

Report

Posted on by yoshihirok

1,724

Issue: When create a text file include specifc text, Error.

How can I convert the text to JSON value?

Scenario:

Create a JSON text formatted text file on OneDrive.

Flow:

Error the Text1 include "

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-zhos-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @yoshihirok ,

I have made a test on my side, the flow can work successful.

Best Regards,

Community Support Team _ Zhongys

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

Was this reply helpful? Yes No
yoshihirok 1,724 on at

Like (0)

Report
Copy link

Link copied!
Hi @v-zhos-msft , thank you for your test.

But, I have the issue still.
When "Inputs" = Test , Ourput is OK.
{ "Text1": "Test" }
When "Inputs" = Test " Test , Output is BAD
{ "Text1": "Test " Test" }
The output is not escape as JSON.
I want Output
{ "Text1": "Test \" Test" }
So, I want to convert the text to JSON text

Was this reply helpful? Yes No
Verified answer

v-zhos-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @yoshihirok ,

Thanks for your feedback.

Now I understand your scenario clearly.

I am afraid you need format the text to Json first, then add the value into the file content.

However there is no action about converting the data to Json format.

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best Regards,

Community Support Team _ Zhongys

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

Was this reply helpful? Yes No
yoshihirok 1,724 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-zhos-msft , thank you again.

OK, I will submit my idea for this issue.

Regards,

Was this reply helpful? Yes No