Forum Discussion

Copper Contributor

Feb 17, 2022

Solved

Lookup List Columns not showing up in the Source Column Choices

I am creating a list for approvals. I want to use a Lookup list in two of the columns. I created another list called Program Lookup List. It has the following Columns- Program (Which is the original ...

Lists

SharePoint Online

RobElliott
Feb 27, 2022
MelissaO915 what are the column types of those columns in that other list? If they are person/group, choice, multiple lines of text, calculated or Yes/No they can't be used in a lookup. Only single line of text, nu,mber and date/time columns are supported in a lookup.

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

ganeshsanap

MVP

Feb 28, 2022

MelissaO915 This is a known behavior in SharePoint. As RobElliott stated, SharePoint lookup columns only support few column types:

Supported Column Types:

Single line of text
Number
Date and Time

Unsupported Column Types:

Multiple lines of text
Currency
Person or Group
Calculated
Hyperlink or Picture
Custom Columns
Yes/No
Choice
Lookup

Microsoft Documentation: Create list relationships by using unique and lookup columns

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Sn3l3

Copper Contributor

May 23, 2024

ganeshsanap Does the ID field form part of this.