You’re offline. This is a read only version of the page.
53
In a DataCard called COMPANY, I have a dropdown list with two options, A and B. I want the DataCard called DETAIL to display a dependent list based on what is selected in COMPANY. Here is an image how the column was setup in Sharepoint
For example, if I select A, I want the options to be A1, A2, and A3, and if I select B in COMPANY, I want the options to be B1, B2, and B3.
I understand that this is possible by using a conditional statement in the Items property of the DETAIL cell. In this case I prefer to use a formula rather than an Excel File with the data. It is similar to this response.
I was trying with this formula: If(DataCardValue107.Selected.Value = "A", ["A1“; "A2“; "A3"], ["B1“; "B2“; "B3"]), but I got an error.
Thank you
@949184_soy , your formula looks correct to me. I am not clear on what the data type is for the Detail field (or whether it is a custom data card in your Form), but you should be applying your formula to the Items property of the Dropdown control:
Share
Report
All responses (
Answers (
If(
DataCardValue107.Selected.Value = "A",
[
"A1",
"A2",
"A3"
],
[
"B1",
"B2",
"B3"
]
)
