The problem:

Currently, you select the Business Central environment and company when adding the connector in a Canvas App. As a result, you get a fixed connection within your Canvas App that cannot be changed.

In detail: While developing a Canvas App, do not use any production data in Business Central. For this reason, you usually select DEV (sandbox) and the company "Cronus USA, Inc.".

However, during the rollout, you will need to remove and re-add all data sources to Business Central from your application to select the test and later the production data in Business Central.

It gets even more complicated if your Canvas App or Power Automate Flow is included in a managed (sealed) solution. Then you need to create an unmanaged layer in order to change the connections (data sources).

The idea / solution:

1. Support environment variables (type: Datasource) in Business Central connectors
2. Allow using & selecting these environment variables for datasources in Canvas Apps & Power Automate Flows.

A good approach for this is the SharePoint Connector. The connector allows to select environment variables as parameters for SharePoint Site & List. As result, changing the SharePoint Site & List is possible by configuration without changing the Canvas App or Power Automate Flow.

See also: https://powerapps.microsoft.com/en-us/blog/announcing-data-source-environment-variables/