The value '-' cannot be converted to a number

(0) Share

Report

Posted on by rbergan

199

I just started getting this error message when trying to add a negative number in a few fields in powerapps.

"the value '-' cannot be converted to a number"

I first noticed it in a text input control, so I played around with changing the format from text to number and vice versa. But that did not fix the problem. I then checked if I was getting a similar error on another screen where I know I've inputted negative numbers before. On this second screen, the input is a datacardvalue and the format is set to number.

Any help would be greatly appreciated. Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @powerwood,

Do you want to input negative number within the Text Input control?

Could you please share a bit more about your need?

Not sure how you will reference to this negative number from the TextInput, however, if you want to reference to it as a number value, you could directly use the Value() function to format it as a number format.

Check if it is what you want to achieve.

Was this reply helpful? Yes No
Verified answer

Tqphan87 32 on at

Like (4)

Report
Copy link

Link copied!

I started getting the same error pop-up out of nowhere as well even though I'm still able to save the negative value with no issue. Searching through the forums, I went and turned off the experimental feature "formula-level error management" and the error message no longer appears. I still see it listed in the "Runtime" section of my App Checker though but that was how it was before.

Was this reply helpful? Yes No
rbergan 199 on at

Like (1)

Report
Copy link

Link copied!

@v-qiaqi-msft
It is a card in a form:

The format for this is set to "Number". The default is set to Parent.Default. Once I removed the default value and set it to nothing, then the error message did not appear.

@Tqphan87 , I had a similar experience as you did. When I submitted the form the error message did not impact the successful submission of the form and its data. The record was created and the value was a negative value. I also unchecked the "formula-level error management" experimental feature and it allowed for the negative value to be typed without an error.

Thank you both.

Was this reply helpful? Yes No