How to display top contributors to a Share point list on page

Copper Contributor




I am creating a site for our internal technical Knowledge base. I have a button that links to a form, which allows you to create a list entry. 


What i'd like to have is a section on the front page that shows how many entries people have created. Like display the top 3 contributors. I am trying to promote users to create entries, so having a leader board would help foster some interest. 


sp site.png

2 Replies

Hi @Michaellivingston

To concisely display the top contributors to a SharePoint list on a page, you can:

  1. Create a list to store the contributor data, with columns for Author and Count.
  2. Create a Power Automate flow to populate the contributor list when a new item is created in the original list.
  3. Create a new page in SharePoint and add a List web part, configured to display the contributor list.
  4. Filter the list to only show the top 3 contributors.
  5. Customize the appearance of the list as desired.

Here is an example of a Power Automate flow that you can use:

Trigger: When a new item is created in a list

1. Get the author of the new item
2. Get the corresponding item in the contributor list
3. Update the Count column for the author in the contributor list


Apologies for the late reply. Thank you very much for your suggestion, i will try this today!