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 do...
Keep reading

Hide the Upload Button of the Doucment Library

Open your site using SharePoint Designer.  Once opened, navigate to your Library and edit your default view.  (All Files -> Your Library -> Forms -> Your View.aspx , right click and select Edit File in Advanced Mode) At the bottom of the screen you will see three options Design, Split, and Code.  Select the Split option. In your code window, locate the  <asp:Content ContentPlaceHolderId=”PlaceHolderMain” runat=”server”>   tag. Now, scroll down and find the closing  </asp:Content> tag.  Insert a line above the closing tag.  Place the following code into that newly created blank line. <style type="text/css">  #Ribbon\.Documents\.New\.AddDocument-Large { display:none; }  #Ribbon\.Library\.Actions\.OpenWithExplorer-Medium { display:none; } </style> Click save, then refresh your page.  The Documents tab should now be missing the Upload Document button and the Library tab should be...
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");                   ...
Keep reading