Share via

Displaying the count of open, closed, and pending items on a SharePoint list

Sathiya Saravanan 0 Reputation points Microsoft Vendor
2024-05-16T04:46:12.37+00:00

Hello,

I need to display the count of items from the SharePoint list column "status" on a SharePoint page. I want to display the count of how many items are in open, pending, and closed status in the list. Can you please suggest a method for achieving this through some power automate or scripting?

Note: I have checked this can be possible by Power Bi, but the users don't have the license for Power BI.

Microsoft Power Platform Training
Microsoft Power Platform Training
Microsoft Power Platform: An integrated set of Microsoft business intelligence services.Training: Instruction to develop new skills.
133 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ling Zhou_MSFT 14,295 Reputation points Microsoft Vendor
    2024-05-16T07:36:37.5233333+00:00

    Hi @Sathiya Saravanan,

    Thank you for posting in this community.Based on the description of your question, I don't think it's necessary for us to use code to show the total number of items in each status. Grouping by status is sufficient.

    You can configure it according to part "Grouping documents or items in a view" in this article (Use grouping to modify a list or library view).

    You can see that the number in parentheses after each grouping is the total number of items in that status.

    User's image

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. SiddeshTN 2,945 Reputation points Microsoft Vendor
    2024-05-20T12:52:22.3533333+00:00

    Hi Sathiya Saravanan,

    Thank You for Your Response.

    We tried from our end; it's working fine for us. Kindly refer the below screenshot.

    Step 1: Create a collection "Col" to collect the list "List Demo" from SharePoint.
    User's image

    Step 2: Add a button and create a collection "collist" again, to get the status and count from the collection "Col".
    User's image

    Step 3: Add the data table , add the Status and count column from collection "collist".

    User's image

    If you are still facing any issue, please let us know in the comments. We are glad to help you.

    If the provided solution has helped in resolving the issue, please consider accepting it by clicking on the "Accept answer" button to enhance visibility of this question for other members of the Microsoft Q&A community.