Answered

Less than, equal too, and Greater than Expresssions

(0) Share

Report

Posted on by Timmay313

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 Status	Choice
Request Priority	Choice
Request Type	Choice
Purchase Order Required	Choice
Purchase Order No.	Single line of text
Supplier Code	Single line of text
Supplier Name	Single line of text
Supplier Information	Multiple lines of text
Item Code	Single line of text
Item	Single line of text
Item Description	Multiple lines of text
Link to Item (if online)	Hyperlink or Picture
Quantity	Number
Unit Price	Currency
Total	Calculated (calculation based on other columns)
Ship to Address	Multiple lines of text
Project Name	Single line of text
Approved by	Person or Group
Approval Date	Date and Time
Approval Status	Choice
Request Date	Date and Time
Modified	Date and Time
Requested by	Person or Group
Modified By	Person 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?

All responses (4)

Answers (1)

Timmay313 41 on at

Like (0)

Report

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 on at

Like (3)

Report
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:

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:

The flow would run successfully as below:

Best regards,

Alice
v-yuazh-msft on at

Like (0)

Report
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:

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 41 on at

Like (0)

Report

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.