Others

How to Add Location-Based Group Targeting to a SharePoint People List

Steve KSteve K Nov 4, 2026 869 views

Question details

Users need a way to group and target individuals by geographic location within a SharePoint list because the default location attribute cannot be manually modified.

Add Location-Based Group Targeting to a SharePoint People List
Product
Microsoft SharePoint
Device & OS
not provided
Scenario
Administrators want to create location-based groups to organize users efficiently, but the built-in Location field on the People and Groups page is locked.
Observed behavior
The default Location field is read-only because it synchronizes automatically from central user profiles, preventing administrators from manually editing location data.
Before you start

Ensure you have Site Owner permissions on your SharePoint site and access to Microsoft Power Automate to create automated workflows.

Solution 1Recommended

Create a Custom SharePoint List using Power Automate

Since the default People and Groups location field is locked, creating a separate custom list and syncing profiles via Power Automate provides an editable geolocation workaround.

This approach bypasses the read-only limitation of the default user profile synchronization. By maintaining a custom list, you can freely edit the location column while keeping the base user data up to date automatically.

1
Create a blank custom list

Navigate to your SharePoint site, click on 'Site contents' from the gear icon menu, select 'New', and then choose 'List'. Opt for a 'Blank list' and name it 'Location Targeted Users'.

2
Add a Geolocation column

Open your new list, click on 'Add column', and select 'Location'. Name the column 'User Location' and save your changes.

3
Set up a Power Automate flow

Open Microsoft Power Automate, click 'Create', and choose 'Scheduled cloud flow' to run a daily sync, or 'Automated cloud flow' if you want to trigger it when a new user is added.

4
Import profile information

Add the 'Get user profile (V2)' action from the Office 365 Users connector. Then, add a 'Create item' action for SharePoint to map the retrieved user details (like Name and Email) to your new custom list.

Create a Custom SharePoint List using Power Automate
Workflow Automation: Once the flow is activated, the custom list will populate automatically. You can now manually edit the 'User Location' column and use this list for location-based sorting and filtering.
Free Microsoft Office alternative

Manage Team Documents Effectively with WPS Office

While SharePoint handles your site structures and user lists, your teams still need reliable software to collaborate on the actual documents they share. WPS Office provides a fully featured, lightweight suite that helps localized groups create and edit files with ease.

Seamless compatibility with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Lightweight design that runs smoothly without heavily taxing system resources.Built-in PDF editing tools ideal for sharing localized team policies and reports.Familiar ribbon interface ensuring zero learning curve for users migrating from other Office suites.
microsoft office alternative - wps office

Frequently Asked Questions

Why can't I edit the Location field in SharePoint People and Groups directly?

The default Location field is mapped directly to the user's Microsoft 365 or Azure Active Directory profile. It synchronizes automatically from this central source, rendering it read-only within the SharePoint interface.

Can I use audience targeting based on location without a custom list?

Yes, if your IT administrator creates location-based security or Microsoft 365 groups directly in Azure Active Directory. Once created centrally, those groups can be used for built-in audience targeting in SharePoint.

Does Power Automate require a premium license to sync user profiles?

Generally, no. The standard connectors for 'Office 365 Users' and 'SharePoint' are included in most Microsoft 365 business plans, allowing you to sync basic user profile data without a premium Power Automate license.