Calculated Fields in Model Driven App

| Hafsa Farooqui

CALCULATED FIELDS IN MODEL DRIVEN APP

The usage of calculated columns allows the user to concentrate on their job without having to perform calculations manually. System administrators no longer need to collaborate with developers to establish a field to hold the results of several common calculations. Instead of doing these computations in their own code, developers may make use of the platform's features.

COMMON CHARACTERISTICS:

  • They are read-only.
  • They're not specific to the user.  Since the calculation is done with the use of a system user account, it's possible that the results are based on data that the user does not have access to view, such as those with field-level security enabled.

CAPABILITIES OF CALCULATED COLUMN:

  • Calculated columns use the columns from the current table or related parent tables.
  • The built-in functions include:

ADDHOURS, ADDDAYS, ADDWEEKS, ADDMONTHS, ADDYEARS, SUBTRACTHOURS, SUBTRACTDAYS, SUBTRACTWEEKS, SUBTRACTMONTHS, SUBTRACTYEARS, DIFFINDAYS, DIFFINHOURS, DIFFINMINUTES, DIFFINMONTHS, DIFFINWEEKS, DIFFINYEARS, CONCAT,

COLUMNS ON WHICH CALCULATIONS CAN BE PERFORMED:

  • Text
  • Choice
  • Yes/No
  • Whole Number
  • Decimal Number
  • Currency
  • Date Time

CREATING A CALCULATED COLUMN

  • Open the table on which you want to add calculated column.

Calculated-Fields-P0

  • Create a new column ‘Age’ and select the behavior as ‘Calculated’ and data type ‘Whole number’

Calculated-Fields-P1

  • A new tab will be opened to ‘Set Age’
  • Write the formula to calculate the age from the given date of birth, then “Save changes”

Calculated-Fields-P2

Calculated-Fields-P3

  • Open the new form and enter the ‘Date of Birth’, Then ‘Save’.

Calculated-Fields-P4

Calculated-Fields-P5

Age will be automatically calculated.

Join us next time, as we continue our journey of learning canvas apps.Click here to learn more about Imperium's Power Apps Services. We hope this information was useful, and we look forward to sharing more insights into the Power Platform world.


M
Chief Architect, Founder, and CEO - a Microsoft recognized Power Platform solution architect.

About The Blog

Stay updated with what is happening in the Microsoft Business Applications world and initiatives Imperium is taking to ease digital transformation for customers.


More About Us

We provide guidance and strategic oversight to C-Suite and IT Directors for on-going implementations. Feel free to give us a call.

1 331 250 27 17
Send A Message

Ready to Start?

Get a personalized consultation for your project.

Book a Meeting