Condition on a Currency Field

(0) Share

Report

Posted on by neill_long

708

Hi,

I have a flow that has a condition on a currency field. I am looking to say if value is greater than or equal to 30.00, then follow true route, if not false.

I have the following expression:

triggerBody()['TotalPrice']

The totalprice is a 'ask in PowerApps' option, but it is taking a value that is stored in a currency column in a SP List.

Every once in a while, it goes down the 'true' route even if the value is less than 30. Majority of times is works fine though.

Have I missed something to ensure all submissions where ordertotal is less than 30 goes down the false route?

Categories:

General topics

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

wskinnermctc 6,519 Moderator on at

Like (1)

Report
Copy link

Link copied!

You should put the dynamic content you are using in the Condition into a Compose step. Run the flow and see what the output result is.

If the output is black color, then it is a string. If the output is green then it is a integer/number.

Black String vs Green Number

If the output is green then the condition needs to compare it to 30 not '30' since single quotes makes it a string.

You could also make it int(30) using the integer function.

If the output is black string, then you need to put it into a float() function which is like the integer int() function except float() accepts decimals.

If you go ahead and make something like this below where your value is in a float() function compared to an int() function. It should work.

Was this reply helpful? Yes No