Error message converting text to value

(0) Share

Report

Posted on by JM-22121412-0

Can anyone provide any guidance to how to convert text to a number without getting an error message. This is the If statement I am using. I am comparing 2 numbers from 2 different text controls and attempting to change the fill color of a circle. Everything works properly but I still get an error when the app loads that says "the value 'text' cannot be converted to a number."

   If(
        Value(CountActual_4.Text) > Value(CountMinimum_4.Text),
        Color.Green,
        If(
            Value(CountActual_4.Text) = Value(CountMinimum_4.Text),
            Color.Gold,
            Color.Red
        )
    )

Categories:

Power Platform Build Tools

All responses (1)

Answers (0)

scalca 180 on at

Like (0)

Report

Error message converting text to value

What's the initial value of the text fields ?

probably when it loads the app the initial value is some text which cannot be converted and after that you load get some values from a source.

you could implement an exception handling mechanism to catch the error using IfError()