look up column through rest api in sharepoint

smk 1 Reputation point
2020-12-18T06:15:58.307+00:00

how to get data of look up column of a list using rest api in sharepoint page .

Microsoft 365 and Office SharePoint Server Development
{count} votes

1 answer

Sort by: Most helpful
  1. MichaelHan-MSFT 18,126 Reputation points
    2020-12-21T03:12:57.707+00:00

    Hi @smk

    Consider your lookup column name as "lookup" of "List2" and "Title" field of "List1" is source to lookup field.

    You could use the below query to get data of look up column:

    /_api/web/lists/getByTitle('List2')/items?$select=Title,lookup/Title&$expand=lookup  
    

    49798-image.png


    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.

    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.