Skip to main content

Notifications

Community site session details

Community site session details

Session Id : LZdFkwCchYxhxEB3NRIjql
Power Automate - Building Flows
Unanswered

Can't open SQL Connection

Like (0) ShareShare
ReportReport
Posted on 22 Nov 2024 20:03:36 by
Hello, 
 
When I use the open SQL Connection action and use the build a connection string function within that, I input the correct SQL Database and got a test successful on it, However once closing that it says there is a Syntax error even though the database connected successfully during the test. This is my first time with Power Automate, and we have an azure instance. of SQL. I am attaching the screenshot of what it inputs to the connection string once I use the "build a string connection" function. What am I missing? 

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,513 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,606 Most Valuable Professional

Leaderboard
Loading started