Cannot use Integers in Filter Array actions

(2) Share

Report

Posted on by DineshK_

205

Hi Experts,

I want to filter one of the Number column from the table (Data Source)

So i am using Filter Array as below :

Finding Age is a days column in which we have numbers in range of 1 to 64 , here i want to list out only less than 8 days rows only.

I am getting below errors when test it .

"The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@lessOrEquals(item()?['Finding Age'], 8)' failed: 'The template language function 'lessOrEquals' expects two parameter of matching types. The function was invoked with values of type 'String' and 'Integer' that do not match.'."

I think Instead of 8 , we have to define something correctly.

Please help to solve this action?

Thanks

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

Chriddle 8,441 Super User 2025 Season 2 on at

Like (1)

Report

The 8 on the right side is fine (if there are no spaces or other invisible characters).

Excel sends these values as strings. Therfore use the int() expression to convert them.

Was this reply helpful? Yes No
DineshK_ 205 on at

Like (1)

Report

@Chriddle : I have tried like the below in filter array but still the same error exists :

@lessOrEquals(int(item()?['Finding Age'], 8))

"The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@lessOrEquals(int(item()?['Finding Age'], 8))' failed: 'The template language function 'int' expects one parameter: the value that is to be converted to an integer. The function was invoked with '2' parameters. Please see https://aka.ms/logicexpressions#int for usage details.'."

Was this reply helpful? Yes No
Chriddle 8,441 Super User 2025 Season 2 on at

Like (2)

Report
try this:

@lessOrEquals(int(item()?['Finding Age']), 8)

Was this reply helpful? Yes No
DineshK_ 205 on at

Like (1)

Report

Perfect , it is working fine and in my table the data column is not displayed properly..

What should be the date format should be given in the source?

In the output table :

Data Operation used to create this output table :

Was this reply helpful? Yes No
Verified answer

Chriddle 8,441 Super User 2025 Season 2 on at

Like (1)

Report

In the Excel connector's "advanced options" you will find "DateTime Format".

Set this to ISO 8601.

Then you will get Power Automate date strings. Use formatDateTime() to convert them to the desired format.

Was this reply helpful? Yes No