Power Platform Community Forum Thread Details

Hi All,

I have recently switched a number of my existing SQL views and tables in a Power App to a different SQL connection. I did this from within the App by removing the existing views and then simply re-adding the same views on the different connection. The data all lined up correctly in my Dev Application and then I went to deploy to our Test Environment.

Upon deploying to test I was asked to set up 50 new environment variables that had automatically been created in the background, I was actually unaware this was going on due to it being a new feature in Power Apps and this is set to ON until you go into settings and switch it off.

I did a little research around this and found very little apart from the article in the link below:

SQL Server environment variables available for Power Apps - Microsoft Power Platform Blog.

Having read the article I took note of the following paragraph stating these new SQL Data Source Environment Variables are specifically for Entra.

Note that this feature is specifically for Entra. Power Apps with shared connections (e.g., SQL Auth) continue with connection references.

Since my application uses connection references, I went ahead and deleted the newly created Environment variables from the solution and then the Default Environment as I did not want any missing dependencies.

Upon clearing the solution and the default environment of these 50 or so Environment variables, I went to deploy the solution again and was faced with the following message when deploying the managed solution to the Test Environment.

Solution "NAME" failed to import: ImportAsHolding failed with exception :The dependent component EnvironmentVariableDefinition (Id=new_shared_sql_43df54881acf457b8d3628690a35fc9b) does not exist. Failure trying to associate it with CanvasApp (Id=CANVAS APP ID GUID) as a dependency. Missing dependency lookup type = EntityNameLookup.

Note: The Environment ID highlighted in the error message is one of the Automatically Created Environment Variables that I thought I had removed.

To test this I created an Environment variable with the same name and re did the deployment.

A similar error occurred but with a different GUID, upon opening the solution Zip File from Initial deployment I can see all of these variables in the environment variables folder.

Interestingly: I also get the same error when I try to publish my App in the Dev Environment in the maker portal.

Its as if my Application is still looking for these variables even though I have deleted them.

At the moment I cannot publish the App in Dev or Deploy to upstream environments. :(

Can anyone help or make suggestions on how I can remove this Hidden Dependency??

Many Thanks
Jamie

Categories:

Building Power Apps