Dropdown Choices becomes a Table, how to use in IF statement

(0) Share

Report

Posted on by jlestervas_

Hi Guys,

Would appreciate your help, I have a form with a set up like this.

DataCard2 is a dropdown choice

DataCard3 is dependent on DataCard2 choices, however, I changed the items from the original choices from Sharepoint to (please see below).

It is working fine, however when I try to use the IF function to check the value of DataCard3, I am having an error and cannot use the DataCard3.Selected.Value anymore. I guess because it is no longer a dropdown select function but rather a table set up. Trying to create an IF statement to check if DataCard3 value is "Other, please specify".

Tried to look for an answer, but to no avail. Please help

If(
DataCardValue2.Selected.Value = "CCTV",
[
"Camera lost viewing",
"Camera blurry or out of focus",
"Camera viewing distorted or faulty",
"Camera facing wrong direction",
"CCTV not recording",
"Genetec technical issue",
"Other, please specify"
],
If(
DataCardValue2.Selected.Value = "Technical Issue",
[
"Unable to connect to CCure",
"iStar controller offline",
"No door activity",
"No badge activity",
"Hardware fault",
"Genetec Issue",
"Other, please specify"
],
If(
DataCardValue2.Selected.Value = "Alarm Activation",
[
"BGU",
"Panic Button",
"Door Held",
"Door Forced",
"Building Fire Alarm Activation",
"iStar Power Fail",
"Other, please specify"
], [])

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jlestervas_ ,

You can condense it a bit like this and add "" to the empty Table, so it is still a string Value

Switch( DataCardValue2.Selected.Value, "CCTV", [ "Camera lost viewing", "Camera blurry or out of focus", "Camera viewing distorted or faulty", "Camera facing wrong direction", "CCTV not recording", "Genetec technical issue", "Other, please specify" ], "Technical Issue", [ "Unable to connect to CCure", "iStar controller offline", "No door activity", "No badge activity", "Hardware fault", "Genetec Issue", "Other, please specify" ], "Alarm Activation", [ "BGU", "Panic Button", "Door Held", "Door Forced", "Building Fire Alarm Activation", "iStar Power Fail", "Other, please specify" ], [""] )

Your output should then be .Value

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
jlestervas_ 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, this actually worked!!! Thank you so much!