Skip to main content
Community site session details

Community site session details

Session Id : B6seam02MgmRjGvMNG43t/
Power Automate - Building Flows
Answered

Less than, equal too, and Greater than Expresssions

Like (0) ShareShare
ReportReport
Posted on 11 Jul 2018 16:25:32 by 41

So I am wokring on a "Purchase Request" list in sharepoint. I have the list built so the item information, qty, unit price are all entered and the Total Price as a calculated column "=[Quantity]*[Unit Price]" with the Total Column formatted as Currency. 

 

 here are my list columns:

Request StatusChoice 
Request PriorityChoice 
Request TypeChoice 
Purchase Order RequiredChoice 
Purchase Order No.Single line of text 
Supplier CodeSingle line of text 
Supplier NameSingle line of text 
Supplier InformationMultiple lines of text 
Item CodeSingle line of text 
ItemSingle line of text 
Item DescriptionMultiple lines of text 
Link to Item (if online)Hyperlink or Picture 
QuantityNumber 
Unit PriceCurrency 
TotalCalculated (calculation based on other columns) 
Ship to AddressMultiple lines of text 
Project NameSingle line of text 
Approved byPerson or Group 
Approval DateDate and Time 
Approval StatusChoice 
Request DateDate and Time 
ModifiedDate and Time 
Requested byPerson or Group 
Modified ByPerson or Group

 

For the Flow I have the Trigger as when an item is created, I then have 3 branches with a condition of Less than or equal to $99, Greater than $99 and less than $1199, and greater than or equal to $1200. I am using the following expressions for these: 

 

@lessOrEquals(triggerBody()?['Total'], '$99.00')

@and(greaterOrEquals(triggerBody()?['Total'], '$100.00'),lessOrEquals(triggerBody()?['Total'], '$1199.00'))

@greaterOrEquals(triggerBody()?['Total'], '$1200.00')

 

I have entered an request to purchase 7 Pencils at .50 each for a total of $3.50. the Flow is triggered but instead of processing as it should in the less than $99 it marks all three branches of the flow with a green check showing they completed, under the output it shows False under the <$99, >$100<$1199 and True under the >$1200. 

 

anyone have any thoughts on this? do i need to format the data in the Total column differently so Flow is able to read it as expected?

  • Timmay313 Profile Picture
    41 on 12 Jul 2018 at 13:52:04
    Re: Less than, equal too, and Greater than Expresssions

    Thanks! I guess i was over thinking it. now on to the switch condition for the "Request Type" 

  • Verified answer
    v-yuazh-msft Profile Picture
    on 12 Jul 2018 at 07:36:49
    Re: Less than, equal too, and Greater than Expresssions

    Hi @Timmay313,

     

    I have made a test on my side and I afraid that there is no any way to compare a Currency type data in the Condition.

    You could delete the $ 'in the Condition,you could refer to my screenshot below to create the flow:

    Capture.PNG

     

    The expression in the Condition as below:

    @lessOrEquals(float(triggerBody()?['Total']), 99.00)

     

    The expression in the Condition 2 as below:

    @and(greaterOrEquals(float(triggerBody()?['Total']), 100.00),lessOrEquals(float(triggerBody()?['Total']), 1199.00))

     

    The expression in the Condition 3 as below:

    @greaterOrEquals(float(triggerBody()?['Total']), 1200.00)

    And when an item is created as below:

    Capture.PNG

     

    The flow would run successfully as below:

    Capture.PNG

     

    Best regards,

    Alice

     

     

  • v-yuazh-msft Profile Picture
    on 12 Jul 2018 at 07:36:48
    Re: Less than, equal too, and Greater than Expresssions

    Hi @Timmay313,

     

    I have made a test on my side and I afraid that there is no any way to compare a Currency type data in the Condition.

    You could delete the $ 'in the Condition,you could refer to my screenshot below to create the flow:

    Capture.PNG

     

    The expression in the Condition as below:

    @lessOrEquals(float(triggerBody()?['Total']), 99.00)

     

    The expression in the Condition 2 as below:

    @and(greaterOrEquals(float(triggerBody()?['Total']), 100.00),lessOrEquals(float(triggerBody()?['Total']), 1199.00))

     

    The expression in the Condition 3 as below:

    @greaterOrEquals(float(triggerBody()?['Total']), 1200.00)

    And when an item is created 

     

     

  • Timmay313 Profile Picture
    41 on 11 Jul 2018 at 19:21:08
    Re: Less than, equal too, and Greater than Expresssions

    Continueing to work on this... I have added a Compose to the Flow after the trigger. adding the Total as the input, the ouput i was getting was 3.500000000 or something like that. using the following expression I am attempting to generate a output that works with my condition expressions post above. 

     

    if(or(greater(triggerbody()?['Total'], string (10)),equals(triggerbody()?['Total'],string(10))),take(triggerbody()?['Total'],4),take(triggerbody()?['Total'],3))

     

    This gets me to 3.50 or 350 as an output still not working but i think im heading in the right direction. 

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Loading complete