Salesforce - filter records based on multi select ODATA query

(0) Share

Report

Posted on by esuna114

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.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

esuna114 12 on at

Like (0)

Report

Hello, no idea ?

Have a good day

Was this reply helpful? Yes No
esuna114 12 on at

Like (0)

Report

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

Was this reply helpful? Yes No
esuna114 12 on at

Like (0)

Report

Hello, any ideas?

Was this reply helpful? Yes No
CosminP Microsoft Employee on at

Like (0)

Report

@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

Was this reply helpful? Yes No
tanyapammy1 2 on at

Like (0)

Report

Hi @esuna114 , @CosminP ,
Hope you found the solution. I have requirement to query all the values of the multiselect picklist based on filter applied on another column like ID and sync these values to data in Smartsheet . Wanted to check if this is something achievable through PowerAutomate.
Thanks,
Tanya.

Was this reply helpful? Yes No