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 a bunch of rows from Excel to SharePoint using Datasheet view. Datasheet view doesn’t allow users 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…

Read more

Import from CSV to SharePoint List with People Picker Field Values

Requirement is: To add bulk of records from a CSV file to SharePoint list with People Picker field of “Allow multiple selections” set to “Yes”. Unfortunately, SharePoint datasheet view doesn’t allow us to copy-paste People picker values. So, I got to write the script! Here is my data to be imported to…

Read more

Set SharePoint Person or Group Field (People Picker) Default Value to Current User

Requirement: In a request tracking system, wanted to auto-populate people picker value from currently logged-in User.  Solution:  How to set the People Picker field value to the current user? Let’s use jQuery and SPServices to fetch the logged-in user name and fill the SharePoint list form’s people picker field value. In short,…

Read more

Apply Filters to People Picker in SharePoint – E.g. Don’t show User Accounts with No E-mail

Business Problem:Many users having more than one account/admin account in multiple domains. Now the problem is: when end-users select approvers from people pickers in various workflows, They select user account without E-Mail. Since the workflows are unable to get any E-Mails from the selected users, they are failing. What’s the Solution: Lets…

Read more

Delete Users and Clean up User Information List

Some time back, I wrote an article on deleting user accounts from “User Information List” to get rid of the issue: Deleted accounts shown in People Picker: SharePoint People Picker shows deleted accounts in Active Directory and SharePoint Since the people picker get data from both Active directory and “User Information List”…

Read more

People Picker not Showing All Users from Active Directory Domain?

In a Sandbox, Installed and configured SharePoint. Everything works great, except the People Picker. Problem is: People picker didn’t show any user from active directory, However it showed me the users from my local sandbox. Verified whether the Sandbox is joined to the domain. Yes, It is.  By default, the People picker…

Read more

Using People Picker in Custom Web Parts

People Picker in web parts:To get people picker inside web parts, you can use the People Editor class inside Microsoft.Sharepoint.WebControls namespace. People Picker in User control based web parts: For user control based web parts, you can simply use the SharePoint’s user control. Here is how: <%@ Register TagPrefix=”spuc” Namespace=”Microsoft.SharePoint.WebControls” Assembly=”Microsoft.SharePoint, Version=14.0.0.0,…

Read more