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
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.
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,
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,
Features releasing from October 2020 through March 2021
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!