Calculated fields in Power Apps.

Hello Guys,

In my previous blog we have seen how you can use OOB feature to create auto numbering or auto generated field value. Today we are going to explore one more OOB feature of the Dynamics CRM i.e. Calculated Fields. But before if you are new to our blog then do follow us to know more about Dynamics and Power Platform. Also if you like our blog then please comment and share this blog with your friends.

Calculated fields are used to perform calculation using data available in other fields. Microsoft Power Platform provides large set of inbuilt functions to work with calculated fields.

Consider a scenario where we have Employee entity with Left Date attribute. Now we want whenever employee leaves the organization, this field should contain date value in it. Which means initially this field will be blank but when we will deactivate the employee, this field should contain data.

To achieve this many of us go with JavaScript implementation which is not a good practice as we should use OOB features.

Power Platform gives us a field type option that we can use to calculate field's value. This field type option is known as Calculated fields. Calculated fields uses following datatype: Text, Option Set, Two Option, Whole Number, Decimal Number, Currency and Date Time.

There is a limit to the amount of calculated field per entity. It is important to check your software version to determine how many calculated fields you can create before implementing them.

One important point that we need to keep in mind that Calculated field can not trigger Workflows. Attempting to call workflows on the change of a calculated field will not work. Below are the steps for creating Calculated field.

Step 1:- Login to https://make.powerapps.com



Step 2:- Open Employee Entity. Here we have created Employee Entity with below fields. We will be creating a new field i.e. Left Date.



Step 3:- To create a new field click on New Field at the top. Fill the information as below and click on Add and select Calculation. It will open a new window.



Step 4:-We will specify the condition that if Employee's status reason is inactive, we will set current date for the leaving the organization.



Step 5:- Save and Close. Now open the Employee record and deactivate it and check its working as expected.


Please follow and share if you like it.
Hope it helps...

Comments

Post a Comment

Popular posts from this blog

Creating Custom API in D365.

Image
Hello Guys, In our previous blog  we have seen how to retrieve and use GUID of logged in user in canvas application. Today we are going to create custom API which is nothing but the custom action in old version of the CRM. But before d o follow us to know more about Dynamics and Power Platform. Also if you like our blog then please comment and share this blog with your friends. Custom API is a new way of creating Custom Action messages in D365. We were used to create a custom action for custom messages in previous version of the CRM for many years. Below image shows the example of custom action. But now Microsoft has introduced an extension for Custom Action called Custom API  which has more controls like creating Private Custom API which means API can be used by owner of the API or by users with whom API is shared. We can create Custom API as web method which means we can use GET and POST method to use this API. Custom API does not require us to create custom messages which w...
Read more

Read Only Sub Grid & Editable Sub grid in Dynamics 365

Image
Hello Guys, In my previous blogs we have seen Duplicate Detection in Dynamics 365 where we covered how you can use OOB feature of D365 to detect duplicate records. Today we will see how we can implement editable sub grid.  But before if you are new to our blog then do follow us to know more about Dynamics and Power Platform. Also if you like our blog then please comment and share this blog with your friends. In Dynamics CRM we have seen many entities sharing parent child relationships and we can create records of child from the parent page. For example Account and Contact Entity. We can create a new contact entity from the Account Form with the help of Sub Grid control. We can also create sub grid for custom entity and can utilize it in our own way. We will be using Department and Employee Entity for demonstration. Below are the steps: Step 1:- Login to Dynamics 365 with credentials. Step 2:- Click on Advance Settings Gear icon. Navigate to Settings -> Solution -...
Read more

Using Polymorphic Lookups in D365.

Image
Hello Guys, In our previous  blog   we have seen how to use two timelines in one form. Today we will understand what is polymorphic lookups and how to use them. Do follow us to know more about Dynamics and Power Platform.  Also if you like our blog then please comment and share this blog with your friends. In Dynamics CRM 365, while creating lookup field we need to specify one table in the relationship to relate to. Where as for customer field or for regarding field type, you don't have the control to select tables. Consider below example where we are creating a task. As you can see we have created the task and now we want to specify regarding so that we can identify for which table this task was created. When we choose regarding, we see below options for selecting the lookups. As you see, we can choose regarding from multiple tables. So here regarding column is known as polymorphic lookup. When it comes to the option of selecting from multiple tables in one single lookup...
Read more