While in edit mode, I paste several rows worth of data into my list. One of the columns is a Person/Group field.

I keep getting an error message telling me that the "user does not exist or is not unique."

To solve it I select that cell and type in the name that was there in the first place, but this time the predicted name pops-up and I select it. This can really slow things down when I have a lot of records to upload.

So why is it that it doesn't recognize the name when I paste it, but it does when I retype it?


Person and Group fields search for the user and resolve the user with presence by using the user's SharePoint ID. Try replacing the names with their SharePoint user IDs and see if that works.

| improve this answer | |

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.