cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

SQL Database not listed?

Reaching out to the brains trust for some help.

 

I've created connections to two SQL databases but only one shows up in the pick list for the Database name?

 

Any ideas why?

 

 
1 ACCEPTED SOLUTION

Accepted Solutions

Thanks - I managed to solve the problem.

 

The database can be selected by editing the selection on the action ie Insert Row (v2)

 

 

 

View solution in original post

6 REPLIES 6
Helper V
Helper V

Please try following : 

 

  • Try removing second sql connection and add it again.
  • Make sure you have SQL Server services running on server. 
  • Create case with  Microsoft Support 

Let me know if above works.

Please go through below link as well for limitation of SQL Server connection.

 

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

 

Why would they be visable and active in Powerapps but not Power Automate?

Looking at issue , it could be data glitch from Microsoft . I would suggest you to create a case with Microsoft.

Community Support
Community Support

 

Hi @KarlNixon ,

 

I am afraid I did not understand your intention. As far as I know, a connection corresponds to a Database name, so only one Database is expected to appear in the Database name drop-down list.

 

What authentication method do you choose? If you use SQL Server Authentication and Windows Authentication, we also specify a separate database when creating a connection, so a connection corresponds to only one database.

187.PNG

 

Best Regards,

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

Thanks - I managed to solve the problem.

 

The database can be selected by editing the selection on the action ie Insert Row (v2)

 

 

 

View solution in original post

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Kudoed Authors
Users online (37,071)