Maximum number of selections in a single lookup column in SharePoint Online

Question

What is maximum number of selections allowed in a single lookup column in SharePoint Online?

I need to create lookup column to another list with >200 selections, is that possible?

Answer 1

Hi @Yiru Chen

There is no direct article about the column limits of SharePoint Online, however in SharePoint Server, each column type has a size value listed in bytes.

The sum of all columns in a SharePoint list cannot exceed 8,000 bytes, and I think this will also apply to SharePoint online.

The following picture shows column limits from Microsoft boundaries and limits.

The maximum number of selections in a single lookup column depends on the sum of all columns in your list.

So It’s possible to create a lookup column to another list with >200 selections if they are not exceed 8,000 bytes.

Similar issue for your reference:

https://stackoverflow.com/questions/45030320/max-number-of-columns-in-a-list-in-sharepoint-online

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

---

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.