Value function in Power Apps
The Value function converts a string of text that contains number characters to a number value. Use this function when you need to perform calculations on numbers that were entered as text by a user.
Example: The demonstration of the Value function in Power Apps.
Step 1: Add a Text Label control, named Label1, and two Text input controls, named TextInput1 and TextInput2. If we then set the Text property of Label1 to TextInput1 + TextInput2, it will always show the sum of whatever numbers are in TextInput1 and TextInput2 automatically.
Step 2: Select the Text label control and set its Color property to the following formula.
Power Apps Formula
Step 3: A formula for the Fill property of the label will automatically show negative values in red. The If function should look familiar from Excel:
Power Apps Formula
Note: Because the Label is storing information as text, do not forget to use the Value function. The Value function is used to convert a string of text into a value.