I have two multi select columns with the same exact values listed and if a value is selected in the first then I want that value removed from the second. Here is what I am using but it only works for the first value selected so if more than one is selected it only removes one value. This is the condition I have in the datacardvalue Items. Any suggestions would be appreciated.
If("Dental" in DataCardValue12.SelectedItems.Value,Filter(Choices([@'UMR Exception Intake Form'].'Other Specialty Products'),
Value <> "Dental"),
"Vison" in DataCardValue12.SelectedItems.Value,Filter(Choices([@'UMR Exception Intake Form'].'Other Specialty Products'),
Value <> "Vision"),
"Life" in DataCardValue12.SelectedItems.Value,Filter(Choices([@'UMR Exception Intake Form'].'Other Specialty Products'),
Value <> "Life"),
"Disability" in DataCardValue12.SelectedItems.Value,Filter(Choices([@'UMR Exception Intake Form'].'Other Specialty Products'),
Value <> "Disability"
),"Other" in DataCardValue12.SelectedItems.Value,Filter(Choices([@'UMR Exception Intake Form'].'Other Specialty Products'),
Value <> "Other"))
