| 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.
- 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:
- Whole Number
- Decimal Number
- Date Time
CREATING A CALCULATED COLUMN
- Open the table on which you want to add calculated column.
- Create a new column ‘Age’ and select the behavior as ‘Calculated’ and data type ‘Whole number’
- 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”
- Open the new form and enter the ‘Date of Birth’, Then ‘Save’.
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.