Display negative number as zero

(0) Share

Report

Posted on by cdowkes

Hi.

I have a gallery used in an order form app where it displays the quantity in stock of each item.

People are allowed to order items that are out of stock so I would like the item to display 0 of no items are in stock but what happens when people order is the available qty then displays a negative number which has confused people.

Is there a way in my code I can say if the number is less than 0 display 0?

This is the code I currently have

"Available in Stock: " & LookUp('PPE Stock',Title=ThisItem.Title,Qty)

As shown it currently displays the live stock figure but the second item shows -4 which is where the confusion comes in for people.

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Community Power Pla... on at

Like (0)

Report
Hello,

Sure, try the following:
"Available in Stock: " & If(LookUp('PPE Stock',Title=ThisItem.Title,Qty)<0,0,LookUp('PPE Stock',Title=ThisItem.Title,Qty))

this is a simple "If", the condition is using the result of your lookup to make sure the value displayed is always >= 0

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@cdowkes

Please consider changing your Formula to the following:

"Available in Stock: " & With(LookUp('PPE Stock',Title=ThisItem.Title), If(Qty<0, 0, Qty) )

I hope this is helpful for you.

Was this reply helpful? Yes No
cdowkes 22 on at

Like (0)

Report

Hi.
Thank you for your quick response. I tried the code as you suggested however I'm getting an error message. Again this could be me misunderstanding I'm still trying to learn as I go.

Was this reply helpful? Yes No
cdowkes 22 on at

Like (0)

Report

Hi.

Thanks for the quick reply. I used the code as you suggested however I'm now getting an error message. Could this be something to do with how I've set up the data?

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (1)

Report
Hello,
The error is saying that the data type is not the expected one, that column "Qty" is a string and needs to be converted to a number, to do this, please use the Value function Value function in Power Apps - Power Platform | Microsoft Learn

try the following, using the idea of @RandyHayes
"Available in Stock: " & With(LookUp('PPE Stock',Title=ThisItem.Title), If(Value(Qty)<0, 0, Value(Qty)) )

Was this reply helpful? Yes No
cdowkes 22 on at

Like (0)

Report

Perfect.

Thank you

Was this reply helpful? Yes No