Cascading Dropdowns based on Lookup columns in a SharePoint Form

[jpacettf]

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!

[TimRohr · Accepted solution]

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]

Worked great thanks for the help!