{"id":127164,"date":"2025-01-21T16:09:39","date_gmt":"2025-01-22T00:09:39","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?post_type=power-apps&#038;p=127164"},"modified":"2025-01-21T16:09:41","modified_gmt":"2025-01-22T00:09:41","slug":"sql-server-environment-variables-available-for-power-apps","status":"publish","type":"power-apps","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/sql-server-environment-variables-available-for-power-apps\/","title":{"rendered":"SQL Server environment variables available for Power Apps"},"content":{"rendered":"\n<p>We are excited to announce that SQL Server environment variables (Entra) for Power Apps support is currently rolling out and will be in Preview regions by Jan 22 and in all regions &#8211; including sovereign &#8211; by Feb 3.<\/p>\n\n\n\n<p>SQL Server environment variables (Entra) for Power Apps will save you time moving your solutions from one environment to another. For example, from an environment used for dev or test to a different environment used for test or production. <a href=\"https:\/\/learn.microsoft.com\/en-us\/power-apps\/maker\/data-platform\/environmentvariables#create-an-environment-variable-in-a-solution\">Manually create environment variables<\/a> in your solution or <a href=\"https:\/\/learn.microsoft.com\/en-us\/power-apps\/maker\/data-platform\/environmentvariables-data-source-canvas-apps#automatically-create-data-source-environment-variables-when-connecting-to-data\">set a switch in your app to auto-create them<\/a> for you when you add a data source to your app while in your solution. Note that this feature is specifically for Entra. Power Apps with shared connections (e.g., SQL Auth) continue with <a href=\"https:\/\/learn.microsoft.com\/en-us\/power-apps\/maker\/data-platform\/create-connection-reference\">connection references<\/a>.<\/p>\n\n\n\n<p>There are two environment variables to set for SQL connections: server and database.  The database environment variable depends on the server environment variable. First you create an environment variable for your server. Once that is created you can create an environment variable for the database that attaches to the server environment variable. <\/p>\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2025\/01\/envvar_sql_server-1.webp\" alt=\"A screenshot of a computer\" class=\"wp-image-127295 webp-format\" style=\"width:724px;height:auto\" srcset=\"\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2025\/01\/envvar_sql_server-1.webp\"><\/figure>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2025\/01\/envvar_sql_database-1.webp\" alt=\"A screenshot of a computer\" class=\"wp-image-127296 webp-format\" srcset=\"\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2025\/01\/envvar_sql_database-1.webp\"><\/figure>\n\n\n\n<p><a href=\"https:\/\/learn.microsoft.com\/en-us\/power-apps\/maker\/data-platform\/environmentvariables-data-source-canvas-apps\">Use an environment variable<\/a> by selecting to create data source and instead of creating a new server database combo, use the &#8216;Advanced&#8217; tab to select the environment variable to bind to the controls in your app.<\/p>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2025\/01\/envvar_sql_use.webp\" alt=\"A screenshot of a computer\" class=\"wp-image-127178 webp-format\" srcset=\"\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2025\/01\/envvar_sql_use.webp\"><\/figure>\n\n\n\n<p>Use SQL Server environment variables (Entra) to easily enable professional deployment patterns. See the documentation for this feature for an in-depth discussion: <a href=\"https:\/\/learn.microsoft.com\/en-us\/power-apps\/maker\/data-platform\/environmentvariables\">Use environment variables in Power Platform solutions &#8211; Power Apps | Microsoft Learn<\/a><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are excited to announce that SQL Server environment variables (Entra) for Power Apps support is currently rolling out and will be in Preview regions by Jan 22 and in all regions &#8211; including sovereign &#8211; by Feb 3. SQL Server environment variables (Entra) for Power Apps will save you time moving your solutions from<\/p>\n","protected":false},"author":105,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","power-apps-category":[1540,1549,1570],"power-apps-tag":[1525,1655,1657,1682,1700,1701,1708],"coauthors":[2340],"class_list":["post-127164","power-apps","type-power-apps","status-publish","hentry","power-apps-category-alm","power-apps-category-building-power-apps","power-apps-category-connector-guidelines","power-apps-tag-aad","power-apps-tag-new-feature","power-apps-tag-new-features","power-apps-tag-pro-dev","power-apps-tag-solutions","power-apps-tag-sql-server","power-apps-tag-variables"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server environment variables available for Power Apps - Microsoft Power Platform Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/sql-server-environment-variables-available-for-power-apps\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server environment variables available for Power Apps - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"We are excited to announce that SQL Server environment variables (Entra) for Power Apps support is currently rolling out and will be in Preview regions by Jan 22 and in all regions &#8211; including sovereign &#8211; by Feb 3. SQL Server environment variables (Entra) for Power Apps will save you time moving your solutions from\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/sql-server-environment-variables-available-for-power-apps\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:modified_time\" content=\"2025-01-22T00:09:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2025\/01\/envvar_sql_server-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"602\" \/>\n\t<meta property=\"og:image:height\" content=\"578\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 min read\" \/>\n\t<meta name=\"twitter:label2\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data2\" content=\"Lance Delano\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/sql-server-environment-variables-available-for-power-apps\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/sql-server-environment-variables-available-for-power-apps\/\",\"name\":\"SQL Server environment variables available for Power Apps - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/sql-server-environment-variables-available-for-power-apps\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/sql-server-environment-variables-available-for-power-apps\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2025\/01\/envvar_sql_server-1.webp\",\"datePublished\":\"2025-01-22T00:09:39+00:00\",\"dateModified\":\"2025-01-22T00:09:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/sql-server-environment-variables-available-for-power-apps\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/sql-server-environment-variables-available-for-power-apps\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/sql-server-environment-variables-available-for-power-apps\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2025\/01\/envvar_sql_server-1.webp\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2025\/01\/envvar_sql_server-1.webp\",\"width\":602,\"height\":578,\"caption\":\"A screenshot of a computer\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/sql-server-environment-variables-available-for-power-apps\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power Apps\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SQL Server environment variables available for Power Apps\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server environment variables available for Power Apps - Microsoft Power Platform Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/sql-server-environment-variables-available-for-power-apps\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server environment variables available for Power Apps - Microsoft Power Platform Blog","og_description":"We are excited to announce that SQL Server environment variables (Entra) for Power Apps support is currently rolling out and will be in Preview regions by Jan 22 and in all regions &#8211; including sovereign &#8211; by Feb 3. SQL Server environment variables (Entra) for Power Apps will save you time moving your solutions from","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/sql-server-environment-variables-available-for-power-apps\/","og_site_name":"Microsoft Power Platform Blog","article_modified_time":"2025-01-22T00:09:41+00:00","og_image":[{"width":602,"height":578,"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2025\/01\/envvar_sql_server-1.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 min read","Written by":"Lance Delano"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/sql-server-environment-variables-available-for-power-apps\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/sql-server-environment-variables-available-for-power-apps\/","name":"SQL Server environment variables available for Power Apps - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/sql-server-environment-variables-available-for-power-apps\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/sql-server-environment-variables-available-for-power-apps\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2025\/01\/envvar_sql_server-1.webp","datePublished":"2025-01-22T00:09:39+00:00","dateModified":"2025-01-22T00:09:41+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/sql-server-environment-variables-available-for-power-apps\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/sql-server-environment-variables-available-for-power-apps\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/sql-server-environment-variables-available-for-power-apps\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2025\/01\/envvar_sql_server-1.webp","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2025\/01\/envvar_sql_server-1.webp","width":602,"height":578,"caption":"A screenshot of a computer"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/sql-server-environment-variables-available-for-power-apps\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Power Apps","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/"},{"@type":"ListItem","position":3,"name":"SQL Server environment variables available for Power Apps"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps\/127164"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/power-apps"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/105"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=127164"}],"version-history":[{"count":16,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps\/127164\/revisions"}],"predecessor-version":[{"id":127312,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps\/127164\/revisions\/127312"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=127164"}],"wp:term":[{"taxonomy":"power-apps-category","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps-category?post=127164"},{"taxonomy":"power-apps-tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps-tag?post=127164"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=127164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}