Trying to remove items from an array that a certain propery does not exist

(0) Share

Report

Posted on by XraySullivan

Hello all,

Im stumped and need your help.

I have an array that is bringing me back 100os of items and I want to filter out the ones that a certain propery does not exist in.

Example:

{
"body": {
"value": [
{
"Status": "Executed",
"Project": "13",
"Business": "Test",
"Parent": "345"
},
{
"Status": "Executed",
"Project": "19",
"Business": "Late Stage Programs",
},
{
"Status": "Executed",
"Project_Nbr": "12",
"Business": "Home",
"Parent": "1"
}

]

}

I want to filter out any items that do not have the "Parent" property

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report

Hi @XraySullivan ,

If this is your sample data:

... you can try the following expressions in a Filter Array action:

Here is the sample runtime output:

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No