Cascading dropdown with SharePoint Choice columns?

[Rob_CTL]

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)

As you can see they are both Choice columns

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

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.

[v-siky-msft · Accepted solution]

@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

[Rob_CTL]

Thanks @v-siky-msft 👍

[SaschaGeng]

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

Regards Sascha