The Value Cannot be converted to a number

(1) Share

Report

Posted on by TechPrieto

I have no idea why I am getting this error.

I have the same configuration in another field and it works fine.

But in this one when I click on edit it gives the following error.

The fields are ABC.

The field is a dropdown on the edit form as "Allowed Values".

Don't know if the information from the monitor could help

{
 "status": null,
 "duration": null,
 "dataSource": null,
 "responseSize": null,
 "controlName": "ITEM_DataCard3",
 "propertyName": "Default",
 "nodeId": null,
 "formulaData": {
 "script": "",
 "spanStart": null,
 "spanEnd": null
 },
 "data": {
 "errors": [
 {
 "Kind": 25,
 "Message": "The value '911120V.58' cannot be converted to a number.",
 "Source": "ITEM_DataCard3.Default",
 "Observed": "ITEM_DataCard3.Default",
 "Details": null
 }
 ],
 "info": "The value '911120V.58' cannot be converted to a number.",
 "context": {
 "entityName": "ITEM_DataCard3",
 "propertyName": "Default"
 }
 }
}

{
 "status": null,
 "duration": null,
 "dataSource": null,
 "responseSize": null,
 "controlName": "ITEM_DataCard3",
 "propertyName": "Default",
 "nodeId": 3,
 "formulaData": {
 "script": "",
 "spanStart": null,
 "spanEnd": null
 },
 "data": {
 "errorMessage": "The value '911120V.58' cannot be converted to a number.",
 "raiseToastNotification": false,
 "wasReported": false,
 "error": null,
 "functionName": "Value",
 "context": {
 "entityName": "ITEM_DataCard3",
 "propertyName": "Default",
 "nodeId": 3,
 "id": 1581,
 "diagnosticContext": {}
 },
 "info": "The value '911120V.58' cannot be converted to a number."
 }
}

Thanks

Categories:

Building Power Apps

Screenshot 2023-0...

I have the same question (0)

All responses (7)

Answers (1)

iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report
911120V.58

That's not a number - the V inside it can't be converted

Was this reply helpful? Yes No
TechPrieto 16 on at

Like (1)

Report

Thanks for you replay, but I don't understand why wants to convert it, I don't need it.. That is a error when I tried to edit the information... The thing is on the edit screen I just need that works with the value on the DB not that people put random information there.

Was this reply helpful? Yes No
Verified answer

iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

Ok, so go to ITEM_DataCard3.Default and change it from

Value( WhateverIsInHere )

to

WhateverIsInHere

Just take the Value conversion out if it's not needed

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

Oh, are you maybe saying you want them to only enter in valid numbers, not other text?

Set the Format for the Text Input to Number:

Was this reply helpful? Yes No
TechPrieto 16 on at

Like (1)

Report

This works...

So, the "value" is a function to do a specific action like convert number that are on are string to number?

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

Yes, Value function converts a string to a number format

You can see a list of all functions here in the formula reference - I refer to this often! 🙂

Was this reply helpful? Yes No
TechPrieto 16 on at

Like (1)

Report

Thank you! 🙌

Was this reply helpful? Yes No