Unanswered

instant rollup recalculation

(0) Share

Report

Posted on by julijazas

820

I want to instantly(when records added,modified,deleted) be able to recalculate a rollup field. I have found this article:

Solved: Modify Rollup field frequency to run every 30 mins - Power Platform Community (microsoft.com)

is says:

1. Create a workflow/power automate flow that will be triggered on create/update/delete of child record.

2. Call CalculateRollupField message to recalculate the rollup field. If you choose workflows you can use custom workflow activity from my Ultimate Workflow Toolkit pack - https://github.com/AndrewButenko/UltimateWorkflowToolkit

My question is how should i call CalculateRollupField message within the power automate?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

EricRegnier 8,720 Most Valuable Professional on at

Like (1)

Report

Hi @jja,

This only way that I know is to call it via Power Automate if through the HTTP action to call the Dataverse' Web API. There are a few steps to get this going to setup the service principal to allow connection, authenticate then call the CalculateRollupField function.

Here's a good article explaining the steps: https://dynamicconsultantsgroup.com/blogs/dynamics-365-webapi-calls-and-flow/
Hope this helps!

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

Hi @jja ,

Not specifically answer to your question but wanted to let you know that according to Microsoft the Power FX formula fields are coming soon to Dataverse, they are already available in Dataverse for Teams and can do these types of analytical functions in real time. https://powerapps.microsoft.com/it-it/blog/power-fx-coming-to-model-driven-power-apps-dataverse-and-more/

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

Like (0)

Report

Hello @jja

You can use Plugins to recalculate immediately

Link for your Reference : https://pradipwebmaster.wordpress.com/2019/06/12/recalculate-rollup-field-using-plugin-in-dynamics-365/

Make sure the Message you register in preoperation.

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