Answered

Failed to filter using Greater or Equals in Power Automate

(2) Share

Report

Posted on by veracruz

Hi,

I have this data in a spreadsheet and I want to filter the data so it will show only values greater or equal to -7. But when I compare the inputs and outputs, negative values greater than -7 and less than 0 got filtered out like this. Has anyone ever experienced a similar problem?

Inputs - Outputs

My actual flow is longer than this, but I simplified it and it looks like this.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Chriddle 8,686 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!
Here you handle strings, hence '-2' is less than '-7' . String comparisons compare characters from left to right (dictionary order)

Do numerical comparison instead:

@greaterOrEquals(int(item()), -7)

Was this reply helpful? Yes No
veracruz 45 on at

Like (0)

Report
Copy link

Link copied!

Hi @Chriddle,

Thank you, it works for the simple flow above using a table with one column only. But when I applied it to the another table which has more columns, it failed to run and this is the error message. Do you happen to know the cause?

Was this reply helpful? Yes No
Chriddle 8,686 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Check if item()?['Days'] is always somethig that can be converted to an int (e.g. check if it's empty)!

Was this reply helpful? Yes No
veracruz 45 on at

Like (0)

Report
Copy link

Link copied!

Hi, @Chriddle. Yes, turned out there is a null value. Thank you so much for your help!

Was this reply helpful? Yes No