Forum Discussion

Copper Contributor

Feb 17, 2022

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)

RobElliott

Silver Contributor

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)

mcrv21

Copper Contributor

Apr 22, 2024

RobElliott

hi, sorry for revamping an old topic.

I've created 3 lists.

1 - Vendors (only title field)

2 - Code (Code field and a Lookup to "Vendors"

3 - General

If I add a lookup on "Code" on list 3, Vendor doesn't show up. all the fields are text.

any idea?

thanks a lot