Apostrophe removed through replace but no records returned

(0) Share

Report

Posted on by WCEDsystems

I've created a flow that grabs the address from a sharepoint list off an entry. The address sometimes has an apostrophe in it and that causes the filter query to fail. If I replace the characters to solve the apostrophe issue, then the filter query does not return any records.

For example ->
Initial Address Variable: 244 O'Briens Rd
EscapedAddress Variable (used in Filter Query): 244 O Briens Rd

There is no record within my sharepoint list with the address 244 O Briens Rd, so no records are returned. How is this solved?

Screenshot 1.png

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report

Re: Apostrophe removed through replace but no records returned

Hi @WCEDsystems ,

Please use ’‘ for the character ’

Best Regards,

Bof

Was this reply helpful? Yes No