Forum Discussion

Michaellivingston's avatar
Michaellivingston
Copper Contributor
Sep 26, 2023

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

 

Hi,

 

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. 

 

  • Lalit Mohan's avatar
    Lalit Mohan
    Iron Contributor

    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
    
    Actions:
    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

     

    • Michaellivingston's avatar
      Michaellivingston
      Copper Contributor
      Apologies for the late reply. Thank you very much for your suggestion, i will try this today!

Resources