Missing Column Values in the Employee Directory

Introduction

Vitextra Employee Directory web part supports two types of data source: Azure AD and User Profiles. In the case of using SharePoint User Profiles as a data source, some columns may be empty in the details view.
This guide describes the core reason if the issue and workaround to resolve it.

Data Flow

User Data flow is following:

  1. User Profile is updated manually or automatically
  2. SharePoint Search Crawler gets data from User Profiles and put it in Crawled Properties
  3. SharePoint Search Service populate data to Managed Properties according to search schema (mapping between crawled properties and managed ones)
  4. Employee Directory retrieves data from Managed Properties

Employee Directory has a predefined set of Managed Properties which is used to populate employee attributes. Also, you can use custom properties to extend the set of employee attributes.

šŸ’” Tip
Use our how-to guide to create custom searchable user profile properties:
How To Create Custom Searchable User Profile Property

Column Mapping

The Employee Directory uses the SharePoint search service to retrieve user profile data. The table below presented column mapping between employee attributes in the Employee Directory web part, User Profile and SharePoint search schema:

Employee Directory ColumnProfile PropertyCrawled PropertyManaged Property
DisplayNameHiddenTitleTitle
FirstNameFirstNameFirstNameFirstName
LastNameLastNameLastNameLastName
JobTitleTitleSPS-JobTitleJobTitle
DepartmentSPS-DepartmentSPS-DepartmentNot Mapped
WorkPhonesWorkPhoneWorkPhoneWorkPhone
MobilePhoneCellPhoneCellPhoneMobilePhone
HomePhoneHomePhoneHomePhoneNot Mapped
WorkEmailWorkEmailWorkEmailWorkEmail
LocationNot existsNot existsLocation
OfficeLocationSPS-LocationSPS-LocationBaseOfficeLocation
AboutAboutMeAboutMeDescription
SchoolsSPS-SchoolSPS-SchoolSchools
SkillsSPS-SkillsSPS-SkillsSkills
InterestsSPS-InterestsSPS-InterestsInterests
ProjectsSPS-PastProjectsSPS-PastProjectsPastProjects
ResponsibilitiesSPS-ResponsibilitySPS-ResponsibilityResponsibilities

The lack of managed properties in the search schema is the main reason that some columns in the details views are empty.

Search Schema

To manage search schema open SharePoint admin center and go to More Features and select Open under Search heading:

SharePoint Admin Center

SharePoint Admin Center

Select Manage Search Schema:

SharePoint Search Settings

SharePoint Search Settings

Employee Directory refers to managed properties defined in the search schema.

SharePoint Managed Properties

SharePoint Managed Properties

Managed property may be mapped to one or more crawled properties. In this article, we will look at the following case: crawed property is not mapped to existing managed property.

šŸ’” Tip
Crawled Properties are created automatically by SharePoint Crawler. It may take up to 24 hours for a new property to shows up in the search schema.

Map Crawled Property to existing Managed Property

In the case of crawled property exists, you can map it to existing managed property to make it available for searching as well as for Employee Directory. As you can see SPS-Department* crawled property not mapped to the managed property by default.

Select Crawled Properties on the command bar:

SharePoint Search Command Bar

SharePoint Search Command Bar

Choose People category and click Apply button:

SharePoint Crawled Properties

SharePoint Crawled Properties

Scroll down and select SPS-Department property in the list:

SPS-Department Crawled Property

SPS-Department Crawled Property

Click Add mapping:

Crawled Property Details

Crawled Property Details

In the dialog type department in the search field and click Search. Once search results show up select Department property in the list and click Add button.

Managed Property Selection Dialog

Managed Property Selection Dialog

Click OK button to save your changes.

šŸ“ Note
It takes up to four hours for changes in the search schema to apply.

As soon as the search schema is updated, you can use the managed property to show data in the Employee Directory.