Escaping apostrophes or single quotes in filter clause

[bfausti]

I am having issues trying to escape an apostrophe in a property address for a filter in my flow.

Here is how I am trying to escape it:

bapps_propertyname eq replace('@{triggerOutputs()?['body/gbca_propertyname']}','''','\''')

Here is my flow step:

Here is the error after the flow runs:

Error details:

Any help would be much appricated

Cheers

[SudeepGhatakNZ]

I know it might sound hilarious but you have to replace it with 4 single quotes (with two wrapped around so 6 in total)

replace(variables('YourField'),'''','''''')

[benfausti]

Thank you but tried this and it doesn't work, see below errors:

Any other suggestions?

[benfausti · Accepted solution]

Ok, I worked it out. The replace function needed to be inside the single quotes on the eq clause:

This:

bapps_propertyname eq '@{replace(triggerOutputs()?['body/gbca_propertyname'],'''','''''')}'

Instead of this:

bapps_propertyname eq replace('@{triggerOutputs()?['body/gbca_propertyname']}','''','''''')

Thank you for your help 🙂

[SudeepGhatakNZ]

Awesome, can you please mark it as a solution so that it benefits others in the community?

[benfausti]

**Ignore this**

I did try to but don't see the option anywhere?

[SudeepGhatakNZ]

You need to select the post with my response.