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 , many thanks! You also saved my day!
Regards Sascha
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