Lookups

- When creating columns in a list or library,…one of the options that's typically used…is that of a dropdown menu,…or what SharePoint calls,…a Choice Column.…Choice Columns are ideal…when the options in the dropdown are few,…but if you require a long list of options,…or options that may change over time,…there is a better solution,…and it's one called Lookups.…Simply put, Lookups are a custom list…that you create or reference…that include all the choices…you'd want to see in a dropdown menu.…

Let's take a look at how you create one,…and then we can speak to the advantages of using them.…In this scenario,…Explore California wants us to add a column…to this document library,…and they want it called Language.…They've provided me with a spreadsheet…with 30 languages in it,…and they want to see those 30 languages appear…in a dropdown menu.…Now, in order to create a Lookup of those languages,…I need to create a Custom List first.…Then, once we have that Custom List created…with all the languages populated therein,…we would then create the column…

Resume Transcript Auto-Scroll

Author

Updated

5/13/2016

Released

12/5/2015

You've got the SharePoint basics covered. You've even dabbled in some of the more advanced functionality. Now you are looking for more. This course explores some of SharePoint's hidden gems: the need-to-knows, the gotchas, and plenty of cool "I had no idea this existed" functionality. Follow along and become the most well-rounded SharePoint user on the planet—or at least at your company.