How to Use External Outlook Contacts in Microsoft Lists
Question details
The user wants to reference contacts stored in a personal Outlook Contacts folder within a Microsoft Lists column.

- 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.
Ensure you have permission to create new apps and lists on your SharePoint site, and verify that you can access the classic SharePoint experience.
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.
Navigate to your SharePoint site and click on 'Site Contents' from the left-hand navigation menu or the gear icon.
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'.
Open your newly created Contacts list. From the top ribbon, select the 'List' tab and click on the 'Connect to Outlook' button.
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.

Synchronize Contacts using Power Automate
Set up an automated flow to copy new external contacts from Outlook directly into your SharePoint list.
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. Download the Installer: Visit the official WPS Office website and download the free version for your operating system.
- 2. Install the Software: Run the setup file and follow the standard installation prompts to configure the software.
- 3. Manage Your Lists: Open WPS Spreadsheets and use built-in templates to start organizing your contacts and daily tasks immediately.

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.




