Sharepoint Online List Lookup Column doesnt work

Adrian Turner 96 Reputation points
2021-02-23T13:57:59.373+00:00

Using Sharepoint Online List I have created a column to look up data from another List in the same teamsite but despite following the Microsoft instructions on how to do this and tried it several times I can confirm somewhat unsurprisingly that it doesnt work, it either shows NOTHING or a Link saying REQUIRED INFO which takes you to a side page which is just as hopeless. I shall have to work around it with calculated fields which is a pain, but better than mucking about for hours with something that clearly doesnt work.[AllItems.aspx][1] [1]: https://tenant.sharepoint.com/sites/Teams_Performance/Lists/Fire%20Statistics%201403%20%20Stations%20%20Appliances/AllItems.aspx

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,211 questions
{count} votes

1 additional answer

Sort by: Most helpful
  1. Li Zhang_MSFT 1,566 Reputation points
    2021-02-24T06:25:53.38+00:00

    Hi @Adrian Turner ,

    Look up column is aim to let people choose values based on information that is already stored in the site, there is no default value, it’s necessary for users to select value manually.

    If we set “No” to Require that this lookup column contains information when you created a lookup column, it is empty.

    71417-empty.png

    If we set “Yes”, it will show Required info.

    71424-required-info.png

    We will see values after editing list items to select value for lookup column.

    71451-select-value.png

    If it is not feasible for you, please feel free to reply.

    ---------------------------------------------------------------------------------------------------------------------------------------------------------------

    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.