Rollup field limit - alternative to rollup

(0) Share

Report

Posted on by SivaR

459

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

Categories:

Administration and Setup

Development / Customization / SDK

All responses (2)

Answers (0)

Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

RE: Rollup field limit - alternative to rollup

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
Suggested answer

a33ik 84,319 Moderator on at

Like (1)

Report

RE: Rollup field limit - alternative to rollup

Hello,

You always can build logic that does your rollup the custom way - good candidates are Plugins and Power Automate Flow.