cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jpacettf
Level 8

Cascading Dropdowns based on Lookup columns in a SharePoint Form

I have created Cascading Dropdowns from a SharePoint List titled: 'Promoter and Organiser Directory'

 

This list has 4 columns in titled:

 

Company (Title)

Contact

Email

Telephone Number

 

First of all I want to make sure that I am able to create cascading drop downs with a SharePoint List that has more than 2 columns?

 

Secondly, I seem to be having a problem with my second drop down. It has the correct number of values but they are all blank. Formulas are below:

 

PromoterdDropDown:

Items:  Distinct('Promoter and Organiser Directory',Title) - Pulls through list of Companies fine.

 

DropDown3:

Items: Filter('Promoter and Organiser Directory', Title=PromoterDropdown.Selected.Value)

 

Screenshot Attached.

 

I have been wracking my brain for hours, it is probably something very simple!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
TimRohr
Level 10

Re: Cascading Dropdowns based on Lookup columns in a SharePoint Form

Yes, you can drive one dropdown's available options based on the selection in another.

 

Try this for the Items property of DropDown3:

Filter('Promoter and Organiser Directory', Title=PromoterDropdown.Selected.Title)

 

Also, make sure that you have the right field in the "Value" property for each of your dropdowns.

 

(as a side-note, it looks like you're trying to use a textbox and a drop down to mimic the built-in functionality of a combobox... allowing typing to find an entry. If so, it might be quicker/easier and require less screen real-estate to go with a combo instead.)

2 REPLIES 2
Highlighted
TimRohr
Level 10

Re: Cascading Dropdowns based on Lookup columns in a SharePoint Form

Yes, you can drive one dropdown's available options based on the selection in another.

 

Try this for the Items property of DropDown3:

Filter('Promoter and Organiser Directory', Title=PromoterDropdown.Selected.Title)

 

Also, make sure that you have the right field in the "Value" property for each of your dropdowns.

 

(as a side-note, it looks like you're trying to use a textbox and a drop down to mimic the built-in functionality of a combobox... allowing typing to find an entry. If so, it might be quicker/easier and require less screen real-estate to go with a combo instead.)

jpacettf
Level 8

Re: Cascading Dropdowns based on Lookup columns in a SharePoint Form

Worked great thanks for the help!

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, September 18th at 8am PDT

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 283 members 4,674 guests
Please welcome our newest community members: