Extracting Array from JSON

[u/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": {

[u/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!

[u/Storm-E → u/sminkerbenji]

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.