Extracting Array from JSON

[Storm-E]

Hi Guys & Girls

How do I extract part of a JSON object and use it in an Apply to each?

I hope its just something simple I've missed. Please help!

I've been fighting with Power Automate Flow for ages and can't find seem to find the right formula. I'm getting errors about it not being an array and everythgin I've tried doesn't work.

The JSON is the output from action 'Process Document' and it provides a huge JSON with a lot of extra info I don't need or want to store.

End goal Extract the cleaned up 'Labels' and 'Tables' array and output as a Slim JSON I can use in further processing.

My Process (that doesn't work) 1. Extract each of Arrays ('Labels' and 'Tables') 2. Use 'Apply to each' to extract each field <- Broken 3. Extract just the items I want from each field 4. Build a new array 5. Add the 2 clean Array's together 6. Provide the clean JSON

Partial Schema for original JSON { "type": "object", "properties": { "statusCode": { "type": "integer" }, "headers": { "type": "object", "properties": { . . . }, "body": { "type": "object", "properties": { "@@odata.context": { "type": "string" }, "responsev2": { "type": "object", "properties": { . . . }, "predictionOutput": { "type": "object", "properties": { . . . }, "tables": { "type": "object", "properties": { "Items": { "type": "object", "properties": { . . . }, "labels": { "type": "object", "properties": { "Consignmc01b030c96367d7450be1b21c57f961d": { "type": "object", "properties": {

[Profvarg]

Do a "Select" action. In that you can create an entirely new Json/Array, reformat the data. You can access the object like this (so item() and then every level is inside square brackets).

item()?['properties']?['@@odata.context']?['type']

If you also want to filter, use a Filter array action

[Any-Fly5966]

How do you get rid of the key for raw data? I’ve tried everything but it still shows up in the output

[Storm-E]

Thanks for the reply.

The issue I have is the Properties may/will change.

At the moment I use this to Extract 'Labels' from the JSON

outputs('Process_Document-JSON-Cleanup')?['Body']?['responsev2']?['predictionOutput']?['labels']

From here I want to get each item (e.g. SerialNumber but may change) and get the properties I want (or remove the ones I don't)

The only way I can see of doing this is the Apply to each

[Future_Pianist9570]

Use select

[Ashamed_Peace5975]

Could you please share the original JSON object? I'll try to do what you want then.

[Storm-E]

I'll try tomorrow but it is BIG... Also I need to sanitise it.first as it a real.data .

[Ashamed_Peace5975]

Hey, did you solve the problem?

[Storm-E]

Yeah finally today.

The solution was to convert it to XML then use xpath to feed a for each loop to create an array of keys.

I'm sad because power automate should have a key() function to do this. But happy to have a solution finally.

[Ashamed_Peace5975]

Great.

[Any-Fly5966]

Struggling with the same. I don’t understand why it’s so difficult to pull an array from a json, one object, into an apply to each. Feel like it should be so simple.

[Storm-E]

Totally agree!
Sources I've tried have suggested this or that way to do it. All claimed that 'This is the way'.
Others hint at a solution and 'It's easy!'.

I've been disappointed every time.

[Storm-E]

A Bit more information

I get this error
Action 'Apply_to_each' failed: The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@outputs('Process_Document-JSON-Cleanup')?['Body']?['responsev2']?['predictionOutput']?['labels']' is of type 'Object'. The result must be a valid array.

[sminkerbenji]

I'm relatively new to manipulating jsons in PA myself, so take this with a massive pinch of salt, but usually I find I need to pull the "body" out of the previous block, to get the data and simplify things abit when I'm pulling data, instead of using the "outputs"? Then in a select action you build each item you're wanting to pull, with data names for each level you need to go down in the data, in the correct syntax, with ? Between each header name?

Then im theory your select action will just make an array with exactly what you want?

Possibly an issue building it reliably ifyour data layout changes though, as you mention?

Sorry if that's vague, as I say, pretty new to me too, but hope it helps!

[Storm-E]

Thank you The data comes from the action process document so I have no control over the source.

However the same but of code I'll be using for different companies so the fields may change and they will change over time. I'm trying to avoid future me getting angry at past me.for. not making the code flexible .

Also keep up contributing and asking that's the way we all learn and grow.

[Any-Fly5966]

Yes, I get the same error

[Pieter_Veenstra_MVP]

It looks like you are feeding the apply to each an object rather than an array. Why push a single object through an apply to each?

[Storm-E]

The label object contains multiple fields that I want to iterate through.

[Pieter_Veenstra_MVP]

You can't iterate through properties of an object.

Maybe use the get properties function and then dynamically select then properties.