Hello
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.
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/operators
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
"Tests:
" & (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 yields
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.
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/working-with-tables
The same applies to the "exactin" operator, see for example another Label with Text
"Tests:
" & (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:
https://powerusers.microsoft.com/t5/Building-PowerApps-Formerly/quot-in-quot-operator-not-working-for-OptionSetValue-with-quot/m-p/269965
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.
