how to replace single quote with double quote in sql query while using power automate desktop

(0) Share

Report

Posted on by MitheshRpa

162

select * from Table's

was we need to pass double quotes , i just want to replace in query itself

select * from Table''s

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (0)

VishnuReddy1997 2,656 Super User 2025 Season 2 on at

Like (0)

Report
Hi @MitheshRpa ,

Please find the attached solution.

Code:

Database.Connect ConnectionString: OLEDB_ConnectionString Connection=> SQLConnection Text.Replace Text: $'''select * from [Sheet0$] WHERE [Type] <> \'e-Remito\';''' TextToFind: $'''\'''' IsRegEx: False IgnoreCase: False ReplaceWith: $'''\"''' ActivateEscapeSequences: False Result=> Replaced_Query @@copilotGeneratedAction: 'False' Database.ExecuteSqlStatement.Execute Connection: SQLConnection Statement: Replaced_Query Timeout: 30 Result=> QueryResult Database.Close Connection: SQLConnection

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
MitheshRpa 162 on at

Like (0)

Report

Without using replace text activity , can i replace direcly in query ?

Was this reply helpful? Yes No
VishnuReddy1997 2,656 Super User 2025 Season 2 on at

Like (0)

Report

Hi @MitheshRpa ,

I don't think so we can do it. @Deenuji can you please confirm this.

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report

@MitheshRpa

Could you please provide more details about your use case? Why do you need to replace double quotes with single ones? Even if you add them manually, wouldn't it work without any syntax issues? Could you elaborate on your use case so that we can assist you in a more appropriate manner?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No