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 Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
11,200 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,108 questions
0 comments No comments
{count} votes

Accepted answer
  1. RaytheonXie_MSFT 33,176 Reputation points Microsoft Vendor
    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