cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

SQL Connection failed when editing Flow - "Test Connection Failed"

I have a flow that works.  I need to edit the flow.  When I edit, an error appears over the SQL Get Rows action"Test connection failed".  It will not let me save the flow due to this error.  I have a feeling this has something to do with the new licensing.  I get completely lost in these details of licensing.  I'm worried.  That all of this is going to become suddenly hyper-expensive.

 

https://docs.microsoft.com/en-us/power-platform/admin/powerapps-flow-licensing-faq

 

image.png

 

Like I said, when i run the flow, it works fine.  Also, connections look ok.

 

image.png

 

Can anyone shed some light on this?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: SQL Connection failed when editing Flow - "Test Connection Failed"

I cannot put my finger on exactly what happened, but after messing around in the Flow, I went to my connections, and the connection was gone!  I know it was there before, because the flows were working fine just prior to my attempt to edit.  I even tested it after the failure to edit and save and it was still working...

 

Regardless, I know I did not actually delete it from the Connectionss list.  Anywho, I recreated the connection, and recreated the action.  All is well.

 

I actually have about 70 flows.  About half use SQL actions.  Once I recreated the connection, there was no problem in any of the other flows.  Most of those use the V1 actions.  I'll keep an eye on it, and move to V2 only if things start showing some signs of instability.  I have learned thorugh experience that if things are not broke, DONT try to fix them.  It will only cause you more trouble!

 

Thanks for the comments!

View solution in original post

4 REPLIES 4
Super User
Super User

Re: SQL Connection failed when editing Flow - "Test Connection Failed"

This is also happening with new actions.  

 

image.png

 

 

 

image.png

Super User
Super User

Re: SQL Connection failed when editing Flow - "Test Connection Failed"

More info I found:

 

https://powerusers.microsoft.com/t5/General-Power-Automate/Flow-SQL-connector/m-p/387572

 

Issue is... how much is this going to cost?  I dont think you can even get an automate plan yet.  Trial only???

Highlighted
Community Support Team
Community Support Team

Re: SQL Connection failed when editing Flow - "Test Connection Failed"

Hi @martinav,

 

It seems like the issue is caused by the SQL server connection change into a premium connector.

 

I find your first reply is using Get row action, this action has been deprecated, it seems like the action was created before the SQL connector changed, so you can see it still exist in your Flow, you can delete it and try to use Get Rows(V2) action.

https://docs.microsoft.com/en-us/connectors/sql/#actions

 

I just tested on my side to use Get rows(V2) to get all rows of a SQL table, the connection is old, but it works well, so maybe the error in the reply 2 is caused by the connection itself, changed gateway, changed password, etc. You can reconfigure it and try it again:

Annotation 2020-01-10 095526.png

 

And you are search the license details, this is the PDF file of the licensing guide, you can download it to see more details.

https://go.microsoft.com/fwlink/?linkid=2085130

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User
Super User

Re: SQL Connection failed when editing Flow - "Test Connection Failed"

I cannot put my finger on exactly what happened, but after messing around in the Flow, I went to my connections, and the connection was gone!  I know it was there before, because the flows were working fine just prior to my attempt to edit.  I even tested it after the failure to edit and save and it was still working...

 

Regardless, I know I did not actually delete it from the Connectionss list.  Anywho, I recreated the connection, and recreated the action.  All is well.

 

I actually have about 70 flows.  About half use SQL actions.  Once I recreated the connection, there was no problem in any of the other flows.  Most of those use the V1 actions.  I'll keep an eye on it, and move to V2 only if things start showing some signs of instability.  I have learned thorugh experience that if things are not broke, DONT try to fix them.  It will only cause you more trouble!

 

Thanks for the comments!

View solution in original post

Helpful resources

Announcements
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (7,115)