question

PushpanjayUmrao-3126 avatar image
0 Votes"
PushpanjayUmrao-3126 asked ChelseaWu-MSFT commented

Showing User Profile result in Microsoft Search by User Property Like Work Phone

I have a requirement that when a user is being searched by his Phone number his profile should be shown in results in People vertical. The way its done when you search by users name.

Result when searched By User Name
75365-peoplebyname.png


Result when searched by Work Phone
75389-peoplebyphnum.png


I found a similar question in https://social.msdn.microsoft.com/Forums/office/en-US/224c144a-3347-4d40-8fba-19cbcae0cecd/user-profile-property-search?forum=sharepointsearchlegacy

In the answer they say to enable a property name FullTextQueraable. However I could not find such property. Does this enable property take care of the issue even for modern search. If yes can you please guide how can I enable the same.

Else is there any other way to make this work?


office-sharepoint-online
peoplebyname.png (63.5 KiB)
peoplebyphnum.png (12.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ChelseaWu-MSFT avatar image
0 Votes"
ChelseaWu-MSFT answered ChelseaWu-MSFT commented

Please note:

  1. Phone numbers (Work Phone included) in user profiles are automatically crawled with built-in (managed) properties CellPhone and WorkPhone, which can be found via SharePoint admin center > Search > Manage Search Schema.
    These properties are set “Queryable” by default and there is no need for extra configuration.

    75587-screenshot-2021-03-09-093221.png

  2. The search results for phone numbers will only appear under the People vertical. Switch to People tab on search results page and see if you get the specific user returned.

    75607-screenshot-2021-03-09-094650.png

    Referring to this document: Customize the search results page, a connection can be added as a content source only under one vertical, which means it is not supported to put People search results under the All vertical.

  3. If you cannot see the expected result under People tab, it is possible that the properties are not synced to SharePoint yet. You can see the document here for the user profile sync process in Microsoft 365.
    Note that it might take longer than 24 hours for the phone number properties to sync and return in search results.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @PushpanjayUmrao-3126 , do you have any progress on this thread? Please feel free to let us know if you need further assistance.

0 Votes 0 ·

Hi ChelseaWu,

Thanks for the response. But i am still facing the issue with the same. Lets take example of user test user Akash. When I search this user by his phone number i get the desired result. However it only works when I search the full phone number.

79050-akash-search-by-number.png

But for all other users in the organization like me this doesn't work.

When Searched by user name

78967-pushpanjay-search-by-name.png

When searched by phone number

79065-pushpanjay-search-by-number.png

The only difference between the first case and the second case is the + sign for country code. I tried searching with and without + sign but it didn't show any result.






0 Votes 0 ·

Also i found this setting in managed property of Work Phone. It is disabled. Shouldn't this be checked.

79077-searchable-setting.png


0 Votes 0 ·

To answer your questions:

  1. It is the expected behavior that you can only get the desired result with full phone number. SharePoint does not recognize individual numbers or part of the string as a valid keyword. If you want to search for user profile by part of the phone number, wildcard operator (*) to enable prefix matching.

  2. The managed property must be Queryable to be returned in search result, which is listed underneath. The Searchable option is not necessary.

  3. The one phone number that can be used to search for people is the one synced from the user profile service application: Work Phone (The one under "Basic Information"). You may check if the phone numbers get properly synced via SharePoint admin center > More features > User profiles > Manage User Profiles.

Reference: Keyword Query Language (KQL) syntax reference.

0 Votes 0 ·