web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / What is the syntax for...
Power Automate
Unanswered

What is the syntax for an Odata filter in a CDS Get Records component ?

(0) ShareShare
ReportReport
Posted on by 22

I want to get specific records from a custom entity using the Common Data Service "get records" component

In my "filter" field, i'm entering :

new_countrycode eq '@{body('SelectAccount_Country')?['new_code']}' AND ( startswith(new_postalcode,'@{body('SelectedAccount')?['address1_postalcode']}') eq true OR new_postalcode eq null)

 

The idea is to get all the records with the right countrycode, and with either no postalcode, or a postalcode starting with a specific string.

 

But my filter syntax is wrong, and I don't know how to fix it. Could someone tell me what I'm doing wrong plz?

Categories:
I have the same question (0)
  • Verified answer
    abm abm Profile Picture
    32,858 Most Valuable Professional on at

    Hi @tissanfr 

     

    Believe your Boolean filter is true change this to 1.

     

    Thanks

  • v-bacao-msft Profile Picture
    on at

     

    Hi @tissanfr ,

     

    Have you tried changing true to 1 and seeing the Flow run history?

    Please take a try and feel free to let us know if the issue still exists.

     

    Best Regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard