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

Two azure databases connections return the same tables

I have a Azure SQL server with two database, DB1 and DB2, and I have created connections to these databases. And these connection works correctly on PowerApps

 

I tried to use action "SQL Get Tables" on both connections, they all return the tables from DB1, none from DB2. This has to be a bug

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Two azure databases connections return the same tables

Hi @manlamcheng,

 

Would you please share a screenshot of the configuration of your flow?

Do you mean when you use action "SQL Get Tables" on connection of DB2, the action would return the tables from DB1?

 

Please share more details and screenshot about it.

 

Best regards,

Alice

 

Highlighted
Helper I
Helper I

Re: Two azure databases connections return the same tables

yes, connections to different DBs get the same result from first DB

 

Flow contains two SQL Get Tables calls, each is using different connection to different database on the same server, 

Highlighted
Helper I
Helper I

Re: Two azure databases connections return the same tables

dbs.png

 

 

Highlighted
Helper I
Helper I

Re: Two azure databases connections return the same tables

it seems related to how the flow is created 

 

I added the Flow from PowerApps, then add a step to get SQL tables, all connections to different db return only the tables names from first db

 

if I just create a flow from Flow and add same actions, all connections get the correct table names,

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

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!

Top Solution Authors
Users online (8,859)