How to write If condition for Text Property in PowerApps ?

(0) Share

Report

Posted on by Newbie12

227

Hi,

I am new to PowerApps and have Excel as my Datasource. I have columns titled as "Canceled" and "Ref No". The "Canceled" column contains values "Y", "N" or " ". The "Ref No" column contains Reference Numbers. Below table is for demo purpose. I would like to display the message when there is data present in Reference Number column and Canceled column contains "N" or " ". The message can be "Check Reservation". I am using Label and not sure what should be the Text property of the table using if condition ?

The Table# is Table1

Ref. No	Canceled
RU123	Y
KP159	N
OP190

Thanks in advance for time and help!

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @Newbie12

Put a dropdown control and a label on the screen and set the dropdown Items property as Table1. (FYI, don't use "." or spaces in your field names, camel case is preferred). In the label Text property

Lookup(Table1,RefNo=Dropdown.Selected.RefNo, Canceled).

The user can then select the reference number from the dropdown and label will display whether it is cancelled. Make sure that there are no duplicates in the RefNo column. Lookup only finds the first one if there is.

Was this reply helpful? Yes No