Hi I'm trying to filter the options within a combobox based on whether the option contains the selected value of another combobox. So I have tried this but it does not return any value:
Filter(Choices([@'Register'].'Code'), DataCardValue7.Selected.Value in Choices([@'Register'].'Code'))
The intellisense does not show any issue in the formula but as I say the results bring back nothing. So for example if I were to choose Option 1 on the first combobox I would want to filter out only those choices that contained the text Option 1 etc.
Any points appreciated!