cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rob_CTL
Helper V
Helper V

Cascading dropdown with SharePoint Choice columns?

Hi,

 

What I thought would be a simple process is proving more of a challenge than I expected.  I am trying to setup cascading drop downs (which is nice and easy with simple columns) using SharePoint choice columns.

 

Configuration:
In SharePoint I have the these two columns (Location and Vendor)
pa-col1.png

As you can see they are both Choice columns

pa-col2.png

In PowerApps I have a couple drop downs, the first is connected to the "Location" column and the second connected to "Vendors"

pa-col3.png

What I am looking to achieve is when a location is selected the "Vendor" drop down is filtered to only show the vendors that are present in that location, in the example above when I select "USA" the Vendor drop down should display Vendor1 and Vendor2.

 

The ITEMS property on "Locations" dropdown is set to:

 

Choices(Test.Location)

 

The ITEMS property in "Vendor" drop down is set to:

 

Filter(Test, Location = Dropdown1.Selected.Value).Vendor

 

But this doesn't work  because the Choice column is a table rather than simple text.  I understand that I can't filter the actual choices value within the columns but there must be a way to filter the values in the columns?

Any tips on how I can filter these columns, or just confirmation that what I am trying to do is even possible.

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-siky-msft
Community Support
Community Support

@Rob_CTL 

 

Please set the Items property of "Vendor" drop down as below:

 

Filter(Choices(Test.Vendor),Value in Filter(AddColumns(Test,"T1",Vendor.Value), Location.Value=DropDown1.Selected.Value).T1)

 

Sik

View solution in original post

3 REPLIES 3
v-siky-msft
Community Support
Community Support

@Rob_CTL 

 

Please set the Items property of "Vendor" drop down as below:

 

Filter(Choices(Test.Vendor),Value in Filter(AddColumns(Test,"T1",Vendor.Value), Location.Value=DropDown1.Selected.Value).T1)

 

Sik

View solution in original post

Thanks @v-siky-msft 👍

SaschaGeng
Regular Visitor

@v-siky-msft , many thanks! You also saved my day!

Regards Sascha

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,910)