Force Rollup Column Calculation in Power Automate


Rollup columns in Power Automate allow you to aggregate data across a hierarchy of data, but they have limitations. One limitation is that the shortest delay between each rollup calculation is one hour. However, there are scenarios where you may want to force a recalculation after a change has been made. In Power Automate, you can use a GET request URL to recalculate a specific rollup column for a specific row. The URL format is: https://*environment_url*/api/data/v9.1/CalculateRollupField(Target=@tid,FieldName=@field)?@tid={'@odata.id':*entity_set_name*(*row_uniqueidentifier *)'}&@field='*logical_column_name*'. You can use different OData values depending on your scenario, such as the environment URL, entity set name, and unique identifier.


Article 12m

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time