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?
Thanks! I guess i was over thinking it. now on to the switch condition for the "Request Type"
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
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
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.
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1