Get user from Person or Group Field in Sharepoint List


There is a situation I need to add item to list and send mail to person who is on the same item xxxx field. Here xxxx is the person or group field and I set show field as “Name” [!i.e Display Name]  in list settings .  If we try to get values using properties.listItem[xxxx] it returns a junk characters with DisplayName and again we need remove the junk characters and query to user profiles to get the mail id. Sometimes [user profile not synchronized well] it didn’t query to get value based on “DisplayName”.

So this situation I try to get the actual user of the filed instead of DisplayName. then i try the following code in event receiver. 

SPFieldUser userField = (SPFieldUser)properties.OpenWeb().Lists[listName].Fields.GetField("xxxx");
SPFieldUserValue fieldValue=(SPFieldUserValue)userField.GetFieldValue(properties.ListItem["xxxx"].ToString());
accountName = fieldValue.User.LoginName;

here fieldValue.User is SPUser,  the SPUser.logingName returns Account name of the user. However finally I got mail id from user using Email Property of SPUser.
MaiId=fieldValue.User.Email
 

Comments

  1. Unknown27 July 2013 at 03:49

    I am getting error
    Unable to cast object of type 'Microsoft.SharePoint.SPFieldText' to type 'Microsoft.SharePoint.SPFieldUser'.
    foreach (SPListItem item in oCollection)
    {
    string sites = null;
    SPList lst = oSite.OpenWeb("/SiteName/", false).Lists["User Profiles"];
    SPFieldUser userField = (SPFieldUser)lst.Fields.GetField("User Name");
    SPFieldUserValue fieldValue = (SPFieldUserValue)userField.GetFieldValue(item["User Name"].ToString());
    htmlOutput += fieldValue.User.ID;
    }

    oSite is SiteCollection Object
    appreciate you help

    ReplyDelete

Post a Comment

Popular posts from this blog

PAGE NOT FOUND ERROR PAGE IN SHAREPOINT 2013

Image
Default PageNotfound\404 page   - By default, all the Publishing sites contain a default Error\404 page  “PageNotFoundError .aspx” page which is added to the “Pages” library (See below). This page can be modified to add some custom text. “Error Page” Content Type -   To allow users to Create a new 404 Error page, Publishing Sites now contain a new Content Type “ Error Page “.This Content type Inherits from “Page” Content type and has a typical layout of a Page Not found or 404 pages. To find this Content type Navigate to Site Settings -> Content Types -> Error Page. Create a New PageNotFound or 404 Page  – To Create a new 404 page admins can navigate to the “Pages” Library and under the “Files tab” select “New Document”.In the “New Document” drop-down menu select “Error Page” (see the screen below). Once you have Created a new Error Page you can modify it by simply clicking the page in the pages library and editing it. Once done Check In and Pub
Keep reading

Send Mails in SharePoint Event Receiver

After I getting the user, email id from item( described in Previous Post) . Now I need to send mail to the user, I tried lot of ways to send mails and finally I realise that below code is best for my scenario to send mails. SmtpClient smtpClient = new SmtpClient(); smtpClient.Host = properties.Web.Site.WebApplication.OutboundMailServiceInstance.Server.Address; MailMessage mailMessage = new MailMessage(MailFrom, mailTo); mailMessage.Subject = MailSubject; mailMessage.Body = MailBody; mailMessage.IsBodyHtml = true; smtpClient.Send(mailMessage); here smtpClient.Host is getting the local mail server address and we include from, to and subject, body in MailMessage and finaly send the message using smtpClient.Send(mailMessage), and don’t forgot to include try catch blocks. Good luck.
Keep reading

Get Host site list items in SharePoint Hosted App.

Those who starts working on Apps might face issues to read host site list items. In sharepoint hosted APP using Rest API we able to query host site list items. The rest url to get host site is almost similar to get list items but we need to specify the app context and target. Make sure JQuery loaded before to execute the code in app web parts. 'use strict'; var HostUrl=""; var AppUrl==""; // load function // Intialize HostUrl, AppUrl from query strings. // call get items method $(document).ready(function () {         HostUrl= GetQueryString("SPHostUrl");        // Get Host Url from query string         AppUrl= GetQueryString("SPAppWebUrl");        // Get App Url from query string getItems("DemoList");                                        // get list items }); // function to get list items using Rest Api function getItems(listname) {             $.ajax({                 url: AppUrl + "/_
Keep reading