Dec 12 2020
I am trying to restrict the user entering data into my power app by filtering the choices. So for example I have two lists.
The Product details list has two columns:
The product list could be as follows
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
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