How to Automate RollUp Field Calculation

[Djbazuka]

Hello Everyone,

I am trying to automate the calculation of Rollup Fields.

But there is a catch!

I know about the system job that works on an entity level to update all the rollup fields in timely manner.

What I want to achieve?:- I have 2 roll up fields on account entity and want them to auto update but I want 1 field to update hourly and 1 to update only once a day.

Problem:- Since once job would run on all fields on the entity, I cant seem to find a solution where I can achieve the above.

I would appreciate any help possible.

Thank you.

[ArchitectMadhan]

Hi @Djbazuka ,

You can select the rollup field job for which you wanted to set hourly refresh and other roll up field job can be set for Daily. Use the "Advanced Options" from the PowerApps environment -> Settings.

[Djbazuka]

@ArchitectMadhan 

So, I have created 2 fields on Account Entity called :-

• Count of Contract (Rollup)
• Count of Outstanding Invoices (Rollup)

When you create the initial field 2 system jobs are generated 

• one for account entity (on which recurrence/time can be adjusted, this job will calculate all the rollup fields on account entity)
• Second one is generated specifically for field (on this you cant adjust the time)

When you create 2nd one only one system job is generated

• Again for that specific field (on which time cant be adjusted)

In total I get only 3 jobs from which I can adjust time on only one, on top of that for the one I can adjust the time it updates all the rollup field on account entity.

Field specific system job :-

As you can see no option to adjust the reccurence.

Account specific system job:-

As you can see I have option to adjust the recurrence but on account entity which will calculate all the rollup fields on at the same time. 

My goal is to adjust time for both the fields separately

Here is the list of Rollup field system jobs I have :-

[Djbazuka]

@ArchitectMadhan Any idea how would we do this? Is this even possible?.

[dpoggemann]

Hi @Djbazuka ,

I don't think it is possible to change the schedule at the field level for the rollup on a single entity.  Both will rollup on the schedule you define.  

One option you might look at here would be to not utilize rollups at all for this and leverage something like a Power Automate flow?  Just a thought...

You could setup two flows that would run hourly and daily and would loop through the parent entity instances and read all the child records (appropriate fields) and sum / count etc. and update the parent entity.  

I know this is basically replacing the rollup fields but would allow you to accomplish your goal.