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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Is using case for numb...
Power Automate
Unanswered

Is using case for number range possible

(0) ShareShare
ReportReport
Posted on by 55

Hi

I am building a flow based on a new response and on the form they have to fill in a number. I then have a range of 0-1499, 1500-3499, 3500-8499 and finally 8500+. Am I able to use case for a range so if they type in 1200 the case would be 0-1499 and follow that flow or can I use if statements to achieve this and if so how would I do that?

 

Many Thanks 

Categories:
I have the same question (0)
  • Verified answer
    Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @PennyP 

    You need two variables first for lower limit and second for upper limit. Suppose- 0-1500 then Lower limit is 0 and upper limit is 1500.

    now store you number x in another variable which is dynamic i hope so. in your case it is 1200.

    Use condition action-

    1. x is greater than 0 

    And

    2. x is less than 1500

     

    if this condition is true then perform action.

     

    Thanks

    Hardesh

  • PennyP Profile Picture
    55 on at

    Hi Hardesh

     

    @Hardesh15 

    Many thanks for your response. I have tried to set it up as below but still getting an error. Did I understand your response? I have images below of my current flow:

     

    24.06.2020_15.21.43_REC.pngMnay

    24.06.2020_15.24.44_REC.png

  • PennyP Profile Picture
    55 on at

    Photo of flow run24.06.2020_15.30.32_REC.png

  • PennyP Profile Picture
    55 on at

    My Apologies @Hardesh15 the flow was working just the number entered wasn't in between my range so was correct to fail. Many Thanks for your help on this.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard