Answered

Limit Items in Dropdown #2 Per Selected Item in DD #1 (Forms)

(0) Share

Report

Posted on by cm2112

157

I am working on a canvas app with SharePoint list as my data source. I have dropdown menus in the context of a form that are SP choice columns. I'd like to limit the items in the Location dropdown based on the selection in the Area dropdown. When "Rail" is selected, Area dropdown will only display Rail Pump 1, Rail Pump 2, etc. Likewise, when "Truck" is selected, Area dropdown will only display Truck Door 1, Truck Door 2, etc.

// Area DD ITEMS Property
Choices([@'Strainer Logs'].Area)

// Location DD ITEMS Property
Choices([@'Strainer Logs'].Location)

Area dropdown control is DataCardValue16
Location dropdown control is DataCardValue17

Any recommendations are appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @cm2112,

Is text the only link between location and area? We could check whether the locations contain the value of the dropdown above:

//Items property of locations dropdown Filter( Choices([@'Strainer Logs'].Location), DataCardValue16.Selected.Value in Value )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
cm2112 157 on at

Like (0)

Report
Copy link

Link copied!

Thank you @LaurensM - I really appreciate your response.
The new code produced the following results:
- When Area = Rail, Rail Pump 1 selected in Location DD.
- When Area = Truck, Truck Door 1 selected in Location DD.

What I'm Looking For:
When Area DD selection = "Rail", I need to limit the items in the in Location DD so that only items that start with "Rail" are listed (i.e., Truck items are hidden). And vice-versa for Truck. Any additional insight is appreciated.

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @cm2112,

My code should take care of that requirement. Did you write it in the Items property of the dropdown?

When written there, the Items within the dropdown will be filtered based on the selection of the previous dropdown.

Normally this should not affect the DefaultSelectedItems property - did you change this property by any chance?

I hope this helps!

Was this reply helpful? Yes No
cm2112 157 on at

Like (0)

Report
Copy link

Link copied!

@LaurensM - My bad. I had it in the DefaultSelectedItems. It works great now. Thanks again for the solution!

Was this reply helpful? Yes No