Forum Discussion
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 do this?
Thanks
8 Replies
Pn1995 If you are going to use this metadata over and over, it might make more sense to add the value to the term store and use managed metadata.
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.
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
Maggan WåhlinI was just surprised it worked at all. ;)
Create a site column for each of your fields, and then add them to a site content type. This way, you can reuse the columns in multiple lists. Enable use of content types i List settings -> Advanced settings.
Regards,
Margareta
Thanks Maggan Wåhlin
Are you basically saying to create the fields in the "Site Columns" sections
Then delete the individual fields we already have in the existing list and use the field that was create in the "site column" section
Yes, this way you can reuse the same fields in many lists. Follow this procedure:
1) Create the site columns
2) Add the site columns to a custom content type
3) Add the content type to any list that will use your custom fields
