Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cant access all columns in a Document Library to create a lookup column in a Sharepoint List

I am trying to establish a relationship between a Document Library and a Sharepoint list using Lookup columns in the Sharepoint list. When I begin creating/formatting this lookup column, and select the Document Library as my source, I do not have access to all the possible choices for the columns to relate back to the Sharepoint list. For instance, I am looking to relate a choice column called "Document Type" in my Document Library to a Sharepoint list column that references what type of document was uploaded to the library. I dont see any settings that wouldnt allow for my lookup column to be related to the Document Library columns of interest. Is there a reason why I only have access to some of my Document Library columns for a new lookup column in my Sharepoint list?


Hi @Anonymous ,

Sorry, I do not use lookup columns at all, so have never tried to do that.

Helpful resources

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (4,073)