How to Add Location-Based Group Targeting to a SharePoint People List
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.

- 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.
Ensure you have Site Owner permissions on your SharePoint site and access to Microsoft Power Automate to create automated workflows.
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.
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'.
Open your new list, click on 'Add column', and select 'Location'. Name the column 'User Location' and save your changes.
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.
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.

Implement Custom Development with C#
For enterprise environments needing complex integration directly within the SharePoint interface, custom C# development can extend default grouping capabilities.
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.

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.




