web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate how to convert string ...

Power Automate

Unanswered

how to convert string variable to sql connection string?

(0) Share

Report

Report

Posted on by MitheshRpa

162

I had sql connection variable in string format! how can i convert it and use in execute sql statement (SQL COnnection) ?

Categories:

Power Automate Desktop

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

VishnuReddy1997 2,656 Super User 2025 Season 2 on at

Like (1)

Report
Hi @MitheshRpa ,

Please find the below solution.

Code:
SET Excel_A_File_Path TO $'''C:\\Users\\OneDrive\\Desktop\\Power Automate Desktop\\Practice\\Database\\Excel A.xlsx''' SET OLEDB_ConnectionString TO $'''Provider=Microsoft.ACE.OLEDB.12.0;Data Source=%Excel_A_File_Path%;Extended Properties=\"Excel 12.0 Xml;HDR=YES\";''' Database.Connect ConnectionString: OLEDB_ConnectionString Connection=> SQLConnection @@copilotGeneratedAction: 'False' Database.ExecuteSqlStatement.Execute Connection: SQLConnection Statement: $'''select * from [Sheet0$] WHERE [Type] <> \'e-Remito\';''' 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

I had 10+ sql connection, I am using sql connection and storing the value in dictonary !!!

I want to call the connections which is in string format to sql connection data type

Was this reply helpful? Yes No

Join the conversation