Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

How to count no. of records shown on page

Posted on by 45

Hi All,

I want to count no. of rows showing on list page according to the filters set by user

pastedimage1641965839404v1.png

For example: By applying these filters I am getting 10 rows only however there are 180 rows without filters, so I want to return 10 only

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,647 Super User 2024 Season 2 on at
    RE: How to count no. of records shown on page

    Hi, Since there is no trigger for After filter in the system, I think you need to create a new Action on the page.
    for example:

    pastedimage1642037429866v1.png

    pastedimage1642037440460v2.png

    All:

    pastedimage1642037446421v3.png

    Add filters

    pastedimage1642037462093v4.png

    Hope this will help.

    Thanks.

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: How to count no. of records shown on page

    What is the Business need for doing the counting? I think that is important to know in order to suggest a solution to you.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,428 on at
    RE: How to count no. of records shown on page

    Hi

    As other mentioned this require development. Without development you can

    1) Export into Excel and count.

    2) Use free app such as Quicksums. it require one extra step but will provide the count appsource.microsoft.com/.../PUBID.webcom|AID.bc001|PAPPID.0b613ad6-def9-43ec-994c-1db094d086d8

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: How to count no. of records shown on page

    Hello,

    You need to ask your partner to do this on your behalf via an extension.

    Thanks.

  • Aditya raut Profile Picture
    Aditya raut 45 on at
    RE: How to count no. of records shown on page

    I'm sorry I cannot comprehend how to apply this on my solution.

    If you could help then it would be very helpful

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    RE: How to count no. of records shown on page

    Using the mark and markedonly functions should aid this feature development: docs.microsoft.com/.../record-mark-method

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

Featured topics

Product updates

Dynamics 365 release plans