cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
esuna114
Frequent Visitor

Salesforce - filter records based on multi select ODATA query

Hello community !

 

I'm trying to use the Filter Query of the Salesforce Get Records connector on a Multiselect picklist field.

Say the field is Color__c and the different choices are blue, red, white, yellow, I would like to return all records which contain "blue"

 

So far I do Color__c eq 'Blue' but it returns something that only strictly contains 'blue', and not 'blue','yellow' etc...

 

I have tried other method described in ODATA, like substring(), includes, none of them work but maybe I did not use it correctly. 
If there is also a workaround without using the ODATA query I would be curious

 

Thanks a lot for your help !

 

Edit - Sorry if I did not put this in the right category, feel free to move it ! I'm new here.

4 REPLIES 4
esuna114
Frequent Visitor

Hello, no idea ?

 

Have a good day

Hello, I'd would be great if someone had pointers 🙂

esuna114
Frequent Visitor

Hello, any ideas?

CosminP
Microsoft
Microsoft

@esuna114 

You can find the Filter Query documentation directly on the Salesforce connector documentation:

https://docs.microsoft.com/en-us/connectors/salesforce/#filter-and-lookup-predicates

 

I would also recommend you to take a look at the Known Issues and Limitation for the connector:

https://docs.microsoft.com/en-us/connectors/salesforce/#known-issues-and-limitations

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Users online (1,135)