Unable to extract JSON array from JSON response from api

(0) Share

Report

Posted on by Kartik2 Microsoft Employee

Hi All, I need some help with Power Automate desktop. My flow is reading a json file. One of the property is an array. I want to extract the array and get it's length. We converted the json file to Custom object and then written the array property to a file, and noticed that all commas between the array elements have been removed.
Has someone faced this issue earlier or can help us?

The json looks like this:

[{ id:...

...

'Some ArrayName':['1':'........]

{ 'id':...

...

'Some ArrayName':['2':'........]

}

]

And we are trying to extract the length and contents of 'Some ArrayName'.

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-litu-msft on at

Like (0)

Report
Hi @Kartik2,

Could you please share an instance of the contents of 'Some ArrayName'?

It seems like an object so I am not sure length() function could work.

If you want to get content of "some arrayname", you could use expression + index to get them, for example:

output('Parse_Json')?[0]['Some ArrayName']
output('Parse_Json')?[1]['Some ArrayName']

Best Regards,
Community Support Team _ Lin Tu
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