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)

drjdbb

Copper Contributor

Jul 15, 2023

MelissaO915 RobElliott ganeshsanap
I believe it is more complicated than either previous responses.
Calculated Fields of Numeric Type are unsupported, while user-entry numeric are.
However, Calculated Fields of Single Line Text ARE supported.
All the fields below in the red bracket are Calculated Text fields in the source list.
I have not investigated all calculated field types.