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?