web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Beautifying JSON strin...

Power Apps

Answered

Beautifying JSON string in powerapps

(0) Share

Report

Report

Posted on by Arthy_A26

15

Hi all,

Is there any way to beautify json string (it could be any json string) in powerapps

Example json string

[{"Cities":[{"City":"London","Population":8615000}],"Country":"United Kingdom"},{"Cities":[{"City":"Berlin","Population":3562000}],"Country":"Germany"}]

Expected Formatted string

[
{
"Cities":[
{
"City":"London",
"Population":8615000
}
],
"Country":"United Kingdom"
},
{
"Cities":[
{
"City":"Berlin",
"Population":3562000
}
],
"Country":"Germany"
}
]

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Arthy_A26 :

Please try this formula:

Substitute( Substitute( Substitute( Substitute( Substitute( TheJSONString, "[", "[" & Char(13) ), "}", Char(13) & "}" & Char(13) ), "{", "{" & Char(13) ), ",", "," & Char(13) ), "}" & Char(13) & ",", "}," )

I've made a test for your reference:

1\Add a text input control(TextInput1) and input the string you provided.

2\Add a label control and set it's Text property to:

Substitute( Substitute( Substitute( Substitute( Substitute( TextInput1.Text, "[", "[" & Char(13) ), "}", Char(13) & "}" & Char(13) ), "{", "{" & Char(13) ), ",", "," & Char(13) ), "}" & Char(13) & ",", "}," )

Best Regards,

Bof

Was this reply helpful? Yes No
PatilChetan on at

Like
a
(0)

Report
Copy link

Link copied!

@Arthy_A26

Refer the link: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-json#hierarchical-data

Regards,
Chetan

Was this reply helpful? Yes No

Join the conversation