web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

lessOrEquals won't work comparing to numbers ?

(0) ShareShare
ReportReport
Posted on by

Hi,

i'm struggling real hard, dunno why, to make a flow work.

 

The flow shoots as soon there's a new item in a sharepoint list. I have 3 number columns from which i set a condition in an automated flow. 

 

PriceDiscountPercentage
100005005

 

The flow has to go on yes or no from a condition that is :

 

If Percentage is less or equal than 10 => go to Yes.

if Percentage is not => go to No.

 

I tried with the column percentage being a calculated values column, or a simple number column.

 

Power Automate doesnt like any configuration :

 

When the Percentage column is a number, the error says :

"The template language function "lessOrEquals" requires all of its parameters to be integers or decimal numbers. Invalid parameter types were found: 'Null'."

 

When it's a calculated value column, it says :

"The template language function "lessOrEquals" requires two parameters of matching types. The function was called with values of types "String" and "Float" that do not match."

 

What the heck ?

 

If there's a solution i'd rather use the calculated value Percentage column rather the "number" one, because it's automatic, that calculated one is made of the formula =[Discount]/[Price]

I have the same question (0)
  • dunnno Profile Picture
    on at
    Re: lessOrEquals won't work comparing to numbers ?

     i had to insert an action "Update item" right after the "When an item is created", for it to copy the value of my calculated column cell to a "number" column cell. Then i added an "Initialize Variable" which i called "Percent" for that cell to be "float".

     

    After all that i can now use the condition yes or no, evaluating if that "Percent" expression is less or equal to 10.

     

    ==> Is there any easier way ?

  • Verified answer
    v-bofeng-msft Profile Picture
    on at
    Re: lessOrEquals won't work comparing to numbers ?

    Hi @dunnno :

    I've made a test for your reference:

    1\My List

    vbofengmsft_1-1638770944647.png

     

    2\My Flow

    vbofengmsft_0-1638770918069.png

    vbofengmsft_2-1638770964204.png

    Best Regards,

    Bof

     

  • dunnno Profile Picture
    on at
    Re: lessOrEquals won't work comparing to numbers ?

    Looks like it's all fine, my workaround and you solution, both work 😄

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 655 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 371 Moderator

#3
chiaraalina Profile Picture

chiaraalina 276

Last 30 days Overall leaderboard

Featured topics

Restore a deleted flow