How to get the people picker column details from SharePoint list using graph API

Patidar, Jaydeep 20 Reputation points
2024-06-18T12:05:52.6566667+00:00

I have SharePoint list which has a column of type 'person or group', and i am making a graph API call from SPFx code but not getting that column values like name and email etc.

Microsoft 365 and Office | SharePoint | For business | Windows
Microsoft Security | Microsoft Graph
0 comments No comments
{count} votes

Accepted answer
  1. RaytheonXie_MSFT 40,476 Reputation points Microsoft External Staff
    2024-06-19T02:00:27.36+00:00

    Hi @Patidar, Jaydeep,

    You could use lookupUserId to get user item. The Look Id is the Id in the SharePoint Hidden List named "User Information List", you can get the list guid using the request:

    https://graph.microsoft.com/v1.0/sites/site-id/lists?$filter=DisplayName eq 'User Information List'
    

    Then use the list guid in the endpoint below to get the detail email address:

    https://graph.microsoft.com/v1.0/sites/site-id/lists/UserInformationListId/items/lookupid
    

    Here is a similiar thread for your reference:

    How to get user from User field LookupId


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.