Announcements
No record found.
Hi,
I have a requirement for an application table that has 45 different scoring fields. The user manages scoring tables (45 tables). When the user updates the score in scoring tables.
The application data should be updated based on the score changes. I tried to use the rollup field. However, there is a limit that only 10 rollup fields can be used in one entity (https://www.mtccrm.com/crmdiscussion/KA-01084/).
What alternative can be used instead of the Rollup field? is there any other solution for this issue?
This diagram shows 2 scoring tables connected to the Application entity.
thank you,
Siva
Hello,
You always can build logic that does your rollup the custom way - good candidates are Plugins and Power Automate Flow.
Hi SivaR,
I agreed with Andrew, you can use power automate to sum child records value easily.
You need design 45 flows for 45 scoring tables with similar steps:
I will use a certain table(Development language) as an example:
1.Go Power Automate to create one automated flow:
2.Set trigger:
https://learn.microsoft.com/en-us/power-automate/dataverse/create-update-delete-trigger
When one DL record will be created or score/application fields of the DL record changed, the flow can be triggered.
2.Initialize variable:
3.List all DL records related to same application.
https://learn.microsoft.com/en-us/power-automate/dataverse/list-rows
4.Increment variable:
5.Update a row:
https://learn.microsoft.com/en-us/power-automate/dataverse/update
Overview:
Test:
(1)DL list:
(2)Application list:
=============================
Or you can refer to the following blog, which provides another functions in the power automate:
https://www.thetindog.com/dynamics-as-we-go/how-can-i-use-powerautomate-as-alternative-to-rollup
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 34
Mallesh Deshapaga 32
Goloknath 28 User Group Leader
