0

I want to compare to text input values. The result shows as "on track" or "off track".

Formula:

If(Value(TextInput1_1.Text)> Value(TextInput1.Text),  "ON TRACK", If(Value(TextInput1_1.Text)< Value(TextInput1.Text), "OFFTRACK"))

Not getting any output. Any ideas?

3
  • Where do you adding this formula? Inside "Text" property of label control or somewhere else? Are the values inside text inputs are of type number? Commented Sep 30, 2022 at 17:52
  • I want to add value inside TextInput as text
    – Jose1978
    Commented Sep 30, 2022 at 17:57
  • Try solution given in my answer below. Commented Sep 30, 2022 at 17:59

1 Answer 1

1

Set Default property of third text input to:

If(
    Value(TextInput1_1.Text) > Value(TextInput1.Text),
    "ON TRACK",
    Value(TextInput1_1.Text) < Value(TextInput1.Text),
    "OFF TRACK"
)

Documentation: If function in Power Apps

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.