I have created a solution that includes Power Apps and Power Automate with a connection to an on-premises SQL Server.
I exported this solution and imported it in another environment.
Then, when I regenerate PowerApps, I get a popup asking for permission to connect, but the SQL Server connection that appears there says "Your app needs this connection. Please edit the app and add it again" and the connection cannot be allowed.
In the imported environment, editing Power Apps, deleting all SQL Server connections and re-adding the same one resolves the issue, but it is very time consuming.
I would appreciate a fix so that when I import a solution that includes a connection to an on-premise SQL Server into another environment, I can allow the connection without having to edit Power Apps.