0

I'm importing an excel list with many columns, but one of the columns is unable to be used in a lookup table. The column contains the multiple owners for the main object and sharepoint can't read it for some reason. Every other column can be used for a lookup but this one. I want to use this column to show who owns the object being reference in a documentation list. Sorry if this is phrased incorrectly, let me know what more info you need.

  • You're trying to get the owners using a lookup from another list? – Erin L Jun 27 '16 at 15:17
  • The list contains information imported from excel. Each Row has the ID, Name, Owner, etc of the specific item. The owner column isn't working in sharepoint. When I want to create a document in the document library I have a lookup to the list that gets the Name, but I can't get a lookup to work for the owner. – tesorrells Jun 27 '16 at 15:22
0

This isn't an excel issue. Person or group fields can't be retrieved using a lookup. You can get around this by using code, or by making a string copy of the owner field by running a workflow each time the item is changed, and the string can be retrieved using a lookup.

  • The problem is, that sharepoint isn't recognizing them as people or groups, it's just multiple lines of text – tesorrells Jun 27 '16 at 19:02
  • Right, you can't import a person/group field from Excel (sharepoint.stackexchange.com/questions/41297/…). Easiest way to get the owner would be to create a person/group field, go into datasheet view, and copy the single line of text into Owner. This won't work for users who have never logged into your site collection, but there's a workaround; let me know if you need it. – Erin L Jun 27 '16 at 19:13
  • My list has 7442 entries and each one has 1-6 owners. That is going to be very painful. – tesorrells Jun 27 '16 at 19:30
  • It's just like copying and pasting an entire column in excel. It should only take a couple minutes. I don't know however, off the top of my head, whether it will work for multiple owners. – Erin L Jun 27 '16 at 19:34
  • What is the work around for those who haven't logged into the site? My site pulls user data from our outlook user database, so everyone in the company is there. – tesorrells Jun 27 '16 at 19:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.