Apostrophe in variable passed into SQL query generates error

(0) Share

Report

Posted on by chrisevans10

Have a SQL table that PAD is querying. Column A contains string values, in some of the rows apostrophes are used.

I am then using those data values to perform an additional query in a completely separate flow.

However I then get an error that indicates it has not been escaped properly:

I have tried running the query with the variable in double quotes "%example%" and with the variable in single quotes '%example%'. I have also tried replacing the apostrophe with two, as has been suggested on PA (but not PAD) pages but to no avail.

Any suggestions?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

UshaJyothiKasibhotla 225 Moderator on at

Like (0)

Report
Copy link

Link copied!

Could you please send me the query you have written?

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Based on the following article, you can escape a single quote character by replacing it with two single quote character (not a single double quotes character). You can do that by using Replace text on your variable and replacing ' with ''

See the reference here: https://www.databasestar.com/sql-escape-single-quote/#:~:text=The%20simplest%20method%20to%20escape,Server%2C%20MySQL%2C%20and%20PostgreSQL.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No