Get number of digits of each value found in Filter Array

[alopezppm]

Hello. I have made a Filter Array to find values that meet a condition. I would like to get the number of digits of each value found, because the value I am looking for has only 10 digits and that can get this value to update a field. Thank you for the help.

[Anonymous]

Hi @alopezppm ,

If you add another filter array to your flow as below it should work.

Input value is the output of the first filter array

length(item()) is the expression on the left side

[alopezppm]

Hello. It vives me the following error: The template language función 'length' expectativas its parameter yo be andado array or a string. The provided value is of type 'Object'.

[Anonymous]

Hi @alopezppm ,

Would you please send screenshots of your flow? What does the output of your first filter array look like?

[alopezppm]

Hello again. First, I parse JSON from the readResults of Al Builder and after the Filter Array what has the following: From: Body('Parse_JSON'), text starts with string(45). This extracts the values starting with 45. The value that I need has only 10 digits, that's why I need to add this filter. Thank you.

[alopezppm]

Could you use two conditions in the filter array? With string (45) and length (10). I don't know exactly how to apply it.

[Anonymous]

@alopezppm ,

Since there are no screenshots of your flow, it is a bit hard to imagine, however I cannot imagine any problems about using another filter array after parsing your JSON and applying your first filter array. 

[alopezppm]

Good afternoon; I share screenshots. I have tried to do the Filter array 2 and it gives the following error:

 

And here os the output that I need to filter again with the lenght 10.

[
{
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"text": "4500051817",
"location": {
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"page": 1,
"boundingBox": {
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"left": 0.44460847783734075,
"top": 0.4834707210288685,
"width": 0.09765365021357958,
"height": 0.007550622520180628,
"polygon": {
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"coordinates@odata.type": "#Collection(Microsoft.Dynamics.CRM.crmbaseentity)",
"coordinates": [
{
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"x": 0.44460847783734075,
"y": 0.4834707210288685
},
{
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"x": 0.5422621280509203,
"y": 0.4834707210288685
},
{
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"x": 0.5422621280509203,
"y": 0.49102134354904914
},
{
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"x": 0.44460847783734075,
"y": 0.49102134354904914
}
]
}
}
}
},
{
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"text": "4500051817",
"location": {
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"page": 2,
"boundingBox": {
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"left": 0.01577947458221905,
"top": 0.44219455465864,
"width": 0.09766575103764566,
"height": 0.007559173621562498,
"polygon": {
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"coordinates@odata.type": "#Collection(Microsoft.Dynamics.CRM.crmbaseentity)",
"coordinates": [
{
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"x": 0.01577947458221905,
"y": 0.44219455465864
},
{
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"x": 0.11344522561986471,
"y": 0.44219455465864
},
{
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"x": 0.11344522561986471,
"y": 0.4497537282802025
},
{
"@odata.type": "#Microsoft.Dynamics.CRM.expando",
"x": 0.01577947458221905,
"y": 0.4497537282802025
}
]
}
}
}
}
]

[Anonymous]

Hi @alopezppm ,

The failing part is the parsing JSON, not the second filter array.  I would suggest generating your JSON schema again.

[alopezppm]

Hello. The Parse JSON works now, but the Filter Array has the following error. I have used the expression length(item()) in the left side and the value 10. The problem is the type.

[alopezppm]

How I can filter the type object? In the JSON is the properties (text).

[Paulie78]

length(item()['text'])

[alopezppm]

Thank you @Paulie78. Now it works. The problem that I have, is that it counts all the digits of that line and does not filter the element I need. I show you an example. This is result that I obtain from the previous Filter Array that filters the elements that have the number 45. I need to count the digits, because the one I´m looking for only 10, from the text, the element found.

{

            "@odata.type": "#Microsoft.Dynamics.CRM.expando",

            "text": "SU PEDIDO Nº 4500052404",

            "location": {

                "@odata.type": "#Microsoft.Dynamics.CRM.expando",

                "page": 1,

                "boundingBox": {

                    "@odata.type": "#Microsoft.Dynamics.CRM.expando",

                    "left": 0.18567504447052846,

                    "top": 0.3114052360323956,

                    "width": 0.14698870993114632,

                    "height": 0.0062154341386572165,

                    "polygon": {

                        "@odata.type": "#Microsoft.Dynamics.CRM.expando",

                        "coordinates@odata.type": "#Collection(Microsoft.Dynamics.CRM.crmbaseentity)",

                        "coordinates": [

                            {

                                "@odata.type": "#Microsoft.Dynamics.CRM.expando",

                                "x": 0.18567504447052846,

                                "y": 0.3114052360323956

                            },

                            {

                                "@odata.type": "#Microsoft.Dynamics.CRM.expando",

                                "x": 0.3326637544016748,

                                "y": 0.3114052360323956

                            },

                            {

                                "@odata.type": "#Microsoft.Dynamics.CRM.expando",

                                "x": 0.3326637544016748,

                                "y": 0.31762067017105283

                            },

                            {

                                "@odata.type": "#Microsoft.Dynamics.CRM.expando",

                                "x": 0.18567504447052846,

                                "y": 0.31762067017105283

                            }

                        ]

                    }

                }

            }

        }

    ]

}

[alopezppm]

Hello @Paulie78 and @Anonymous. I've passed the result to text and I need to look for item by item to extract the number I need. For example: SU PEDIDO Nº 4500052404. The value to extract is 4500052404. Thank you for the support.

[alopezppm]

Hello. Please, I need to solve this. I need to filter each element to find the number that I need. This is my output:

[

    "\n\n\n0,000SU",

    "PEDIDO",

    "Nº",

    "4500052059"

]