Power Automate

Parse JSON output not available

(1) Share

Report

Posted on by Lisa Peoples

Hello,

I'm want to extract a value called "id" from my JSON output.

The output is not available to the Select node.

I've seen other people with this problem and seen suggestions to reference the array even though it's not visible.

Would you mind suggesting

1. Why I can't see my output (I've deleted and saved tried again a few times)

or 2. How to reference the array and item I need.

Thank you!

Lisa.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Vish WR 3,162 on at

Like (0)

Report
Copy link

Link copied!

@Lisa Peoples

Use a Compose Action: Put a Compose right after your HTTP request and drop the body/items into it.

This makes the data easier for the designer to "see."

Update Your Schema: Run the flow once

Copy the raw output from that Compose action

Paste it into the "Use sample payload" box in your Parse JSON step.

Was this reply helpful? Yes No
Suggested answer

Haque 3,197 on at

Like (1)

Report
Copy link

Link copied!
Hi @Lisa,

(1) An expression can be used to explicitly point to the array inside the JSON output, even if it’s not visible in dynamic content. For example, if your JSON output is in an action called Parse_JSON, and the array is inside body.value, you can reference it like this in the Select action’s From field:
outputs('Parse_JSON')?['body']?['value']

Then, in the Select action Map field, to extract the "id" from each item, use:
item()?['id']

(2): If your JSON structure is different, adjust the path accordingly. For example, if the array is under body.data.items, use:
outputs('Parse_JSON')?['body']?['data']?['items']

(3) To check the exact path, look at the raw output of the previous action in the flow run history.

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No
André Arnaud de Cal... 629 on at

Like (0)

Report
Copy link

Link copied!

Hi Lisa,

Vish and Haque provided the correct options to solve your challenge. You can either use a compose action or use the expressions.
Now trying to answer your 'why' question. Both options are letting Power Automate flow know your JSON structure. When designing your flow, Power Automate is not aware of the exact JSON format. Using a compose or expression, this is the point in time where the flow will be aware of your JSON structure.

Other actions like list rows in a Dataverse table knows about the format as the Dataverse connector can read the table metadata.

Was this reply helpful? Yes No