Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Easiest way to do Total counts of records

Posted on by 184

I want to find out the below total counts in my Dynamics CRM CE. 

I don't know how to use js reports and i know there is more thank 200K record so i cannot export to excel to do counts. 

1. Total number of contacts with active status 

2. Total number of contacts with email address

3. Total number of these contacts with a certain status

What is best way to do this? 

  • Suggested answer
    Charan Raju C R Profile Picture
    Charan Raju C R 3,155 Super User 2024 Season 1 on at
    RE: Easiest way to do Total counts of records

    Please check this post.

    nishantrana.me/.../

  • AriaConsulting Profile Picture
    AriaConsulting 2,655 on at
    RE: Easiest way to do Total counts of records

    Have you tried exporting the data directly from the tables in PowerApps maker portal?

  • r4vvm Profile Picture
    r4vvm 184 on at
    RE: Easiest way to do Total counts of records

    This does not give you the total count and also if i export the AF to excel it only exports the fist 100K rows

  • Suggested answer
    Nya Profile Picture
    Nya 29,056 on at
    RE: Easiest way to do Total counts of records

    Hi,

    Please refer to the following documentation:

    Create, edit, or save an Advanced Find search (Dynamics 365 Customer Engagement (on-premises)) | Microsoft Docs

     

    If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.

    Best Regards,

    Nya

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans