Knowledge Center

22 Oct, 2020

Environment Variable in CDS

Posted on 22 Oct, 2020 by Admin, Posted in Dynamics 365 Dynamics-365 Sales

Environment Variable in CDS Blogs

Environment Variable in CDS


In this blog, we will see the behavior of Environment Variable in CDS environment.

There are scenarios where we need some set of configurable values in our CDS instance. Such as Product Key, Endpoint URL etc.

With the extended capability of PowerApps, now we have a provision to create an Environment Variable in our CDS instance.

Details about environment variable

In CDS instance when we click the “+New” button, then Environment Variable option is available as shown in below screenshot:

Upon Clicking on “Environment Variable” below screen will appear.

Here, we can specify the Name, Description and Data Type. Currently only four types are available for Environment Variable as shown in above screenshot.

For e.g. I have created a string type field with below details.

In CDS instance the Environment Variable Details get stored in below tables:

  1. Environment Variable Definitions (logicalname: environmentvariabledefinition)

Description: This table stores the definitions about “Environment Variable” as shown in below screenshot:

  1. Environment Variable Values (logicalname: environmentvariablevalue).

Description: This table stores the value associated to “Environment Variable”.

Just For Information,

  1. If we do not add the current value during field creation, then only one record will be created in “Environment Variable Definitions” table.
  2. Later, when we add the value in current value field of environment variable, then one record will be created under “Environment Variable Values”.

Let see this,

  1. Without Current Value: I have created below field without current value.

But no record will be created in “Environment Variable Values” table as shown below:

  1. Add value in Current Value:


When we deploy the environment variable to other instance then for the first time it will ask to set the value and by default it shows the value of source instance.

Next time if we update the value in source system, then in target system it will not update the latest value. It only shows the old. Hence we have to update the target values manually.

Note: We can use the environment variable in power automate, plugin, scripts same as tabled value using FETCHXML concept.


This is a Required Field


Recent Updates

02 Apr, 2024

Sales accelerator in D365 Sales

Introduction: In this blog we will see how Sales accelerator works and also how 'My work list' displays the work items.…

01 Apr, 2024

How to Create Entitlement in D365 Customer Service

In this blog we will learn about what is Entitlement and how to create it. 1)what is Entitlement? Entitlement is…

22 Mar, 2024

How to Create Product Catalog in Dynamics 365 for Sales - Part 1

In this blog series we will learn how to set up a product catalog in D365 Sales. The Product Catalog contains…