Power Platform Community Forum Thread Details

Hello all, nice to meet you.

Im new to flow, coming from ansible. Love flow and its capabilities but i have hit a snag, im hoping someone can help me.

I dont expect a finished solution, but i would be grateful for any help as im busting my brain with this for past couple of days and cant get it to work.

I have a JSON like so with thousands of entries, this one is truncated for convinicence:

[

{

"networkId": "N_566327XXX1874625",

"serial": "Q2TN-XXXX-CW29",

"uplink": "wan1",

"ip": "8.8.8.8",

"timeSeries": [

{

"ts": "2021-01-14T15:08:47Z",

"lossPercent": 0.0,

"latencyMs": 27.7

}

]

{

"networkId": "N_56632XXXX141874660",

"serial": "Q2TN-XXXX-35S4",

"uplink": "wan1",

"ip": "8.8.8.8",

"timeSeries": [

{

"ts": "2021-01-14T15:08:55Z",

"lossPercent": 0.0,

"latencyMs": 4.8

}

]

}

]

Im trying to first filter out all entries that have lossPercent not equal to 0 or 100

And in the end end up with something like:

[

{

"serial": "Q2TN-XXXX-35S4"

"lossPercent": 9

"latencyMs": 4.8

{

"serial": "Q2TN-YYY-35S4"

"lossPercent": 5

"latencyMs": 4.8

}

]

I understand i have to use looping and filter array, but just cant seem to get it right.

Not sure how to "get to" the item lossPercent so far deep in 😄

Appreciate any pointers, all.

Categories:

Building flows

Hello @zpavlovic ,

I think you'll need an array variable to store the results and process the JSON in 2 steps with 2 'Parse JSON' actions:

Parse JSON: parse the main JSON with all the data
Apply to each: for each object from the 'Parse JSON'
- Parse JSON 2: parse only the 'timeSeries' part in each of the objects from the first 'Parse JSON'
- Apply to each 2: for each 'timeSeries' part in each the object
  - Condition: if lossPercent is 0 or 100
    - True: Append to array variable: build the output object using 'serial' from 'Parse JSON' and 'lossPercent' + 'latencyMs' from 'Parse JSON 2' and add it to the array variable
    - False: Do nothing

After the original 'Apply to each' the array variable should contain what you need.