Unanswered

need help with parsing ms graph return odata to navigate

(0) Share

Report

Posted on by dharin-sukar

i was able to setup an HTTP get and it returned the following odata, but i am unable to use this as an array. Do i use a compose or what step(s) to convert this into an array? Need to do a for each item, the odata section seems to confuse the default json parser

{
"@odata.context": "https://graph.microsoft.com/beta/$metadata#users(displayName,mail,lastPasswordChangeDateTime)",
"value": [
{
"displayName": "name1",
"mail": "email1@domain.com",
"lastPasswordChangeDateTime": "2021-10-25T18:25:26Z"
},
{
"displayName": "name2",
"mail": "email2@domain.com",
"lastPasswordChangeDateTime": "2021-11-02T20:15:48Z"
}
]
}

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

Pstork1 69,665 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

You would want to do a Parse Json on the value array. That will give you access to displayName, mail, and lastPasswordChangeDateTime in an Apply to Each loop.
dharin-sukar 6 on at

Like
a
(0)

Report
Copy link

Link copied!

could you explain more please?
Pstork1 69,665 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Value should be available as dynamic content. If you use that as the subject of a Parse JSON action then you'll end up with an array of dynamic content. When you use one of those fields it will automatically put it in an Apply to each loop.