You’re offline. This is a read only version of the page.
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?
Thanks
AJ
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
Hello agupta111
Are you consulting contain function in Filter Query? You could refer to below expression
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/
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
Share
Report
All responses (
Answers (
