Show values based on Select formula = Formatting EnumList view

[Pejme]

I have a few questions that I would appreciate help with.

These are my tables:

QUESTION 1
In the order table, I want the user to be able to chose what type of order is going to be made, and I want the dropdown to only show the products that are associated to the chosen type(s). I can get this to work if only on type is chosen.

But I can't get it to work when there are multiple types chosen. One issue that I get is because my current settings/formulas have problems  to Cannot compare Text with List in ([_THISROW].[Type] = [Type]).

The second problem is that even if I change everything to EnumList, then I will still not get all the correct products show. The Products field will not even show.

How can I be able to choose multiple types and have the product dropdown show the associated products to those types?

QUESTION 2
Is it possible to format the dropdown list to create paragraphs/new lines so each product is shown in a new row as per the cells in Google sheet?