SharePoint Online: How to Filter and Display Events

In this article, we show you how to filter events in SharePoint Online by categories and display them in a targeted manner.

Problem

Many organizations use SharePoint Online for managing events. However, it’s often difficult to filter events by categories or display only certain events on a page.

Solution: Filtered Views

SharePoint offers various ways to display events in a filtered manner:

1. Standard List Views

The simplest method is to use standard list views with filters:

1. Open your event list
2. Click on “Create View”
3. Select “Calendar” as the view type
4. Define filters by category, date, etc.

2. List Web Part with JSON Formatting

For modern SharePoint pages, you can use the List Web Part with JSON formatting:

 1{
 2  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/list-formatting.schema.json",
 3  "hideSelection": true,
 4  "hideColumnHeader": true,
 5  "rowFormatter": {
 6    "elmType": "div",
 7    "attributes": {
 8      "class": "sp-card-container"
 9    },
10    "children": [
11      {
12        "elmType": "div",
13        "attributes": {
14          "class": "sp-card-defaultCardButton"
15        },
16        "children": [
17          {
18            "elmType": "div",
19            "style": {
20              "display": "flex",
21              "flex-direction": "column"
22            },
23            "children": [
24              {
25                "elmType": "div",
26                "txtContent": "[$Title]",
27                "style": {
28                  "font-weight": "bold",
29                  "font-size": "16px"
30                }
31              },
32              {
33                "elmType": "div",
34                "txtContent": "[$EventDate]",
35                "style": {
36                  "color": "#666"
37                }
38              }
39            ]
40          }
41        ]
42      }
43    ]
44  }
45}

3. Power Automate for Dynamic Filtering

For more complex scenarios, you can use Power Automate:

1. Trigger: When an event is created/modified
2. Condition: Check the category
3. Action: Copy event to a separate list or send an email

Best Practices

• Standardize categories: Use Choice columns for consistent categories
• Multiple views: Create different views for different target audiences
• Audience Targeting: Use Audience Targeting for personalized event display

Conclusion

SharePoint Online offers flexible options for filtered event display. Depending on your requirements, you can use standard features, JSON formatting, or Power Automate.

Questions? Feel free to contact us!