Power Platform Community Forum Thread Details

llo,

I have an array of strings that contains both words and numbers. I want to filter the array to only show the items that are exclusively numeric. In other words, I only want the items whose value is like "12345" and I do not want items that contain values like "abcdef" nor "abc123def".

The array is coming from a Select action and the raw output looks like this.

{
    "body": [
        {
            "Text Values": [
                "PREVIOUS SHIFT",
                "37868",
                "SECONDS",
                "TOTAL TIME",
                "58402",
                "SECONDS",
                "2 SHIFTS PREVIOUS",
                "34247",
                "SECONDS",
                "DAY TIME STAMP",
                "32084",
                "SECONDS"
            ]
        }

I've tried using the Filter Array action to filter out non-numeric items like so...

But I get the following error on the Filter Array when I run the flow.

Action 'Filter_array' failed: The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@equals(isInt(item()),true)' failed: 'The template language function 'isInt' expects its first parameter 'string' to be a string. The provided value is of type 'Object'. Please see https://aka.ms/logicexpressions#isInt for usage details.'.

I would like the final output to be an array or table that contains only the numeric values.

Help please!

Categories:

Building flows