How to Create a Personalized SharePoint Calendar by Geographic Location
Question details
The user wants to set up a company-wide SharePoint calendar where events are only visible to employees in the specific geographic location the event pertains to.
- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Managing a global or multi-location company calendar where local events (like a Calgary office celebration) should only be visible to local employees, avoiding calendar clutter for others.
- Observed behavior
- A standard calendar displays all events to all users. The goal is to restrict visibility conditionally based on user groups tied to geographic locations.
Ensure you have 'Full Control' or 'Design' permissions on the SharePoint site to modify list settings, and verify that your geographic user groups (e.g., 'Calgary Employees') are already created in your Microsoft 365 admin center.
Use Item-Level Permissions for Calendar Events
This solution involves creating a single centralized calendar and manually breaking permission inheritance for specific localized events so only targeted regional groups can view them.
By default, all items added to a SharePoint calendar inherit the permissions of the calendar itself. To restrict who can see a specific regional event, you must stop this inheritance and specify exactly which geographic group gets access.
Navigate to your SharePoint site, click on 'Site Contents' (or the gear icon > Add an app), search for 'Calendar', and create a new calendar list for your company-wide events.
Open the newly created calendar, click on the desired date, and fill out the details for your regional event (e.g., 'Calgary Office Celebration'). Save the event.
Click on the event you just created to view its details. In the ribbon at the top, select 'Shared With' or 'Manage Access', then click on 'Advanced'. In the advanced permissions page, click 'Stop Inheriting Permissions' in the top ribbon and confirm.
Select the existing groups you want to remove and click 'Remove User Permissions'. Then, click 'Grant Permissions', enter the name of your specific geographic user group (e.g., Calgary Employees), choose their permission level (typically 'Read'), and click 'Share'.
For general events intended for the entire organization, you do not need to break inheritance if the calendar is already public. Alternatively, you can specifically grant 'Read' access to the 'Everyone except external users' group.
Looking for a Lightweight Alternative for Daily Office Tasks?
While SharePoint is excellent for managing centralized company calendars and intranets, you might want a faster, more affordable solution for your daily document creation. WPS Office provides a comprehensive suite for Word processing, Spreadsheets, and Presentations without the heavy subscription fees.
- 1. Download and Install: Visit the official WPS Office website and download the free version for Windows, Mac, or Linux.
- 2. Open Your Files: Launch WPS Office and directly open your existing Microsoft Office documents. There's no need to convert formats.
- 3. Work Seamlessly: Use the intuitive tabbed interface to manage multiple documents, spreadsheets, and presentations in a single window.

Frequently Asked Questions
Can I automate the process of setting location-based permissions in a SharePoint calendar?
Yes. While manual configuration works for occasional events, you can use Microsoft Power Automate to create a flow. When a new calendar event is created with a specific 'Location' metadata tag, the flow can automatically break inheritance and assign permissions to the corresponding geographic group.
What happens if an employee moves to a different geographic location?
If you are using Microsoft 365 groups to manage your geographic locations, you simply need to update the employee's group membership in the Microsoft 365 Admin Center. Their calendar access in SharePoint will automatically update to reflect their new location's events.
Will users see a blank calendar if there are no events for their location?
If a user has access to view the Calendar list itself but no permissions for any specific localized events during a given month, the calendar grid will simply appear empty to them.
Can I hide the entire calendar from external users or contractors?
Yes. Navigate to the Calendar's list settings, click 'Permissions for this list', stop inheriting permissions from the parent site, and remove any external user groups. Ensure only internal groups or 'Everyone except external users' have Read access.




