SharePoint Document Issues

How to Use External Outlook Contacts in Microsoft Lists

John WilsonJohn Wilson Oct 29, 2026 869 views

Question details

The user wants to reference contacts stored in a personal Outlook Contacts folder within a Microsoft Lists column.

How to Use External Outlook Contacts in Microsoft Lists
Product
Microsoft Lists
Device & OS
not provided
Scenario
Attempting to assign or reference external partners and clients in a list.
Observed behavior
Microsoft Lists Person columns only search the organization directory and cannot directly retrieve or use contacts from a personal Outlook Contacts folder.
Before you start

Ensure you have permission to create new apps and lists on your SharePoint site, and verify that you can access the classic SharePoint experience.

Solution 1Recommended

Create a SharePoint Contacts List and Connect to Outlook

This method creates a dedicated list for external contacts that can be manually synced with your Outlook application.

Since the default 'Person or Group' column only queries Azure Active Directory, setting up a classic SharePoint Contacts list allows you to host external contacts on your site and interact with them via Outlook.

1
Access Site Contents

Navigate to your SharePoint site and click on 'Site Contents' from the left-hand navigation menu or the gear icon.

2
Create a Contacts List

Click 'New' and select 'App'. If necessary, click the link to return to the classic SharePoint experience, locate the 'Contacts' template, and create a new list named 'External Contacts'.

3
Connect to Outlook

Open your newly created Contacts list. From the top ribbon, select the 'List' tab and click on the 'Connect to Outlook' button.

4
Copy External Contacts

Allow your browser to open Outlook. The SharePoint list will now appear as a contact folder in Outlook. You can drag and drop or copy your personal external contacts directly into this new folder to make them available in SharePoint.

Create a SharePoint Contacts List and Connect to Outlook
Sync Confirmation: Any updates made to these contacts within the connected Outlook folder will automatically reflect in the SharePoint list.
Free Microsoft Office alternative

Boost Your Productivity with WPS Office

While Microsoft SharePoint handles complex enterprise directories, you can simplify your daily document and list management with WPS Office. It provides a lightweight, fast, and feature-rich suite to manage contacts, spreadsheets, and reports without expensive subscriptions.

  1. 1. Download the Installer: Visit the official WPS Office website and download the free version for your operating system.
  2. 2. Install the Software: Run the setup file and follow the standard installation prompts to configure the software.
  3. 3. Manage Your Lists: Open WPS Spreadsheets and use built-in templates to start organizing your contacts and daily tasks immediately.
Fully compatible with Microsoft Office formats (Word, Excel, PowerPoint).Manage contact lists efficiently with the robust and intuitive WPS Spreadsheet tool.Lightweight installation with blazing fast loading times.Familiar interface that requires zero learning curve for Office users.
microsoft office alternative - wps office

Frequently Asked Questions

Why can't I select my personal Outlook contacts in a Microsoft List Person column?

The 'Person or Group' column in Microsoft Lists is specifically designed to query your organization's Azure Active Directory. It does not integrate natively with personal Outlook contact folders or external guest lists.

Do I need administrator privileges to create a SharePoint Contacts list?

You do not need full tenant administrator privileges, but you must have at least 'Edit' or 'Design' permissions on the specific SharePoint site to create new apps and lists.

Will connecting a SharePoint list to Outlook delete my original contacts?

No. Connecting the list creates a new, separate contact folder in your Outlook application. Your original personal contacts remain unaffected unless you manually move them.