Monday, January 19, 2015

The text entered for Person or Group Column isn’t an item from the list. Select an item from the list, or enter text that matches one of the listed items

Problem: End-user wants to copy paste bunch of rows from Excel to SharePoint using Datasheet view. Datasheet view doesn't allow user to paste the data for Person or Group type column! it gives the error message:
The Text entered for the "Person or Group column" isn’t an item from the list. Select an item from the list, or enter text that matches one of the listed items.

The text entered for Person or Group Column isn’t an item from the list. Select an item from the list, or enter text that matches one of the listed items

Root cause: This is by design! SharePoint 2010 datasheet view uses Microsoft access run time engine, which doesn't has any interface to connect and resolve user names from active directory (or any other authentication provider). So, it fetches user names from User information list of SharePoint site collection. That being said: If you enter a new user who is not there in UIL, datasheet view can't resolve it!

Workaround:
In order to fix this problem, prior copy-pasting to datasheet view, we should have them all in user information list! So, Just add all users from people picker column values to SharePoint site (E.g. you can add them to any group like site visitors) that will add users to UIL automatically!



You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Check out these SharePoint products:

No comments :

Post a Comment

Please Login and comment to get your questions answered!


You might also like:

Related Posts Plugin for WordPress, Blogger...