Can I filter on the multiselect choices columns in the web api.
It is not handled like a string ( even though the return value looks like a csv string) so
contains(column_name, 'myvalue')
does not work.
It is not handled like a collection so
column_name/any()
does not work.
Anything that could work here?
you can use my tool Dataverse REST Builder to check the syntax
also with just the Demo version, the Custom Table has the column "Choices" that is a multiselect
Brilliant.
So the answer is
Microsoft.Dynamics.CRM.ContainValues(PropertyName='column_name',PropertyValues=['myvalue'])
Thank you, very helpful.