web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Parse JSON returns nul...
Power Automate
Unanswered

Parse JSON returns null property

(0) ShareShare
ReportReport
Posted on by 62

I have below output from an action and I would like to get the "invitee id" however when I parsed the output and used property "invitee id", it always returns null value. Any help is greatly appreciated.

 

{
"count": 1,
"results": [
{
"key": "account_invitations",
"id": "91103855"
}
],
"account_invitations": {
"91103855": {
"full_name": "",
"email_address": "",
"headline": null,
"pending": true,
"permission": "collaborator",
"bill_rate_in_cents": null,
"cost_rate_in_cents": null,
"billability_target": null,
"inviter_id": "11912195",
"invitee_id": "12104185",
"default_role_id": null,
"id": "91103855"
}
},
"meta": {
"count": 1,
"page_count": 1,
"page_number": 1,
"page_size": 20
}
}
Categories:
I have the same question (0)
  • yashag2255 Profile Picture
    24,769 Super User 2024 Season 1 on at

    Hi @kenneth0596 

     

    Can you share a screenshot of the flow configuration? How are you creating the Parse Json Schema? 

     

    I just run a small test on my side and it worked fine. fas.PNG

     

    I just copied the output you posted in the sample payload. 

     

    Schema: 

    Spoiler (Highlight to read)
    {
    "type": "object",
    "properties": {
    "count": {
    "type": "integer"
    },
    "results": {
    "type": "array",
    "items": {
    "type": "object",
    "properties": {
    "key": {
    "type": "string"
    },
    "id": {
    "type": "string"
    }
    },
    "required": [
    "key",
    "id"
    ]
    }
    },
    "account_invitations": {
    "type": "object",
    "properties": {
    "91103855": {
    "type": "object",
    "properties": {
    "full_name": {
    "type": "string"
    },
    "email_address": {
    "type": "string"
    },
    "headline": {},
    "pending": {
    "type": "boolean"
    },
    "permission": {
    "type": "string"
    },
    "bill_rate_in_cents": {},
    "cost_rate_in_cents": {},
    "billability_target": {},
    "inviter_id": {
    "type": "string"
    },
    "invitee_id": {
    "type": "string"
    },
    "default_role_id": {},
    "id": {
    "type": "string"
    }
    }
    }
    }
    },
    "meta": {
    "type": "object",
    "properties": {
    "count": {
    "type": "integer"
    },
    "page_count": {
    "type": "integer"
    },
    "page_number": {
    "type": "integer"
    },
    "page_size": {
    "type": "integer"
    }
    }
    }
    }
    }
    { "type": "object", "properties": { "count": { "type": "integer" }, "results": { "type": "array", "items": { "type": "object", "properties": { "key": { "type": "string" }, "id": { "type": "string" } }, "required": [ "key", "id" ] } }, "account_invitations": { "type": "object", "properties": { "91103855": { "type": "object", "properties": { "full_name": { "type": "string" }, "email_address": { "type": "string" }, "headline": {}, "pending": { "type": "boolean" }, "permission": { "type": "string" }, "bill_rate_in_cents": {}, "cost_rate_in_cents": {}, "billability_target": {}, "inviter_id": { "type": "string" }, "invitee_id": { "type": "string" }, "default_role_id": {}, "id": { "type": "string" } } } } }, "meta": { "type": "object", "properties": { "count": { "type": "integer" }, "page_count": { "type": "integer" }, "page_number": { "type": "integer" }, "page_size": { "type": "integer" } } } } }

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

  • kenneth0596 Profile Picture
    62 on at

    Hi @yashag2255, thanks for replying. 

     

    I have the dynamic content, what Im saying is that "invitee id" returns null value. 

     

    Capture.PNG

  • RezaDorrani Profile Picture
    12,143 on at

    Hi @kenneth0596 

     

    Use the following expression

     

    body('output')?['account_invitations']?['91103855']?['invitee_id']

     

    where body('output') shoud be replaced by the dynamic content which is holding your json

     

    Regards,

    Reza Dorrani

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • kenneth0596 Profile Picture
    62 on at
    Hey @RezaDorrani  
     
    I replaced body('output') with body('Parse_JSON') and still didnt work. 
     
    my expression looks like this: body('Parse_JSON')?['account_invitations']?['91102095']?['invitee_id']. 
  • RezaDorrani Profile Picture
    12,143 on at

    Hi @kenneth0596 

     

    Dont do parse json

    just use the json object u have prior to parsing

  • Verified answer
    v-bacao-msft Profile Picture
    on at

     

    Hi @kenneth0596 ,

     

    It seems that because id is a dynamically changing value, even if you parse the JSON response, the property name is always changing, so you can't get the exact value.

    It seems that the id value we need in the results, you could take this id first, and then use it to get invitee_id.

    Expression reference:

    variables('Response')['account_invitations'][outputs('Compose')]['invitee_id']

    Image reference:

    67.PNG

    Hope it helps.

     

    Best Regards,

  • eelkekramer Profile Picture
    5 on at

    Hi @RezaDorrani

    I was having the exact same issue. Somehow all of the parsed fields are considered null, while the interface shows them having actual values.

    Your answer was the fix for me. Thank you for that!

    Kind regards, Eelke

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard