From the course: SharePoint Advanced: Document Creation and Automation

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Creating a lookup list

Creating a lookup list - SharePoint Tutorial

From the course: SharePoint Advanced: Document Creation and Automation

Start my 1-month free trial

Creating a lookup list

“

- [Instructor] Next, let's talk about two of the options that we have for creating those columns that provide you with the drop down list of pre-populated values. There are two types of columns in SharePoint that allow you to make selections from a set of options. Those are the choice column and the lookup column. A choice column is best used when you have a standard set of choices that never changes or doesn't change very often. In this case, we have the event type column, which is breakfast, lunch, dinner, breakout, and wedding. The entries in this list do not change very often. A lookup column is best used when you have a dynamic set of information that you need to select from. As the number of entries grow within the list, the options in the drop down list are also updated. In this case, we have our table of leads. So as new leads are added, we would want them to appear in the drop down. Typically, this is one column out of many in another list or library within your site…

Contents