In a non default environment we couldn' use a Gateway to connect to on-premise resources.
It should be posible to reuse/share an existing gateway in non default envrionments to create a connection to an external database (ex. SQL Server on-premise).
We plan to do this feature. Currently, if you have an urgent business need for this feature, we can whitelist your non-default environment to allow gateway. You need to file a support ticket for this and we will evaluate carefully your request.
This is really becoming a necessity. We have separate departments, and all have their own Power Platform DEV/ACC/PROD Environment. But because of the current โOnly Default Environmentโ limitation they cannot follow through the ALM procedure as stated by the companyโฆ. Now every department has to list their environments to be whitelisted by Microsoft Supportโฆ Really frustrating!
Can we create a new environment using powerapp plan 1 ?
If yes, then please tell me if we will be able to connect on-premise SQL server with that newly created environment. (By creating the Support ticket or however)
Apologies - I am a late joiner. I struggled with this issue but have found away, I am guessing what we all want is a connection of some sort to our flow or whatever - the connection being a SQL on Prem ? - if so then I found that you can do it for a non-default environment by doing the following ( I assume you have already installed the on-prem gateway):
1) Go to the Data Integrations area
2) Create a connection to SQL Server or whichever on prem database - when you do this in a non-default environment you should be able make use of an on-prem gateway in the connection setting.
3) Continue with the wizard till the end and select the 'Do Nothing' option at the end of the wizard.
After doing the above identify the data integration project that is created by doing the above and just rename it to something else that you can identify.
Now when you go to your flow and add a SQL action of any kind you should see listed the connection you created above. This should work from a non-default environment.
We plan to do this feature. Currently, if you have an urgent business need for this feature, we can whitelist your non-default environment to allow gateway. You need to file a support ticket for this and we will evaluate carefully your request.