News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Can't open SQL Connect...

Power Automate - Building Flows

Unanswered

Can't open SQL Connection

(0) Share

Report

Report

Posted on by CC-22111719-0

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?

Categories:

Business Process Flows

All responses Img

All responses (0)

Answers Img

Answers (0)

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Announcing Mentions and Quick Responses!

Give Back to the Community this Month

Join us in the Community for an AMA: December 12th Register Today

Quick Links

Leaderboard

#1

WarrenBelz 143,591

#2

RandyHayes 76,308

#3

Pstork1 64,090

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans