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?
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?"
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
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 ...
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)
+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.
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
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
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
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/
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.
Great video. Thanks
Great video! You've helped me a lot
Glad to hear. Appreciate the feedback.
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.
I believe it can be. Lookup fields can be anything unique, that's the real trick
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?
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?"
If it doesn't show you can type it in manually.
Good article. Thanks!
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
k lewis you need to use the query parameter in Flow against the column
k lewis you need to use the query function against the column in Power Automate
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 ...
+Mike Taylor Lookup columns require a single referenced value in a column, this isn't the case with choice fields to my knowledge.
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)
Multiple columns cannot be displayed by default
@@directorcia Damn and darn! But I did get concatenated fields from you, so thank you; because that solved much of my problem.
great vid...is this limited to lookup lists within the same site ie. can you use lookup lists from other sites?
+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.
Thank you Robert, can you give us a hint? :-)
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
Check the views on the lists
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
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
Aimee Johnson yes you can flip the mode into data entry which makes the item like a spreadsheet with columns and rows
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/
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.
Create the lookup list. Create a new column. Configure to lookup new list. Delete original column.
Yes can do that. There are some workflows connected to the existing column. Will that get effected by this?
Yes it will if you delete the original
great job.
Thanks for the feedback
🤗
How to relate an ID from one list to another ID from another list
PowerAutomate
Robert I need your help!!
In respect to?