Auto-create data source environment variables in canvas apps

A canvas app can use environment variables for supported data source parameters. Power Apps can create these variables when you add a supported data source to an app in a solution. The setting doesn’t update existing apps automatically.

Enable automatic creation

In Power Apps Studio, open an app from a solution, select Settings > General, and enable Automatically create environment variables when adding data sources. Then add a supported data source and connect to it.

The documented example uses SharePoint Online. Data source environment variables are also supported for other connectors and parameter types, including SQL Server with supported connection types. Check the current connector and parameter support before relying on the setting for a particular data source.

When a matching variable already exists, Power Apps can prompt you to reuse it. The variable can then carry an environment-specific value with the solution.

If the variable belongs to another solution, the app’s solution depends on that solution. Include the variable in the solution you export, or import the solution that contains it into the target environment first.

Existing apps need a separate update

Turning on the setting doesn’t convert existing data sources. Microsoft documents removing the source from the app and adding it again through the environment-variable flow to update an existing app.

After importing a solution into another environment, check the variable values and connection. The variable provides a place for environment-specific data source parameters; it doesn’t grant users access to the underlying data.

For SharePoint, a site variable needs a current or default value containing the site URL. A list variable must contain the list’s identifier, not its display name. The selected connection must also have access to the list.

A picker limitation

The Power Apps Studio picker retrieves only the first page of matching variable definitions and values. Each Dataverse request returns up to 5,000 matching records, so a variable might not appear in the picker even when it exists. This is a picker limitation, not a 5,000-variable limit for the environment.

Source

• Use data source environment variables in canvas apps, Microsoft Learn