Showing results for 
Search instead for 
Did you mean: 
Impactful Individual
Impactful Individual

"in" and "exactin" still don't work for (new) OptionSetValue


Please be so kind as to read my full post before responding.
Thank you for your consideration.

Since already several versions, "Relational data, options sets, and other new features for CDS", is, by default, turned on.
This changes all option set values to the new OptionSetValue type.
The "in" and "exactin" operators don't seem to be working with this OptionSetValue type.

I want to use this to test if certain values are selected in CDS/Dynamics multiselect option set fields.

To give an example, in CDS, I have a global option set "optionset 01" with options "01.01" through "01.10".
In PowerApps, single values can be obtained with "'optionset 01'.'01.01'" through "'optionset 01'.'01.10'".
All values can be obtained with "Choices('optionset 01')".
I have set a Label with Text

" & (1 in [1] ) & "
" & (true in [true]) & "
" & ("Test" in ["Test"]) & "
" & ('optionset 01'.'01.01' in Choices('optionset 01')) & "
" & ({Value: 'optionset 01'.'01.01'} in Choices('optionset 01')) & "
" & (!IsEmpty(Filter(Choices('optionset 01'), Value='optionset 01'.'01.01'))) & "
" & ('optionset 01'.'01.01' in ['optionset 01'.'01.01']) & "
" & ({Value: 'optionset 01'.'01.01'} in ['optionset 01'.'01.01']) & "
" & (!IsEmpty(Filter(['optionset 01'.'01.01'], Value='optionset 01'.'01.01')))

This yieldsimage.png

As visible in this screenshot, the "in" operator does not seem to work for the option set values in the same way as for numbers, booleans or strings.
Also, please note the workarounds

({Value: 'optionset 01'.'01.01'} in Choices('optionset 01')) &&
(!IsEmpty(Filter(Choices('optionset 01'), Value='optionset 01'.'01.01')))

which yield the correct result.
Apparently, comparison of option set values with "=" works, and thus, using the "record version of in" or Filter with explicit comparison with "=" both work.

It appears as if the comparison against the column Value of the "Inline value tables", such as also returned by Choices, or used as representation of multiselect option set fields, doesn't yet properly work.

The same applies to the "exactin" operator, see for example another Label with Text

" & (1 exactin [1] ) & "
" & (true exactin [true]) & "
" & ("Test" exactin ["Test"]) & "
" & ('optionset 01'.'01.01' exactin Choices('optionset 01')) & "
" & ({Value: 'optionset 01'.'01.01'} exactin Choices('optionset 01')) & "
" & ('optionset 01'.'01.01' exactin ['optionset 01'.'01.01']) & "
" & ({Value: 'optionset 01'.'01.01'} exactin ['optionset 01'.'01.01'])


Please see also this earlier post on the same issue:

Please note that this post is more a information to fellow PowerApps users and complaint/bug report for the backend team.
I don't need "help".
I do have a workaround.

Last tested with
PowerApps Release: 3.19093.16
App Id: 854c44bd-1067-46f2-a8b8-b4f1aa77dbb1
Session ID: 26a25700-94c4-4bbe-aed4-3c393e08d11e

Thank you,
     Sa Wu.

Community Support
Community Support

Hi @SaWu ,

Thanks for your sharing.


Yeah, you are right. The 'in' operator has not been supported to compare a Option Set value with a OptionSetValue result (e.g. Choices('Option Set Name')).


If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:


As an alternative solution, I agree with you. I would also share your solution to other users who facing this issue.


Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Impactful Individual
Impactful Individual

Hi @v-xida-msft 

I don't really see why it is necessary to suggest this "feature", which I would have assumed to be natural and currently buggily missing, as an idea, but I did it anyway:


Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,987)