Unanswered

If statement to show a message based on another text value

(0) Share

Report

Posted on by PhilGlew

Hi there,

I know this is probably straightforward, but, I need a formula to show one message IF the value of another text field shows one location or another.

Example - I have a text box showing "Worthing" as the user's usual office location. I want my next text label to say "You're good to go" IF this equals Worthing, but to display "Are you sure this is where you want to book a desk?" along with Yes or No buttons, ONLY if the first text box displays a location/value other than Worthing.

Many thanks

Phil

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Irfan 164 on at

Like (0)

Report

Hi @PhilGlew ,

Label Text:
If(Len(TextInput2.Text)>0,
If(Upper(TextInput2.Text)="WORTHING","You are good to go","Are you sure this is where you want to book a desk?")
)
It first checks that textbox is not empty, it then converts the characters into upper for the values entered in the checkbox and finally displays the message based on the text. Changing the case to upper makes sure that user can enter his data in any case - it will still be checked in the formula.

Toggle Visible
If(Len(TextInput2.Text)>0,
If(Upper(TextInput2.Text)="WORTHING",true,false
),false
)
It first checks thta textbox is not empty, it then converts the characters into upper for the values entred in the checkbox and shows the toogle based on the text in the text box

-Irfan

Was this reply helpful? Yes No
CHEESEBOI83 20 on at

Like (0)

Report

Good Morning
I am sorry to comment an old post but I have a question that relates.
How do i accomplish the same thing but using an input that accepts a number as input

It would look like this if a user enters a number between 1 to 1000 show a comments field then if i click a button
it can either then show or hide the comment field

Was this reply helpful? Yes No