Forum Discussion
Lookup List Columns not showing up in the Source Column Choices
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)
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
Similar thread: Column with lookup doesn't show the selected list columns
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.
- Thank you both for your reply! I appreciate it very much.
MelissaO915 As I'd given the original reply which was only confirmed by ganeshsanap I'd have thought my reply should have been marked as the best solution.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)- RobElliott, I didn't see your reply and was only looking at it on my phone. I wasn't aware it made a difference but I went ahead and updated the response. I apologize, this is the first time I have ever posted to this platform.
ganeshsanap Does the ID field form part of this.
