Unable to add SQL Server connection to imported app inside a Managed Solution
I have two PowerApps environments:
Test (where application development is done)
Production (where applications are published for consumption)
I have created an PowerApps Solution inside my Test environment which includes the following:
1 Canvas App
~10 Power Automate Flows
My App and the Power Automate Flows use the SQL Server connector to interact with an Azure SQL Database and the Office 365 Users connector. Now that I am happy with the functionality of my App, I would like to migrate it from my Test environment to my Production environment. According to the documentation (export and import) this should simply be a matter of exporting my Solution from the Test environment (as a Managed Solution), then importing it to the Production environment. Step 6 of this documentation states:
If your solution contains connection references, you’ll be prompted to select the connections you want. If a connection does not already exist, create a new one. Click Next.
I have tried creating the required Azure SQL Database connections during the import and after the import but neither seems to work because when I try to edit or run the App inside the imported solution I am presented with a permission dialog where the "Allow" option is disabled.
What I have tried:
Signing out, then back in
Clearing my browser cache
Different browsers (IE, Chrome, Firefox, Edge)
Creating the connections during the import process
Creating the connections after the import process
Created an App with a data table that is bound to a table in Azure SQL DB and importing that (same issue)
Minimum reproducible example
Migrating an App from Test to Production (same issue)
Migrating an App from Production to Test (same issue)
Ensuring that I can connect to the Azure SQL DB in both environments by making test apps that use the created connections
Ensuring that the account I am signed in with has the Owner permission for the connection
Launching the App in Edit mode
Launching the App in Run mode
Inspecting the XML inside the files shipped as part of the Managed Solution
The weird thing is that a few weeks ago I successfully imported a Solution from my Test environment to my Production environment and didn't have any issues.
Any suggestions would be appreciated because I'm out of ideas.