User Profile
OHD79
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
How to create casacding drop downs basesd on a multi select lookup table
Hi, I am trying to restrict the user entering data into my power app by filtering the choices. So for example I have two lists. List 1: Product Details List 2: Records The Product details list has two columns: Column 1: Category Column 2: Product (Multi select lookup from a product list) The product list could be as follows Category Product Cat1 Prod1 Cat2 Prod2 Cat3 Prod3 Cat4 Prod1, Prod2 Cat5 Prod1, Prod3 Cat6 Prod2, Prod3 So, what i want to do is select Prod1, Prod2 or Prod3 from a drop down list "Product" and for drop down list "Category" to update with the appropriate Cat# values. So for example if Product drop down = Prod2 Category drop down = Cat2, Cat4, Cat6 When the select has been made I will save the form to the "Records" sharepoint list. I can get this working without "multi select" in the "Product Column" but it would mean adding allot more records to the "Product Details" list to cover all product to category relationships. The issue is the multi select values will not display in a drop down to enable filtering. Any help will be appreciated
Groups
Recent Blog Articles
No content to show