cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

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
Solution Sage
Solution Sage

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
Solution Sage
Solution Sage

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

Highlighted

Worked great thanks for the help!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (11,806)