Group by in dynamics 365

(0) Share

Report

Posted on by Sumaira Noor

1,085

Hello Experts

I have created a group by view to list the records so that it should be easy to find duplicates based on email field on my lead entity

The problem is, if i select the group by it will not show record count and if i select the record as read only grid to view my record count, it will not show group by

Kindly guide

Best Regards,

Sumaira Noor

I have the same question (0)

All responses (3)

Answers (1)

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello,

It looks like a statement. What's your question?

Was this reply helpful? Yes No
Sumaira Noor 1,085 on at

Like (0)

Report

Thanks for the response Andrew

I have added an editable grid control to group by for my leads

It works well, but it doesn't display the total record count

Record count is missing in the footer

Whereas, if i select as read only grid,

I can see the record count, but not the group by control like below

Group by isn't displayed below

But record count is displayed below

The customer wants both the record count and group by to be displayed at once

We are using this to group the data, so that we can find duplicate emails

Kindly guide,

Best Regards,

Sumaira Noor

Was this reply helpful? Yes No
Verified answer

LuHao 40,892 on at

Like (0)

Report

Hi Sumaira,

Unfortunately, there is no OOTB way to achieve it.

To find the duplicate emails, we could run bulk system jobs to detect duplicate records.

Please refer to https://docs.microsoft.com/en-us/power-platform/admin/run-bulk-system-jobs-detect-duplicate-records

https://www.marksgroup.net/blog/dynamics-365-duplicate-detection-jobs-merging-records/

Was this reply helpful? Yes No