Unanswered

Apostrophe in filter query causing flow to fail

(0) Share

Report

Posted on by rencygonzalez

I have written the filter query in several ways and still my flow fails due to apostrophe in single line text field. My Get items action is within an apply to each action.

PrimaryLocation/Street1 is a lookup to a single line field called Street1.

I am writing my query as follows however my flow fails :

replace(items('Apply_to_each')?['body/Street1/Value'],'''','''''')

I have also tried this with no luck.

replace(items('Apply_to_each')?['body/Street1'],'''','''''')

I am really hoping someone can help.

thank you!

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (0)

efialttes 14,756 on at

Like (0)

Report

Hi @rencygonzalez !
So I guess you have probably followed the recommendation in this post with no luck, right?
https://powerusers.microsoft.com/t5/Building-Flows/Using-a-value-with-a-single-quote-as-an-Odata-filter-query/td-p/37043
If so, did you consider to forget about ODATA filter and add a 'Filter Array' action block after 'Get items 2' instead?

¡Ánimo!
==========

Was this reply helpful? Yes No
rencygonzalez 20 on at

Like (0)

Report

Hi! Thank you for your response! Yes I did try that post you had mentioned and it didnt work for me. Can you tell me what to put in the filter array?
Do you mean remove everything from the ODATA filter?

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report
What about this? Probably your value does not have a body.

replace(items('Apply_to_each')['Street1'],'''','''''')

If you leave out the question mark, you will see in the possible error message whether the property exists.

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report

Hi again @rencygonzalez !
You shall select 'Get items 2' 'value' output and assign it as 'Filter array' 'From' input. In order to show the 'dynamic content menu' just click inide the input, and then on 'add dynamic content' label

Next you need to build the 'Filter array' 'Condition rule'
You can keep default operator 'is equal to'
As right term you can add the following WDL expression : items('Apply_to_each')?['Street1/Value']. Please note you can select it also from the dynamic content menu, as we did before with 'Value'
For the left term I need more context info. I mean, it seems you are trying to compare two different SP columns per item, right? One is called 'Street1' and is of type lookup column, right? And the other perhaps is called PrimaryLocation, right?. How is this second column declared in your SP list? Is it also a Lookup? Is it a 'Single line of text? Please note you can select it also from the dynamic content menu, as we did before with 'Value'

Thanx!
====

Was this reply helpful? Yes No
rencygonzalez 20 on at

Like (0)

Report

Yes I am comparing two different columns. PrimaryLocation is in my list called Contacts. It is a lookup column to another column called Street1 in a different list. So I am trying to see if PrimaryLocation/Street1(lookup) is equal to Street1. Issue is , end users put apostrophe in the Street1 field and I need to remove those.
So like this?

Was this reply helpful? Yes No
rencygonzalez 20 on at

Like (0)

Report

thank you, I tried this and it still failed.

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report

Hi @rencygonzalez
Your attempt with 'Filter array' approach is almost ready!
However, if you declare the text 'PrimaryLocation/Street1' as the value for the left term, I am afraid the result will not be the one you expect. If the column is called 'PrimaryLocation' of type Lookup, you can try to add as left term value either a dinamyc content input that should be called 'PrimaryLocation value' -the same way you did it with the dynamic content 'Value' or add the following WDL expression: items('Apply_to_each')?['PrimaryLocation/Value']

Hope this helps!
==========

Was this reply helpful? Yes No