cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Timmay313
Frequent Visitor

Less than, equal too, and Greater than Expresssions

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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

 

 

View solution in original post

4 REPLIES 4
Highlighted
Timmay313
Frequent Visitor

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. 

Community Support
Community Support

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 

 

 

Community Support
Community Support

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

 

 

View solution in original post

Timmay313
Frequent Visitor

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" 

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (7,134)