cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ingovals
Helper II
Helper II

WebApi $Filter on MultiSelectPicklistAttribute

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?

2 REPLIES 2
GuidoPreite
Super User
Super User

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.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (4,019)