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

Question

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.

Answer 1

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.

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

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

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.

Answer 2

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.

---

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.