I have another field (List of Skills) which is a list of another data type (Skill) that isn’t working so well as the source for another multiselect dropdown when I try to filter the RG.
I tried creating an option set (Skills List) for this one but as a person can have multiple skills, the field I created to try this out is a List of Skills Lists.
The ‘contains’ expression only works when the list of items you’re filtering by (in your case the candidates list of skills), contains a specific item (skill) - such as one selected from a single-item dropdown. It won’t work when the search constraint is a list (as in a multidropdown’s value).
In order to match a list to a list you need to use either ‘contains list’ (if you want the first list to contain ALL the items from the second list), or ‘intersect with’ :count >0 (if you want the first list to contain ANY of the items from the second list) - neither of which (unfortunately) can be done on the search - they have to be done in an advanced filter on the returned results instead.
