Answered

How to go from a JSON object to being able to take action on the data contained within

(0) Share

Report

Posted on by SconeBling

I'm pretty new to Logic Apps and JSON, so there's a knowledge gap here I'm struggling to overcome.

In my Logic App, I am making an HTTP request to Graph and receiving back data in the following format (odata.count is variable):

{
"@odata.context": "https://graph.microsoft.com/v1.0/[...]",
"@odata.count": 2,
"value": [
 {
"property1": "a",
"property2": "b",
"property3": "c"
 },
 {
"property1": "f",
"property2": "g",
"property3": "h"
 }
 ]
}

How do I get from this to being able to do actions like "for each item where property1 is x, do an action with the value of property2"? I imagine it's some combination of "Parse JSON" and other Data Operations, but I'm having issues figuring out what I need to do. Thanks in advance for your help!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yueyun-msft on at

Like (1)

Report

Hi , @SconeBling

According to your description, do you mean you want to loop your "value" array and then judge the property1 is x, then use the property2 data.

This is my test flow, you can refer to , wen can use the item()?['property2'] to get the "property2" data in each loop

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
SconeBling 5 on at

Like (0)

Report

Thank you so much for your help Paimon. That solved the issue I was having!

(I had to ignore the "invalid formula" message, but it accepted the formula the second time I entered it.)

Was this reply helpful? Yes No