Convert JSON Object TO Array

(0) Share

Report

Posted on by Harbie

I have the JSON below......

{

"value": [

{

"Email": "adele@xxxxxxxxxx.onmicrosoft.com"

{

"Email": "sydney@xxxxxxxx.OnMicrosoft.com"

{

"Email": "admin@xxxxxxxxxx.onmicrosoft.com"

}

]

}

How can I get the array below from the JSON above?
[

"adele@m365x685435.onmicrosoft.com"

"sydney@M365x685435.OnMicrosoft.com"

"jons@m365x685435.onmicrosoft.com"

]

Categories:

Using flows

I have the same question (0)

All responses (14)

Answers (1)

Verified answer

v-alzhan-msft on at

Like (8)

Report
Hi @Harbie ,

You could refer to screenshot below as below:

The schema in the Parse JSON as below:

{ "type": "object", "properties": { "value": { "type": "array", "items": { "type": "object", "properties": { "Email": { "type": "string" } }, "required": [ "Email" ] } } } }

The flow would run successfully as below:

Best Regards,

Alice

Community Support Team _ Alice Zhang
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
Gyllentid 894 on at

Like (0)

Report

hi @v-alzhan-msft is there a way to retain the property names in the array we create?

From

{

"Question1":"Some text",

"Question2":"Some more text",

"Question3":"Additional text"

}

Into this:

[

"Question1":"Some text",

"Question2":"Some more text",

"Question3":"Additional text"

]

Was this reply helpful? Yes No
Gyllentid 894 on at

Like (2)

Report
I found a way for it.

split(replace(replace(string(outputs('ObjectName')),'{',''),'}',''),'","')

Was this reply helpful? Yes No
TsarCannon 7 on at

Like (0)

Report

Wow man!

Was this reply helpful? Yes No
TsarCannon 7 on at

Like (0)

Report

wow man! Gonna try rn

Was this reply helpful? Yes No
Hill 12 on at

Like (4)

Report
Hi
My favorite way is to use a select action like this:
From:
outputs('Compose_JSON_Array')?['value']

Map: you have to switch to text mode, delete the brackets etc. and enter the Expression
item()?['Email']

Like in the Picture:

This should result in this:

Was this reply helpful? Yes No
bruno9d 3 on at

Like (0)

Report

This is a much simpler and clever way I would say.

Also If you need an array for each step inside a loop in parallel mode (the problem that I was solving) you need to use this option instead of looping and appending to an array variable because the array will be filled in parallel and you will get messed up values since it's a global variable and in contrast the Select action outputs a context variable for each loop interaction that works fine.

Was this reply helpful? Yes No
mgisbert 71 on at

Like (0)

Report

I've done this and I realised the Append into array does not allow null values. How could this be done if some of the values coming from the JSON object can be null?
Thanks!

Was this reply helpful? Yes No
Hill 12 on at

Like (0)

Report

Hi mgisbert
Have you tried my way of using the select action?
For me this one seems to work even with null values

Was this reply helpful? Yes No
zapower 4 on at

Like (0)

Report

Before I create a new post, maybe someone here can help me.
I also try to convert JSON Object to Array, i tired a lot of different approaches but everything seems to fail.

Here my JSON:
{
"7ee5fb1d-fef6-483e-84e6-9b4d960f2d80": {
"last_changed": 1703081408,
"last_checked": 1704789923,
"last_error": false,
"title": "Keynote",
"url": "http://abc.de",
"viewed": true
},
"3022a04a-5248-4bc0-af78-39f0f48ae292": {
"last_changed": 1704119225,
"last_checked": 1705312960,
"last_error": false,
"title": "1Password",
"url": "http://abc.de",
"viewed": true
},
"5bd1d5b7-119a-4e90-862c-756b8e13c3fc": {
"last_changed": 1703082231,
"last_checked": 1705310059,
"last_error": false,
"title": "7-Zip",
"url": "http://abc.de",
"viewed": true
},
}

Thank you for any input.

Was this reply helpful? Yes No