\u2022 Microsoft has created 2 entities\/tables named \u201cEnvironment Variable Definitions<\/strong>\u201d and \u201cEnvironment Variable Values<\/strong>\u201d. Why do we need 2 entities to maintain the environment variables? Let\u2019s understand their purpose while we take you through the creation process of the variable. We will create an environment variable named \u201cApi URL\u201d to store the respective API end points for respective CRM instances.<\/p>\n \u2022 First, make note that you must navigate to your solutions via Power Apps to create the environment variables. You cannot create or even view an Environment Variable from the classic window of your solutions. \u2022 Click on New<\/strong> button and then Environment Variable<\/strong><\/p>\n \u2022 You will be redirected to the following window<\/p>\n Here, you need to enter the values in the following<\/p>\n – Display Name:<\/strong> As the name suggests, this will be the display name of the variable. As per our example we would be creating the variable with following details:<\/p>\n – Display Name:<\/strong> Api URL Note: Like any other tables and columns, the environment variable as well takes the publisher prefix of the solution.<\/p>\n \u2022 Once you select the Data Type, you start seeing 2 new fields i.e. Default Value and Current Value. The purpose of these 2 fields will be to store the value in this variable.<\/p>\n The Default Value as the name suggests stores the value which you want the variable to return by default when there\u2019s no other value overriding the Default Value. The Current Value is the value that overrides the Default Value. In our scenario, the API URLs for the respective instances will go in Current Value.<\/p>\n Note:<\/strong> In the start of this blog we mentioned that Microsoft has created 2 entities\/tables \u201cEnvironment Variable Definitions\u201d and \u201cEnvironment Variable Values\u201d to store the environment variables, this is because the Current Value gets stored as a record in the \u201cEnvironment Variable Values\u201d table and is associated to the record created in table \u201cEnvironment Variable Definitions\u201d which consists of the remaining details like default value, name, and description of the variable.<\/p>\n \u2022 Enter the values and hit Save, your environment variable will get created.<\/p>\n You can move the same environment variables from one environment to another but instead have different Current Value in different environments.<\/p>\n To do this, you need to follow the below steps:<\/strong><\/p>\n \u2022 In the source environment, navigate to Power Apps<\/a> -> Solutions<\/strong> -> Environment Variable<\/strong>. \u2022 Now in the other environment (where you plan to move this variable), navigate to Power Apps<\/a> -> Solutions<\/strong> You can either enter the value immediately or edit the field later.<\/p>\n Note:<\/strong><\/p>\n – You will get the prompt to enter a value on solution import only if the variable has neither a Default Value nor a Current Value. If you just removed the Current Value before exporting the solution you will not get this prompt while importing the solution. However, you can edit the variable later to add the Current Value.<\/p>\n – You get this prompt irrespective of the solution being of the type Managed or Unmanaged solution.<\/p>\n – In case the environment variable is part of a managed solution, it cannot be edited later to add or update the Current Value.<\/p>\n Environment variable is a better way to hold the configuration details required by our environment and pass it on to other environments as well with different values in it.<\/p>\n Get optimum visualization of Dynamics 365 CRM data with –<\/em> Introduction It\u2019s quite often we come across scenarios where we require some configuration settings to accomplish a requirement in Dynamics 365 CRM\/Power Apps. To overcome this requirement we create a custom entity with few fields in it and then we create a record to store the required configuration details. For example, let\u2019s say we want\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[16,19,44],"tags":[2590,2171,545,592,2148,1337,1975,2589],"class_list":["post-26695","post","type-post","status-publish","format-standard","hentry","category-dynamics-365","category-dynamics-crm","category-power-apps","tag-canvas-apps-more","tag-dataverse","tag-dynamics-365-crm","tag-dynamics-crm","tag-environment-variables","tag-power-apps","tag-power-automate","tag-top-blogs-of-2021-power-apps"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/26695","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=26695"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/26695\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=26695"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=26695"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=26695"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n\u2022 The purpose of these entities\/tables is to store the environment variables created for your organization as records which means you can create more than one environment variable for your organization.
\n\u2022 The 2 entities (i.e. \u201cEnvironment Variable Definitions\u201d and \u201cEnvironment Variable Values\u201d) are related to each other. The \u201cEnvironment Variable Definitions\u201d has a 1:N or rather a 1:1 relation with the \u201cEnvironment Variable Values\u201d. The reason we are saying this is because you cannot have more than one value for one definition.<\/p>\n
\n\u2022 Once you are logged in to your Power Apps<\/a>, on the left pane, click on Solutions<\/strong>.<\/p>\n![\"Environment](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/1-environment-variables.jpeg\")
<\/a><\/p>\n![\"Environment](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/2-environment-variables.jpeg\")
<\/a><\/p>\n![\"\"](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/3-environment-variables.jpeg\")
<\/a><\/p>\n
\n– Name:<\/strong> This is the schema name for the variable. You can actually query on the entity \u201cenvironmentvariabledefinitions\u201d and find the value entered in name under property \u201cschemaname\u201c
\n– Description:<\/strong> This will store any details you want to mention to describe the purpose of this environment variable.
\n– Data Type:<\/strong> There are 4 datatype options at the moment which are \u201cDecimal number\u201d, \u201cJSON\u201d, \u201cText\u201d, \u201cYes\/No\u201d.<\/p>\n![\"Environment](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/4-environment-variables.jpeg\")
<\/a><\/p>\n
\n– Name:<\/strong> new_apiurl
\n– Description:<\/strong> This variable will hold the URL of the API
\n– Data Type:<\/strong> Text<\/p>\n![\"Environment](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/5-environment-variables.jpeg\")
<\/a><\/p>\n![\"Environment](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/6-environment-variables.jpeg\")
<\/a><\/p>\n
\n\u2022 Edit the variable to remove the existing Default and Current value and save. Export the solution with this variable.<\/p>\n![\"Environment](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/7-environment-variables.jpeg\")
<\/a><\/p>\n![\"Environment](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/8-environment-variables.jpeg\")
<\/a><\/p>\n
\n\u2022 Import the solution with the environment variable.
\n\u2022 While you import the solution you shall get a prompt as shown below, asking for the value for your variable.<\/p>\n![\"Environment](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/9-environment-variables.jpeg\")
<\/a><\/p>\n![\"Environment](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2021\/02\/10-environment-variables.jpeg\")
<\/a><\/p>\nConclusion<\/h2>\n
\nKanban Board<\/a> <\/strong>\u2013 Visualize Dynamics 365 CRM data in Kanban view by categorizing entity records in lanes and rows as per their status, priority, etc.<\/em>
\nMap My Relationships<\/a><\/strong> \u2013 Map My Relationships \u2013 Visualize connections and relationships between Dynamics 365 CRM entities or related records in a Mind Map view.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"