Forum Discussion
Pn1995
Apr 03, 2019Brass Contributor
Using SharePoint List Fields in 2 List
HI We have a SharePoint List and in this we have a a couple of fields (site name and location) with drop downs entries that we would like to use in a totally different list. Is there a way to ...
SteveMorley
Apr 03, 2019Brass Contributor
Pn1995Another way, which I found by accident. Create a second list, called something meaningful.
Create two columns "site name" and "location". Fill in the values with Quick Edit.
Go back to your original list, and use lookup fields pointing to this new list.
I like Site Columns a lot, but if there are going to lots of additions to the drop downs, you can assign someone else to update this list, and they don't have to be Site Owners.
Maggan Wåhlin
Apr 03, 2019Iron Contributor
SteveMorley, of course this is an option, but I really recommend the use of content types, for the benefit of reusability. The content type could then contain the lookup field you describe, and values can be added by members.
Regards,
Margareta
- SteveMorleyApr 03, 2019Brass Contributor
Maggan WåhlinI was just surprised it worked at all. ;)
- Maggan WåhlinApr 03, 2019Iron Contributor:-)