Unanswered

How to find what is causing this error "The value 'Text box' cannot be converted to a number."

(1) Share

Report

Posted on by Garethterb1

131

When I switch the new analysis engine on I get this warning when navigating to a page. I have searched the code view for this phrase but found nothing. I have also checked all the text boxes that contain values and found nothing out of the ordinary. All functions are working as expected and there is no warning about this in the App Checker. Any idea how to pinpoint the cause?

When I monitor the app in play mode I only get Delegation warning.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report

Hi @Garethterb1,

You might want to add your comments to this thread.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee

Was this reply helpful? Yes No
Verified answer

Garethterb1 131 on at

Like (1)

Report

After hours of searching and testing I eventually found the problem. What annoying is that I don't believe that this should have been flagged at the point of first opening the screen.

I have a text box in a gallery that evaluates ChargeAction and returns a result if true or nothing when false, I did tried substituting "" with 0. When the screen loads the collection is empty, which seems to have been the problem.

Original formula:

If(ThisItem.ChargeAction = "Edited" ||ThisItem.ChargeAction = "New",ThisItem.NewAmount,"")

Corrected formula:

If(IsEmpty(ChargesJSONCollection),0,If(ThisItem.ChargeAction = "Edited" ||ThisItem.ChargeAction = "New",ThisItem.NewAmount,""))

Was this reply helpful? Yes No