The value '-' cannot be converted to a number

Like (0) Share

Report

Posted on 13 Jun 2022 16:19:31 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:

General Questions

All responses (3)

Answers (2)

rbergan 199 on 27 Jun 2022 at 23:50:14

Like (1)

Report

Re: The value '-' cannot be converted to a number

@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.
Verified answer

Tqphan87 32 on 23 Jun 2022 at 16:16:49

Like (4)

Report

Re: The value '-' cannot be converted to a number

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.
Verified answer

v-qiaqi@microsoft.com on 16 Jun 2022 at 03:09:40

Like (1)

Report

Re: The value '-' cannot be converted to a number

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.