Answered

Power automate - Condition step calculates incorrectly

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I need some help with my Condition step as it incorrectly classifies the value as False.

For my flow the condition step is to test whether or not 20 days have been spend working, please check the pictures. When the value in the list is 4 days based on the condition (less or equal than 20 days), this should return as True but it returns as false.

Weirdly enough, sometimes the condition result returns correctly as False, but I can't figure out why it runs correctly in some cases and others it doesn't. (See picture condition result correct)

Based on information on this forum, I tried using the step Int. Variables for string as well as integer and used Concat(20) for the 20 condition. Unfortunately, I wasn't able to solve this but I hope someone can help me. 😊

Power automate flow - condition error flow.png

Power automate flow - condition result correct.png

Power automate flow - condition error result.png

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

shoog 2,164 on at

Like
a
(0)

Report
Copy link

Link copied!

Comparing strings with a less than operator doesn't work well.

If you are sure the input is always a number, initialize the variable as Integer type instead of String or convert it in the comparisson using the int function, so you can do a numerical comparisson. The right side of the condition could be int(20) to be sure it's evaluated as a number.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Shoog,

Thank you for your quick response but I am getting an error I don't understand. The answer recorded in the SP List is always a number.. What am I doing wrong?

Was this reply helpful? Yes No
Verified answer

shoog 2,164 on at

Like
a
(0)

Report
Copy link

Link copied!

The number is stored in SP as a string, so you have to convert it explicitly while initializing the variable.

You can use the int function for this, like int(<your input>)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, it worked! 😁

Was this reply helpful? Yes No