Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

How to Automate RollUp Field Calculation

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.

Super User
Super User

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.



- Architect Madhan

Please click the "Accept as Solution" button and give thumbs up, if it is helpful to you.
Frequent Visitor



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 :-




Frequent Visitor

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

Super User
Super User

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.  

Hope this helps. Please accept if answers your question or Like if helps in any way.

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,422)