I'm trying to create a copilot flow that runs a power automate flow with a sql connection.
The power automate flow does a sql server connection nothing special. It works properly if a test it from the power automate console. Is a simple query to get some data.
Test result
The power automate sql fragment flow
The problem
when add the power automate flow to a certain copilot studio topic flow
And I tried to excecute the flow it requests to add the connection to sql
So when open the connection manager I get the power automate flow to add the connection
Adding the same connecton used in the power automate flow and click the submit button
What can I see on console is a testconnection 200 response
Got the valid connection mark
Matching with the valid connection simbol
But Whenever I pick a connection I got the same not conected message.
Also I got in console this 500 error. There is a place to report this issue?
Share
Report
All responses (
Answers (
525
