You’re offline. This is a read only version of the page.
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!
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
Share
Report
All responses (
Answers (
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.
