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
