list item based on if condition part II

(0) Share

Report

Posted on by 949184_soy

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

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@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:

If( DataCardValue107.Selected.Value = "A", [ "A1", "A2", "A3" ], [ "B1", "B2", "B3" ] )

Was this reply helpful? Yes No