Column branching

(0) Share

Report

Posted on by redaelaouane

Dear helpers,

I have two choice column, how can I make the items of culumn B be revealed based on the choice of column A?

Column A : Colors, Numbers, Shapes

Column B :Red, Blue, Black, 1, 2, 3, Triangle, Circle, Rectangle

Thankss

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@redaelaouane ,

There needs to be a relationship between the items somewhere - Power Apps does not know (for example) that a Circle is a Shape. You need to get the Items of the drop-downs from somewhere (unrelated Choice columns will not do it) - either a List, with relationship somewhere in it, or hard-code (for example) the second drop-down Items to something like

Filter( Table( {Value: "Red", Type: "Colors"}, {Value: "Blue", Type: "Colors"}, {Value: "Black", Type: "Colors"}, {Value: "1", Type: "Numbers"}, {Value: "2", Type: "Numbers"}, {Value: "3", Type: "Numbers"}, {Value: "Triangle", Type: "Shapes"}, {Value: "Circle", Type: "Shapes"}, {Value: "Rectangle", Type: "Shapes"} ), Type = Dropdown1.Selected.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
redaelaouane 59 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much @WarrenBelz for your answer..

ill try to explain this better.
the idea is when filling in the form I want the second scroll menu to show only adequate options based on the 1st one

ex if i chose Shape from the drop down list I can only chose Circle, Rectangle.. (i dont want the other option to appear).

thank you so much for your help
prajyot 132 on at

Like
a
(0)

Report
Copy link

Link copied!

You can add 2 dropdownbox on the screen.
e.g. Dropdown1 , Dropdown2.
Set Items for Dropdown1 - Table({Text:"Colors",value:1 },{Text:"Numbers",value:2},{Text:"Shapes",value:3})
Set Items for Dropdown2 - If(Dropdown1.SelectedText.Text="Colors",Table({Text:"Red"},{Text:"Blue"},{Text:"Black"}),If(Dropdown1.SelectedText.Text="Numbers",Table({Text:"1"},{Text:"2"},{Text:"3"}),Table({Text:"Triangle"},{Text:"Circle"},{Text:"Rectangle"})))

Hope it helps !
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.

Thank you !
Prajyot
WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@redaelaouane

Yes, that is exactly what I understand and as I mentioned, you need to tell Power Apps "what matches what". The code I gave you was an option using a "hard-code" in the Items of the second drop-down. The other option (as I mentioned) is to have a List like this - I will call it ChoiceFields here)

Type

Item

Colors Red

Colors Blue

Colors Black

Numbers 1

Numbers 2

Numbers 3

Shapes Triangle

Shapes Circle

Shapes Rectangle

then the Items of the First Drop-down

Distinct( ChoiceFields, Type )

the Items of the second drop-down

Filter( ChoiceFields, Type = Dropdown1.Selected.Result ).Item

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