Answered

Escape Single Quote in Attribute Value

(0) Share

Report

Posted on by DeliriumTremens

I have a flow that lists rows from a SQL table, then for each record determines if it should use Custom Data Service to update an entity in Dynamics.

Part of this flow is to List Records with CDS and with a Filter Query compare the city name from SQL with the city name attribute on the Entity. The problem is when I try to do: , which is a field from the SQL query, it will fail if the city name has a single quote in it. What is the best way to tell Flow to escape single quotes in the attribute value AddressCity if they exist? I'd like to avoid simply removing the character from city names if possible.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@DeliriumTremens

Please see this post as I believe it will provide you with a solution.

Was this reply helpful? Yes No
Verified answer

DeliriumTremens 11 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply Scott --

The first solution in that post, which I had tried previously, involves adding a \ to escape the single quote, however when I do that the flow then attempts to escape the \ on its own, messing up the comparison
The second solution in that post was a nonstarter, and far more complicated than I felt it should be.

After spending a questionable amount of time on it, the solution that eventually worked for me was to do replace(attribute,'''','''''') so that the Filter Query expression would successfully compare the two values.

It would be nice if something like a single quote in a string would knowingly cause issues in a Filter Query expression, that Flow would know to escape it on its own instead of requiring the user to kludge a fix on their own.

Was this reply helpful? Yes No