web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Filter query in salesf...

Power Automate

Answered

Filter query in salesforce get records

(0) Share

Report

Report

Posted on by Mazh

12

Hi all,

I wish to search in Salesforce some client with their Name, i don't want to use the "eq" operator beacause sometime there is a "Mr" or "Ms" foward his name, so i want to use "contains" operator, but i got this error :

it seems like weird...

is anyone have a solution ?

Thanks you for your answer !

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Expiscornovus 33,830 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Mazh,

I believe the Get Records action uses OData Filter Queries. Can you try the query in this format and see if that works?

contains(Name, 'Louis') and (ActualStatus__c eq 'Signed')

Was this reply helpful? Yes No
Mazh 12 on at

Like (1)

Report
Copy link

Link copied!

I tried this solution today and it seems like it work !
Here is the solution :

Thanks you for your time @Expiscornovus 🤗

Was this reply helpful? Yes No

Join the conversation