cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
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.)

View solution in original post

2 REPLIES 2
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.)

View solution in original post

jpacettf
Level 8

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

Worked great thanks for the help!

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Kudoed Authors
Users Online
Currently online: 272 members 5,527 guests
Please welcome our newest community members: