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
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
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, August 21st at 8am PDT

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

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

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

SixthImage

Power Summit Australia 2019

August 20-23rd 2019

Users Online
Currently online: 273 members 3,586 guests
Please welcome our newest community members: