Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Greater than - Less than

(0) ShareShare
ReportReport
Posted on by 11

Hi, 

 

I've built a condition checking a number in a Form.

The condition is suppose to check if the number is between 500 and 10 000 :

lielianjie_0-1706103314542.png

For a reason I don't understand, the condition keep saying No. 

Last test I did, the number was 2328.01 and the Flow took the No branch. 

 

FYI, I have an other Flow with the same condition (exept numbers between 10000 and 50000) and it's work perfectly. 

 

Can someone help me pls? 

 

Thanks.

  • Expiscornovus Profile Picture
    31,641 Most Valuable Professional on at
    Re: Greater than - Less than

    Hi @lielianjie,

     

    My suggestion would be to convert both the answer and the 500 & 10000 values to float type of data (decimals).

     

    Try the below

     

    The Total amount question (change the id to your question id)

     

    float(outputs('Get_response_details')?['body/r15811ccddb4b4efd8cf480f4633ba267'])

     

     

    Greater than

     

    float('500')

     

     

    Less than

     

    float('10000')

     

     

    converttofloats.png

  • Tjan Profile Picture
    1,087 Super User 2025 Season 1 on at
    Re: Greater than - Less than

    @lielianjie  Hi! Have you tried without the ' '? Also, are the variables that you used of string type or number? If they are string, make sure to convert them to a number first by using the int() function. 

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,653 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow