Get Items filter query is getting failed when filter value contains single code value

(1) Share

Report

Posted on by RamKan2021

102

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,

All responses (3)

Answers (1)

RamKan2021 102 on at

Like (1)

Report

Re: Get Items filter query is getting failed when filter value contains single code value

Thanks Sanmesh for the quick reply and solution , it is working fine.
Verified answer

SanmeshG 1,947 Super User 2025 Season 1 on at

Like (1)

Report
Re: Get Items filter query is getting failed when filter value contains single code value

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 ,

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
creativeopinion 10,439 Super User 2025 Season 1 on at

Like (1)

Report

Re: Get Items filter query is getting failed when filter value contains single code value

@RamKan2021 Can you share a screenshot of your flow? It's hard to offer any recommendations without seeing the error. If you are using the new designer, toggle it off and click each action to expand it. Upload a screenshot of your flow in edit mode and the error you are receiving, it would help to provide more insight.

Also, is your flow actually failing? If so, what is the error. Or is the Get Items action just not returning any results.

You will need to use the internal column name of the column you are using in your filter query field. Keep in mind that the internal column name may not always match the name displayed in your Sharepoint list. If you aren't sure how to get the Internal Column name, you can refer to this section of one of my YT Tutorials.

Not sure how to write a filter query? Check out this YT short.

In the meantime, you may be interested in this YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

In this Power Automate tutorial, I explore 5 frequently asked questions that pop up when troubleshooting a flow. If you’d like to to level up your Power Automate flow skills and learn how to troubleshoot your Power Automate flow—this tutorial is for you!

IN THIS VIDEO:

✅ How to troubleshoot a false Condition action result

✅ How to get dynamic content when it isn’t selectable from the list of dynamic content

✅ How to troubleshoot an Apply to Each action that isn’t looping through

✅ How to troubleshoot a skipped Apply to Each action

✅ How to troubleshoot a Filter Query

✅ How to use a SharePoint yes/no column in a Filter Query

✅ How to use Compose actions to troubleshoot a Power Automate flow

✅ How to troubleshoot multiple emails being sent

✅ How to troubleshoot multiple Teams messages being sent

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram