Share via

Environment variable support for Entra SQL authenticated connections

  • Article

Important

Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned

Enabled for Public preview Early access General availability
Users, automatically - - Jan 2025

Business value

This feature will allow Power Apps built over SQL using Entra to move smoothly from Dev to Test to Prod. Customers will not need to drop the SQL Entra data sources in their app when they move it to a new environment.

Feature details

SQL will be available in the dropdown menu for creating an environment variable. You can specify the environment variable for SQL in the same way you do for SharePoint. For SharePoint, you specify a site, while for SQL, you specify a server. Similarly, for SharePoint, you specify a list, and for SQL, you specify a table.