I’m really stuck on something that ( I think!! ) should be so simple. I want the repeating group to be filtered and NOT show the items ( more than one ) in the multi drop down.
I can only manage this the one multi-drop down item, but if I add more it just doesn’t work. I’ve played around with items from, items until etc etc but nothing seems to work.
Hi there, @emma.heslop… one way to do what you have described is to use an advanced filter. So, you would remove the constraint you are showing in the third screenshot and add the :filtered operator to the end of your repeating group’s data source/search. Then, add a constraint to the filter and select the Advanced option from the dropdown. Finally, construct an expression that looks something like Advanced: This CRM Data's Company Lead Status intersect with MultiDropdown MultiDropdown Choice's value:count is 0.
Oh, and just food for thought, but if it was me, I would likely use an option set to define the multidropdown’s options, and I would create a new Company Lead Status field that is linked to the option set. If you aren’t familiar with option sets, definitely check them out because they are super useful.
If that field can only have one value, it makes things easier, but I would go the option set route at this point.
If you create an option set to define the options for the multidropdown and you create a new Company Lead Status field that is tied to the option set (but is not a list), then a simple constraint on the repeating group’s data source/search will do the trick (that is, you don’t need an advanced filter). The constraint would be Company Lead Status isn't in Multidropdown Multidropdown Choice's value.
