Skip to main content

Notifications

Community site session details

Community site session details

Session Id : uuJzi7FJho/Kv+DpAypDie
Power Automate - Power Automate Desktop
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 23 Apr 2024 07:57:30 by 162

select * from Table's

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

select * from Table''s

 

  • Deenuji_Loganathan_ Profile Picture
    6,105 Super User 2025 Season 1 on 23 Apr 2024 at 10:06:52
    Re: how to replace single quote with double quote in sql query while using power automate desktop

    @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 🚀

     

     

  • VishnuReddy1997 Profile Picture
    2,324 Super User 2025 Season 1 on 23 Apr 2024 at 09:52:24
    Re: how to replace single quote with double quote in sql query while using power automate desktop

    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

  • MitheshRpa Profile Picture
    162 on 23 Apr 2024 at 09:12:14
    Re: how to replace single quote with double quote in sql query while using power automate desktop

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

    MitheshRpa_0-1713863522408.png

     

  • VishnuReddy1997 Profile Picture
    2,324 Super User 2025 Season 1 on 23 Apr 2024 at 08:36:32
    Re: how to replace single quote with double quote in sql query while using power automate desktop

    Hi @MitheshRpa ,

     

    Please find the attached solution.

     

    VishnuReddy1997_0-1713861313058.png

     

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Power Automate Desktop

#1
eetuRobo Profile Picture

eetuRobo 18 Super User 2025 Season 1

#2
John_Mavridis Profile Picture

John_Mavridis 6 Microsoft Employee

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 5 Super User 2025 Season 1

Overall leaderboard
Loading started
Loading complete