You’re offline. This is a read only version of the page.
1. I am using getitems to retrive the value from a Sharepoint List with a column 1 with Single code value.
2. When i am using column 1 in the filter query , flow is getting failed where ever column values are having data with single code.
Example : Column name is Company. Values are follows
1. Company Test 1
2. Company 'Test 2'
3. Company Test 3
Flow is getting failed while retriving value for Company 'Test 2'.
Kindly help here,
Hi @RamKan2021 ,
If you are trying to create an OData filter query with single quotes in your dynamic content , then try replacing the single quotes in the expression with another single quotes which will eventually create an escape sequence for the content in single quotes.
Adding the screenshot and the expression for your reference ,
Share
Report
All responses (
Answers (
Title eq '@{replace(triggerOutputs()?['body/Title'], '''', '''''')}'
Hope this helps , do give this a thumbs up and mark this response as a solution if this answers your question.
Thanks,
Sanmesh
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
