Display house points from Arbor in SharePoint automatically 

Does your school use Arbor MIS to monitor behaviour or award house points? 

Imagine how amazing it would be to have those house points instantly visible on your SharePoint intranet, live and up to date.  

Well, it’s entirely possible.  

In this guide, we walk you through connecting Arbor with SharePoint so that students can track house points in real time.  

Why display house points in SharePoint? 

Displaying house points in SharePoint is a great way to foster engagement and motivation across the entire school community.  

By making house points visible, students can track their house’s progress, which boosts enthusiasm and encourages healthy competition.  

You may already display house points in SharePoint manually, but by following the steps below, you can save a lot of time updating them daily.  

How to automatically share house points from Arbor in SharePoint 

By using this simple integration, you can display live house points directly in SharePoint from Abor.  

1. Create a live feed in Abor  

1. In Arbor, navigate to Students → Behaviour → Points Awards → Total.  

2. Apply your preferred filters, including date range, Point Awards Scale, behaviour points, min and max, and calendar week.  

3. Group the results by House.  

4. Select Download → Live Feed.  

5. Give the feed a title and choose JSON as the output format. Make sure Require Authentication is enabled for security.  

6. Save the feed and copy the generated URL.  

Prepare a SharePoint list  

1. In SharePoint, create a new blank list. 

2. Add a Number column titled House Points. This list will be populated and updated automatically.  

3. Build a Power Automate flow 

Using Microsoft Power Automate (with a premium licence), create a flow that:  

• Runs on a schedule (e.g. every hour).  

• Retrieves the JSON feed from Arbor.  

• Converts the data using a schema.  

• Checks your SharePoint list for existing houses.  

• Adds any missing houses.  

• Updates each house with the latest points.  

This ensures your SharePoint list always reflects real-time data from Arbor.  

4. Display the Data in SharePoint  

Once the flow has run successfully, return to your SharePoint page and edit it.  

1. Add a Quick Chart web part and connect it to your populated list.  

2. Choose your preferred chart style (bar or pie) and publish the page.  

Your SharePoint site will now update the house points chart with data directly from Arbor.  

Getting the JSON  

For the Convert to JSON section of the Power Automate use:  

{
  "type": "array",
  "items": {
    "type": "object",
    "properties": {
      "House": {
        "type": "string"
      },
      "Group Size": {
        "type": "integer"
      },
      "Week": {
        "type": "string"
      },
      "YTD": {
        "type": "string"
      },
      "Term": {}
    },
    "required": [
      "House",
      "Group Size",
      "Week",
      "YTD",
      "Term"
    ]
  }
}

If you need to redo the JSON Schema due to a data set, the authorisation can be disabled temporarily in Arbor: 

1. Paste the URL in the browser. 

2. Copy of all the text for the house points. 

3. Re-enable the authorisation for link.  

4. In Power Automate, select Generate from sample. 

At Cloud Design Box, we help schools and trusts design smarter digital environments and get the most out of Microsoft Teams and SharePoint.  

Want to learn how we can support you? Talk to our team today.