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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Filter query with Apso...
Power Automate
Answered

Filter query with Apsotrophe

(0) ShareShare
ReportReport
Posted on by 18

Hello,

 

I am trying to retrieve records from CDS using a filter query. The query is failing with the "Syntax error at position 26 in 'spe_description eq 'Jame's test record' and spe_level eq 100000000 and spe_foflag eq true"

 

What is the work around to filer the records for the string which contains apostrophe? 

 

agupta111_0-1598046084564.png

 

Thanks

AJ

 

 

Categories:
I have the same question (0)
  • Verified answer
    Sutherland Profile Picture
    Microsoft Employee on at

    Hello agupta111

    Are you consulting contain function in Filter Query? You could refer to below expression

    Johnnyg_0-1598196490237.png

    related blog for reference:
    https://diyd365.com/2019/11/20/every-power-automate-ms-flow-filter-query-you-ever-wanted-to-know-as-a-functional-consultant/
    https://www.cloudfronts.com/using-contains-filter-query-in-ms-flow/

     

     

  • Verified answer
    MJain Profile Picture
    2,450 on at

    Hi @agupta111 ,

     

    Please follow the approach mentioned in either of following urls:

     

    https://www.inogic.com/blog/2019/07/replace-single-quote-from-attribute-in-microsoft-flow/

     

    https://sharepains.com/2019/10/07/handling-apostrophes-in-microsoft-flow/

     

    Thanks

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 286

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard