This tutorial will how to create a column in a new SharePoint item that refers or 'looks up' information from an existing SharePoint list or library. You'll see how to create the lookup column as well as how to edit the column headings.
Great video tutorial, really useful! Does this lookup function not work with choice columns? I was struggling to get it to see choice columns at all in the selection - text columns, fine, but not choice ...
Hello Robert, Thanks for the article! how can i add this columns (Person, Email Address, Business Phone) to a content Type ? (i already tried but i can't find the Person:Email Address and Person: business Phone columns on the Content Type is it considered as a Calculated columns?) i hope you have an idea :) Many thanks
+John Tropea By default the lookup is limited to the current site. You can do lookups from other locations but you'll need to typically do that another way.
Very useful video. I'm wondering if it is possible to LookUp value of Managed Metadata type? I've tried and checked possibilities. It seems that the data type that can support Look up in SharePoint is Single line of text, Location, Number and Date.
Robert Crane can Look up be circular? If I have an "Issues List" and add a "Rooms" Lookup column, can the Issue item show up in the Rooms List of I create an "Issues" Column?
Hi Robert, If I wanted to add say 100 'Locations' into my share point list, is there an easier way to do so by uploading a spreadsheet instead of having to type the individual offices in. Many thanks
Hello Robert, I have a lookup column from a list but some how first four id's are not displaying in the lookup however these four items were being displayed 2 weeks ago. Master list still has those four items and no changes were made in the list and items. Initially it happened to first 2 id's now recently with next 2 id's Please suggest if you have any idea
I'm trying to replicate what you are doing with my own lists. At 2:50, you select the 1st list you created. Under "Add a column to show...." you have all the columns in that first list. When I get to this part, I don't see all the columns in my 1st list. Instead I just see columns that I didn't even add such as Title, Compliance Asset Id, ID, Modified, Created, Version and Title (linked to item). Why can't I see a list of columns in that 1st list I am referencing? Edit: The column in the first list that I can't see in the lookup column of the 2nd list is called PLC. For some reason, I can now view the PLC column if it is of the type "single line." If the type is "choice" then the PLC column doesn't appear as choice in my 2nd list, in the column that will contain the lookup data type. How can I view the PLC column even if is of type "choice?"
good article, but aren't lookup lists major causes of slowdowns in sharepoint? eg: say I had a first list of Aussie postcodes (about 16000 values according to the ABS), and used that as a lookup list in a second list of ''my customers'' where i had their contacts and addresses (obviously postcodes, state and suburb being the lookup values), then had a third list with ''customer issues'' and the third list looks up the customer details, which in turn looks up the postcode/suburb info... Isn't that going to cause major slowdown? Thank you.
SharePoint supports millions of items per list. SharePoint is now auto indexing columns to further speed up access. So goo design and index columns mitigates any slowdown issues.
Many thanks for the reply Robert - searching on the web all the articles are for SP 2010 or maybe 2013 and all recommend not using (large) lookups as they slow the system down too much, I guess I can only do some testing to see what sort of impact the large lookups I'd like to implement will actually make. Also nice to hear an Aussie accent on youtube, keep up the good work mate.
Im fairly certain the recommendation is to not use more than 8 lookup columns in sp2010, 12 in 2013 in any list. I suppose the recommendation on items is the same as the list view threshold - 5000 is the default. Thats still alot for any 1 view sympmarc.com/2012/07/23/sharepoints-list-view-lookup-threshold-and-why-we-dont-change-it/
Great video, but how do we get the lookup field to show up in Power Automate for a custom flow? I need the lookup value of an email address to be available. Thanks
Is there an option to change the "Get Information From" list once the lookup column is created? I already have a lookup column but would like to change the Lookup list. Unfortunately in the List Settings this option is Grayed out.
Any idea of how to get multiple fields from the linked list to display when you are adding a column? So that the drop down shows multiple columns from the linked list? You had surname and full name. if you have surname, title and ID and department that you want to show from another list. This would prevent people choosing the incorrect name, as only surname is visible currently. Would be much appreciated (SharePoint 2016 not 365)