How to Create a Self-Updating SharePoint Employee Contact List
Question details
The user needs to automatically synchronize an employee contact list in SharePoint Online with information stored on an external website or intranet.

- Product
- Microsoft SharePoint Online
- Device & OS
- not provided
- Scenario
- Keeping an employee directory up to date continuously without manual data entry by pulling contact information from an external source.
- Observed behavior
- SharePoint Online lacks a built-in, out-of-the-box feature to continuously synchronize contact lists natively with external websites.
Verify that your external website or source database provides an accessible API, supported connector, or structured data feed that can securely transmit contact details.
Use Microsoft Power Automate to Sync External Data
Set up a Power Automate flow to connect your external data source to your SharePoint contact list for automated synchronization.
SharePoint Online does not feature a native capability to automatically sync list data with external websites. To achieve a self-updating contact list, you must build an integration using Microsoft Power Automate alongside an accessible API or data connector from your source website.
Log into your Microsoft 365 portal and open Microsoft Power Automate from your available applications.
Select 'Create' from the left-hand menu and choose either 'Automated cloud flow' (if your source supports webhook triggers) or 'Scheduled cloud flow' (to fetch updates at regular intervals).
Add a trigger corresponding to your external data source. If a native connector is unavailable, use the 'HTTP' premium connector to make a REST API call to your external website's data feed.
Click 'New step', search for SharePoint, and select the 'Create item' or 'Update item' action. Enter your SharePoint Site Address and select your Employee Contact List from the dropdown menu.
Click inside the SharePoint column fields (such as Name, Email, and Department) and map them to the corresponding dynamic content variables retrieved from your external data source trigger. Save and test the flow.

Need a Lightweight Alternative to Manage Employee Data?
If complex Power Automate integrations and expensive enterprise setups aren't necessary for your small team, WPS Office offers a free, highly compatible, and lightweight spreadsheet solution to manage employee contact directories with ease.
- 1. Download and install: Install WPS Office Free on your Windows, Mac, or mobile device.
- 2. Create or import contacts: Open WPS Spreadsheet to create a new employee directory or open an existing Excel contact list.
- 3. Share with your team: Use the built-in collaborative tools to securely distribute the updated contact list to your colleagues.

Frequently Asked Questions
Can SharePoint Online pull data directly from an external website without third-party tools?
No, SharePoint Online does not have an out-of-the-box feature for continuous data synchronization from external websites. You must use an integration tool like Microsoft Power Automate to bridge the two systems.
What prerequisites do I need to connect Power Automate to an external intranet site?
Your external intranet or website must provide an accessible API, a supported data connector, or a structured data feed (such as a custom REST API) that Power Automate can securely authenticate with and read.
Are there alternative methods to import external contacts into SharePoint?
If continuous, self-updating synchronization is not strictly required, you can manually export your employee contacts as an Excel spreadsheet or CSV file from the external site, and use the 'Export to SharePoint' feature or manual import to update your list.




