Power Platform Community Forum Thread Details

Filter array is not working when Greater than condition is applied

Hi There,

Fitter Array not working when applied the below condition.

I need only the array of values where the COUNT(*) > 50 but my flow is returning all the values.

It will be a great help to know what is going wrong.

Below is my flow:

Filter Array 2 code view.

{

"inputs": {

"from": "@variables('ArrayOfContent')",

"where": "@equals(items('Apply_to_each')['COUNT(*)'], 1)"

}

Below is the Array of Content

______________________________________________________

[
{
"TRUNC(SYS_CREATION_DATE)\t": "11/09/2021 00:00:00",
"LETTER_CODES": "CONS",
"ERROR_CODE": "508",
"ERROR_REASON": "LmsException: Exception caught during SOAP Request Call to DMAAS Web Service.",
"COUNT(*)": "1"
},
{
"TRUNC(SYS_CREATION_DATE)\t": "11/09/2021 00:00:00",
"LETTER_CODES": "CONT",
"ERROR_CODE": "11",
"ERROR_REASON": "ArrayIndexOutOfBoundsException: 1",
"COUNT(*)": "3"
},
{
"TRUNC(SYS_CREATION_DATE)\t": "11/09/2021 00:00:00",
"LETTER_CODES": "CONTRACT",
"ERROR_CODE": "11",
"ERROR_REASON": "ArrayIndexOutOfBoundsException: null",
"COUNT(*)": "82"
},
{
"TRUNC(SYS_CREATION_DATE)\t": "11/09/2021 00:00:00",
"LETTER_CODES": "CONT",
"ERROR_CODE": "11",
"ERROR_REASON": "ArrayIndexOutOfBoundsException: null",
"COUNT(*)": "57"
}

]

*******************************

Should return only the below values where COUNT(*) > 50

[

{
"TRUNC(SYS_CREATION_DATE)\t": "11/09/2021 00:00:00",
"LETTER_CODES": "CONTRACT",
"ERROR_CODE": "11",
"ERROR_REASON": "ArrayIndexOutOfBoundsException: null",
"COUNT(*)": "82"
},
{
"TRUNC(SYS_CREATION_DATE)\t": "11/09/2021 00:00:00",
"LETTER_CODES": "CONT",
"ERROR_CODE": "11",
"ERROR_REASON": "ArrayIndexOutOfBoundsException: null",
"COUNT(*)": "57"
}

]

*******************************

Regards,

Quick Links

Leaderboard > Power Automate