Unanswered

Filter Array Issue

(1) 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 topics

I have the same question (0)

All responses (3)

Answers (0)

bscarlavai33 752 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

What does the input to your Filter Array look like?

Was this reply helpful? Yes No
CU13011914-0 2 on at

Like (0)

Report
Copy link

Link copied!

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\\\"}\"}"

}

]

Was this reply helpful? Yes No
eliotcole 4,388 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hiya ... this is looking very much like a bug with a designer that should never have been pushed to prod.

I've noted that other users have experienced this, here and here.

I also experienced it (in PROD!!) on a Logic App. :angry:

Anyway, it looks like the fix I posted here (and here on Github), helps to work around (not fix) this (at least for a single update).

As I stated in the other linked post on this forum ... let me know if this is still bothering you, and/or if my suggestion fixed it. Am not asking for 'fix points' I don't care about that stuff ... I'd rather just show evidence that this is a clear, endemic, thing, to the Logic Apps folks.

( sorry that I cannot tag you ... testing in other browsers doesn't happen here. :weary: )

E

Was this reply helpful? Yes No