Others

How to Create a Self-Updating SharePoint Employee Contact List

Jason MillerJason Miller Nov 3, 2026 868 views

Question details

The user needs to automatically synchronize an employee contact list in SharePoint Online with information stored on an external website or intranet.

How to Create a Self-Updating SharePoint Employee Contact List
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.
Before you start

Verify that your external website or source database provides an accessible API, supported connector, or structured data feed that can securely transmit contact details.

Solution 1Recommended

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.

1
Access Power Automate

Log into your Microsoft 365 portal and open Microsoft Power Automate from your available applications.

2
Create a new flow

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).

3
Configure the external data trigger

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.

4
Add a SharePoint action

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.

5
Map dynamic content fields

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.

Use Microsoft Power Automate to Sync External Data
Power Automate Community Support: For complex flow logic, custom API parsing, or troubleshooting integration errors, it is highly recommended to consult the Microsoft Power Automate Community forums.
Free Microsoft Office alternative

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. 1. Download and install: Install WPS Office Free on your Windows, Mac, or mobile device.
  2. 2. Create or import contacts: Open WPS Spreadsheet to create a new employee directory or open an existing Excel contact list.
  3. 3. Share with your team: Use the built-in collaborative tools to securely distribute the updated contact list to your colleagues.
Fully compatible with Microsoft Excel (.xlsx) formats for easy contact list sharing.Free and lightweight alternative to heavy enterprise Office suites.Familiar user interface ensuring zero learning curve for new employees.Seamless migration of your existing contact spreadsheets.
microsoft office alternative - wps office

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.