Learn about why and how to create a list of values that can be used to populate a lookup column.
- [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.…SharePoint gives you the ability to connect one list…
Author
Released
10/25/2018- Why automate your documents?
- Planning your templates
- Creating a template library
- Working with content types
- Setting up the template library
- Building document libraries
- Creating and customizing document sets
- Adding a document to a library
Skill Level Advanced
Duration
Views
Related Courses
-
SharePoint: Compliance Management
with Tiffany Songvilay1h 25m Intermediate -
SharePoint for Enterprise: Create Web Surveys
with Gini von Courter52m 28s Intermediate -
SharePoint for Enterprise: Data Management (2018)
with Phil Gold1h 45m Intermediate
-
Introduction
-
1. Templates
-
Planning your templates2m 4s
-
Where to create a template2m 10s
-
Creating a template library1m 22s
-
Uploading your templates1m 24s
-
2. Working with Site Columns
-
What is a column?2m 34s
-
What is a site column?3m 11s
-
Planning your site columns2m 36s
-
Creating a lookup list1m 22s
-
Creating a site column5m 14s
-
Editing a site column4m 6s
-
-
3. Working with Content Types
-
What is a content type?4m 9s
-
Creating a content type4m 38s
-
Editing a content type1m 23s
-
-
4. Setting Up the Template Library
-
5. Building Your Document Libraries
-
Creating a library1m 3s
-
-
6. Working with Document Sets
-
What is a document set?1m 20s
-
Creating a document set2m 40s
-
Customizing a document set5m 50s
-
-
7. Adding Documents to a Library
-
Conclusion
-
Next steps1m 25s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Creating a lookup list