Service | Customer Service, Contact Center, Fie...

Rollup field limit - alternative to rollup

Like (0) Share

Report

Posted on 9 Nov 2022 17:54:45 by SivaR

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

All responses (2)

Answers (0)

Suggested answer

Leah Ju Microsoft Employee on 10 Nov 2022 at 08:17:08

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,331 Most Valuable Professional on 09 Nov 2022 at 19:07:49

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.