Question 407415 in Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

Power Automate – Can't use Parse JSON Outputs

I’m trying to use Power Automate to obtain the employeeID field that is retrieved by Get user profile (V2) but not made available as a dynamic content. This method is outlined in the answer to this question.

I’ve created a flow as shown here:
screen capture of flow

For the Parse JSON block I’ve tried using the outputs of a Compose block or the User from Graph API output from Get user profile (V2). The individual data items captured in the Parse JSON schema show up as dynamic content in subsequent blocks.

However, I can’t seem to use actually use the outputs of Parse JSON. When I run the flow, the test screen clearly shows that Parse JSON worked as I see the correct data in the "Outputs" screen:
Output from Parse JSON Block

However, when I add any of those outputs via Dynamic Content to a subsequent block, the data appears to be empty. I’ve tried adding them to a Send an email (V2) block and to an Update Item block for a list (my original goal). In neither case do I get any actual data that Parse JSON processed.

Am I missing a step, or misunderstanding how Parse JSON works?

Tags:

2

Answers


  1. 0

    try accessing the data with a formula instead of dynamic content.

    body('YourParseJSONStepName')?['givenName']

    Login or Signup to reply.
  2. 0

    You can skip the Parse JSON step and go straight for the direct approach …

    Flow

    The expression in Compose Employee ID is …

    body('Get_user_profile_(V2)')?['employeeId']
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search