This article provides an overview of how to enable and manage SharePoint Contact Integration within YakChat. This feature allows a tenant to synchronize contacts from a specified SharePoint list so they are available within YakChat for lookup and messaging. The configuration of this feature is performed at the plan level.
Availability:
SharePoint Contact Integration is available across all YakChat plans; however, the configuration must be completed for each specific plan.
Configure SharePoint Contact Integration
Follow these steps to access and configure SharePoint Contact Integration.
Step 1: Access the Plan Configuration
- Navigate to Plans.
- Select the relevant plan.
- Click Edit Plan.
- Scroll to Contact Management → SharePoint.
Step 2: Enable Unified Contact Management
Please note that while newer plans, by default, have it enabled when they are created, older plans may have it disabled.
Follow the steps below to enable it.
- Locate Enable unified contact management in the Plan Settings panel.
- Toggle Enable.
- In the Contact Management section in the Plan Settings panel, locate SharePoint.
- Toggle Enable.
Two additional fields will appear.
These fields must be completed for YakChat to connect and retrieve contacts.
- SharePoint Site URL – URL of the SharePoint site containing the list.
- List Name – Name of the SharePoint list containing contact records.
Supported SharePoint Sites and Lists
- Classic Experience: uses Contacts Lists templates
- Modern Experience: uses Generic Lists templates
Note: SharePoint contact lists must contain required fields. See Required SharePoint Contact Fields below.
Grant and Test Permissions
The Grant Permissions button authorizes the YakChat Contact Lookup Services application to access the Microsoft 365 tenant.
Requirements
- The user performing this action must be a Microsoft 365 tenant admin.
- Non-admin users cannot grant permissions; Microsoft will block consent.
- A Microsoft consent screen will display the full list of required permissions.
Permissions Requested
- Contacts.Read (Application) – Read contacts in all mailboxes (Outlook contacts)
- Sites.Read.All (Application) – Read items in all SharePoint site collections (SharePoint contacts)
YakChat requests a combined set of Microsoft Graph application permissions used for both Outlook and SharePoint contact lookups. Both permissions must be approved in the Microsoft consent window.
Step 1: Grant Permissions
- Click Grant Permissions.
- Approve the Microsoft permissions consent screen.
Step 2: Test Permissions
- Click Test Permissions to validate the connection.
This performs an API call to confirm:
- The grant was successful.
- YakChat can access the required endpoints.
The status returned will indicate success or error. This test validates access only; it does not confirm list contents.
Required SharePoint Contact Fields
For YakChat to import contacts correctly, the SharePoint list must include at least one field from each required group. Columns are case-sensitive.
Required Name Field:
- Title (Despite the name, this maps to Surname in Classic Contact Lists)
Phone Fields (at least one required):
- CellPhone
- WorkPhone
- HomePhone
Accepted Fields:
There are seven column names that may be used in a Modern list. All other columns will be ignored.
- Title
- FirstName
- CellPhone
- WorkPhone
- HomePhone
- Email
- Comments
All fields must contain text values. Phone numbers should be formatted for conversion to E.164, but strict formatting is not required.
Add New Contacts to a Modern SharePoint List
To add contacts quickly for use with YakChat.
Follow Steps 1 - 4 if you do not have a Modern SharePoint list yet.
If there's an existing Modern SharePoint list already, please proceed to Step 4.
Create an Excel spreadsheet containing the contact details.
- A maximum of five fields can display in the messaging app.
- The Title field is required and typically contains the last name.
- Only one phone number is shown in the app; only the first phone field from left-to-right will display.
- Create a Modern SharePoint list.
- Navigate to the SharePoint site where the list will live.
- Select New → List from the site’s command bar.
- Choose a name for your list.
- Add columns matching the required fields on your spreadsheet.
- Set all columns to Text/SingleLineText type in the list.
- Copy the contact rows (without including the column headers) from the spreadsheet.
In SharePoint:
- Click Edit in grid view.
- Click Add new item (do not click within the text box).
- Paste the rows using Ctrl + V.
Column names and field types cannot be changed once created. Data can be modified after creation.
Related Articles