Unanswered

Filter Array Issue

(0) Share

Report

Posted on by CU13011914-0

I have a Filter Array in Power Automate that brings back the following:

{
"body": [
{
"": "0070809900sJ33rAAC"
},
{
"": "0070809900u45C4AAI"
},
{
"": "0070809900uL9oOAAS"
}
]
}

The issue us, the extracted data looks like this {"":"0070809900u45C4AAI"}

It should look like 0070809900u45C4AAI without all those other characters. Is there an easy way to remove all of those?

The Filter Array uses this Filter Query: @not(notcontains(@{variables('ExistingIDs')},@{item()}))

Can that be changed to fix it, or perhaps a subsequent action?

Any help would be much appreciated! :)

Categories:

General

All responses (2)

Answers (0)

CU13011914-0 2 on at

Like (0)

Report

Filter Array Issue

HI @bscarlavai33 Thanks for your help. I've copied the Input to the Filter Array below. Note that I had shortened the Output to only three in the question I submitted, whereas here you can see the full 10.

[

{

"": "0060800000sJ33rAAC"

},

{

"": "0060800000u45C4AAI"

},

{

"": "0060800000uL9oOAAS"

},

{

"": "0060800000wOtjhAAC"

},

{

"": "0060800000wPctFAAS"

},

{

"": "0060800000wQbpUAAS"

},

{

"": "0060800000wQbsEAAS"

},

{

"": "0060800000wQcBLAA0"

},

{

"": "0060800000wQu4wAAC"

},

{

"": "0060800000wR0W4AAK"

},

{

"": "0060800000pOG8OAAW"

},

{

"": "{\"\":\"0060800000sJ33rAAC\"}"

},

{

"": "{\"\":\"0060800000u45C4AAI\"}"

},

{

"": "{\"\":\"0060800000uL9oOAAS\"}"

},

{

"": "{\"\":\"0060800000wOtjhAAC\"}"

},

{

"": "{\"\":\"0060800000wPctFAAS\"}"

},

{

"": "{\"\":\"0060800000wQbpUAAS\"}"

},

{

"": "{\"\":\"0060800000wQbsEAAS\"}"

},

{

"": "{\"\":\"0060800000wQcBLAA0\"}"

},

{

"": "{\"\":\"0060800000wQu4wAAC\"}"

},

{

"": "{\"\":\"0060800000wR0W4AAK\"}"

},

{

"": "{\"\":\"0060800000pOG8OAAW\"}"

},

{

"": "{\"\":\"{\\\"\\\":\\\"0060800000sJ33rAAC\\\"}\"}"

},

{

"": "{\"\":\"{\\\"\\\":\\\"0060800000u45C4AAI\\\"}\"}"

},

{

"": "{\"\":\"{\\\"\\\":\\\"0060800000uL9oOAAS\\\"}\"}"

},

{

"": "{\"\":\"{\\\"\\\":\\\"0060800000wOtjhAAC\\\"}\"}"

},

{

"": "{\"\":\"{\\\"\\\":\\\"0060800000wPctFAAS\\\"}\"}"

},

{

"": "{\"\":\"{\\\"\\\":\\\"0060800000wQbpUAAS\\\"}\"}"

},

{

"": "{\"\":\"{\\\"\\\":\\\"0060800000wQbsEAAS\\\"}\"}"

},

{

"": "{\"\":\"{\\\"\\\":\\\"0060800000wQcBLAA0\\\"}\"}"

},

{

"": "{\"\":\"{\\\"\\\":\\\"0060800000wQu4wAAC\\\"}\"}"

},

{

"": "{\"\":\"{\\\"\\\":\\\"0060800000wR0W4AAK\\\"}\"}"

}

]
bscarlavai33 513 on at

Like (0)

Report

Filter Array Issue

What does the input to your Filter Array look like?