The IsNumeric function is used to check whether a given value is a number.
It returns true if the input is numeric (integer, decimal, etc.) and false if the value is not numeric (such as text or a blank).
Syntax:
IsNumeric(Value)
Value: The value or expression you want to evaluate to see if it is numeric.
Examples:
IsNumeric(123)
IsNumeric("123")
IsNumeric("Power Apps")
5. The following formula checks whether an empty string (represented by “”) is considered a numeric value, and it returns false because an empty string is not a numeric value. Consequently, when the IsNumeric function evaluates “”, it returns false.
IsNumeric("")
Using of IsNumeric function to validate the Input value
First, add a Text Input control and a Text Label control. Then, navigate to the Text property of the Text Label control and enter the following formula:
If( Â IsNumeric(TextInput1.Text), Â "Valid value", Â "Invalid value" )
This checks if the text entered in TextInput1 is a number. If it is, it returns “Valid value” , otherwise it returns “Invalid value”.
Let’s run the app and enter the value “ABC” into the text box. You will see that it displays “Invalid value” on the label.
Let’s enter a different value, 123, in the text box. This time, you will see that it displays “Valid value” on the label.
Recommended for you..
Email validation in Power Apps
RemoveIf function in Power Apps
Text function to format date/time or numbers to text string
