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

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