Failed to read lookup columns which allow multiple values from SharePoint using graph API

SYAMNA S T 70 Reputation points
2024-02-09T05:51:37.6+00:00

While trying read list from SharePoint using graph API, the response doesn't contain lookup columns that are supporting multiple values.
I am using below query GET /sites/{site-id}/lists/{list-id}/items?expand=fields
Can anybody tell how can I retrieve the missing data?

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
13,276 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,230 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. RaytheonXie_MSFT 39,761 Reputation points Microsoft External Staff
    2024-02-09T09:37:32.0566667+00:00

    Hi @SYAMNA S T, You could try following api to get lookup multiple values

    https://graph.microsoft.com/v1.0/sites/siteid/lists/dc0935d2-8cda-4bf2-b896-bb43e39bfbdb/items/2?expand=fields($select=Title,MultiLookup,MultiLookup_x003a_MyNumber)
    

    ---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.

    0 comments No comments

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.