Answered

Rollup Columns and Calculated Columns

(1) Share

Report

Posted on by ctedesco3307

690

Hey All - can someone confirm for me how often Rollup Columns and Calculated columns re-calculate? I used both these columns types on one of my tables but they don't appear to be re-calculating rea time (I'm a model-driven app newbie)

I'm reading the doc below

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/calculated-rollup-attributes

I need these values to re-calculate every time the user adds a row or modifies a value that is in the calculated column formula and I'm not seeing any changes when I do those actions.

Are the updates not real time?

Should I have created a business rule?

Lastly - where can I find these supporting columns for the Rollup columns? Not clear in the doc..

Sorry for being so green ...

Thank you!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Fubar 8,354 Super User 2025 Season 2 on at

Like (2)

Report
Calculated: the column calculates each time they are retrieved/viewed
Rollup: is rolledup every x hours - by default this is 12 hours but can be configured down to 1 hr (https://learn.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/define-rollup-fields?view=op-9-1#rollup-calculations). The rollup can also be triggered via code e.g. writing a plugin.
The other gotcha with these fields types is that when they update they do not fire an update event i.e. you cannot use them as a trigger to perform some other action.

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (1)

Report

Hi @Fubar

Please find my channel for your reference.

https://www.youtube.com/watch?v=P-6OTlmRWw4

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Follow me on Twitter : @rampprakashd
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
Suggested answer

dmb 12 on at

Like (1)

Report
Calculated columns are calculated upon retrieval. Same as the new Formula columns that use PowerFx.
After a rollup column is created, it's calculated after 12 hours. Then I believe the default period is 1 hour, can be increased, but not decreased. For on demand force recalculation of specific field on a specific record, call the CalculateRollupField function. It's the same as the user clicks on the calculator icon within a model-driven app which is basically a GET request like this:

https://xxxxxxxxxxxxxxxx.crm.dynamics.com /api/data/v9.2/CalculateRollupField(Target=@p1,FieldName=@p2) ?@p1={'@odata.id': 'tableSetName(recordGuid)'}&@p2='rollupFieldLogicalName'

From JavaScript within model-driven app it's better to call this function by the Xrm.WebApi.online.execute method, although a simple fetch will also work as the user is already logged-in.

You can also call it from a portal with the token from shell.getTokenDeferred().

From C# plugin use the localPluginContext.SystemUserService.Execute method.

You can also call it from cloud flows using the HTTP action or from some external app but this will require authorization.

Beside doing the recalculation, it also returns the new value.

Was this reply helpful? Yes No