Lookup user info

lookupuserinfo.GIF

Last edited Sep 28, 2007 at 3:51 PM by unclepaul84, version 3

Comments

mmandel321 Today at 1:22 PM 
Note that the UserName property for SharePoint 2010 no longer reliably returns the username. We've found that sometimes this is blank for some of our users. But the Name property never seems to be empty. Name returns DOMAIN/username. So in workflows we have replaced looking up the UserName property with looking up the Name property and then stripping out the domain by using the "Extract substring from index of string" action afterwards. In our case the domain is 4 characters, so we start extracting at 6.

Joerg_Knoerchen Jan 15, 2013 at 9:39 AM 
Can this feature be added to work on lists as well!? I try to get the email address of the user that is stored at "Created By".

clarm060 Dec 20, 2012 at 7:30 PM 
Should this solution be removing subdomains from email addresses? our email addresses are setup as First.last@email.domain.com and with share point if you use just frst.last@domain.com exchange refuses the email. When i am creating a workflow with Send an Email Extended or not it removed the Email. part.

cyberpine Oct 4, 2012 at 9:35 AM 
PLEASE HELP. This is a great project. It works great from most of web applications, but for some reason I have a web application under SSL, where If I attempt to select the action in SPD but NOTHING happens.. no dialog box, nothing. Oddly, the same is true for the SEND EMAIL EXTENDED action. I figure the issue either SSL related or some kind of setting or conflict on my web application.
email me here jc (at) cyberpine (dot) com

agorlach Oct 18, 2011 at 10:04 AM 
Btw, the same activity for SharePoint 2010: http://www.harepoint.com/Products/HarePointWorkflowExtensions/Default.aspx

cyberpine Aug 11, 2011 at 7:51 PM 
Is this the same as Lookup Site User Property. I think I have it installed, but the I select it in the workflow action nothing happens. I'm on moss 2007 sp2 using spd 2007.

jonparish May 2, 2011 at 3:49 PM 
This was a little frustrating to figure out because I thought the "User Profile" info being queried was the user profile store. It's not. It's the Site User Info data as mentioned above. i.e. on any page, go to: Site Actions > Site Settings > People and Groups > Select a person. We routed those requests to a profile page, but the out of the box form tells you what fields you can query. Here are the ones that I could query in my environment:
Name (userid)
Title (person's name)
EMail
Notes (about me)
Picture
Department
JobTitle
SipAddress
FirstName
LastName
WorkPhone
Office
UserName
WebSite
SPSResponsibility

There may be other fields you can query that don't show up on that form, but these are the only ones I could get to work. Anyway, I hope this helps!

gguerrieri Apr 8, 2011 at 10:25 AM 
I found this very usefull for take correct internal name of metadata for User Info!

http://www.idocs.info/index.php/2010/08/sharepoint-designer-user-information-list-metadata-in-a-workflow/

zankok Apr 5, 2011 at 10:28 AM 
Dear Sir, how is it possible to get user mobile information through your plugin ? . i tried Mobile , Cell , PhoneCell didnt work out

Sassyrap Mar 11, 2011 at 12:26 PM 
Hi! where did you find the "lookup" action? My 2007 designer does not have it.

skimonkee Feb 18, 2011 at 12:12 AM 
I'm using WSS 3.0 and I can use this to get the full name (LinkTitle) so I know it's installed and working but what do I need to Lookup to get the phone number? Sounds like others are getting it but I've tried Work Phone, Phone, WorkPhone and Work_x0020_Phone with no luck.

NancyCentury Jul 2, 2010 at 1:54 PM 
I FINALLY was successful in pulling email Address by using SipAddress as the property to look up. It must be spelled like that, it will not work if you use SIPAddress or SIP Address or other permutations. Use SipAddress.

kalp1200_dom May 17, 2010 at 3:15 AM 
Hi..how do lookup to the "title" of the user..I tried title but I received the following error

System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: User not found.

The title refer to the position and its mapped in the SSP

fzakharov Mar 18, 2010 at 8:23 AM 
Look for fields name of your Sharepoint installation...If i want find email in russian installation i use
Адрес электронной почты
in field Lookup

NancyCentury Jan 11, 2010 at 12:08 PM 
Agreeing with the last post- my list uses several people-picker fields allowing multiple selections and there is no way to turn these into "friendly" name strings- we only get DOMAIN\user values (we want Firstname Lastname; Secondname Lastname; Thirdname Lastname etc.).

MayrunD Nov 25, 2009 at 8:46 AM 
Can you add the option to parse multiple users field (user1;user2;user3) in the next release?

Thanks, it's a great project!

JuanK Oct 19, 2009 at 10:25 PM 
Hi guys, somebody know how to obtain the office with this activity? i'cant , allways fails saying Property not found.
Other properties like department works ok.

raredesign May 22, 2009 at 2:41 PM 
I am using the lookup for capturing First name, Last name, and Work phone correctly, but I can't capture Department.

for instance:
Actions ---
then lookup Department property for Request Forms:Requestor, store in Variable:VarDepartment

I get an error:
5/21/2009 4:57 PM Error System.NullReferenceException: Object reference not set to an instance of an object.
at DP.Sharepoint.Workflow.LookupUserInfo.Execute(ActivityExecutionContext executionContext) Error

5/21/2009 4:57 PM Error System Account
An error has occured in ITRequestForms.
Thank you,

namz Apr 17, 2009 at 10:43 AM 
hello...
how do i get the server name in the sharepoint designer workflow?
Absolute Url give the whole path till the item ID. i just want the server name.
Many thanks in advance.

MutzMutz Apr 2, 2009 at 9:57 AM 
Hi.. I have the same problem with Saulius, Yannis..
When I lookup user info with department, it will show : System.NullReferenceException: Object reference not set to an instance of an object. at DP.Sharepoint.Workflow.LookupUserInfo.Execute(ActivityExecutionContext executionContext)..
Even I have key in the department information either in AD and SSP user profile.
Aniwei.. if lookup for deparment, is it based on CreatedBy or Modified By? How to get department information based on ModifiedBy? Thanks..

chiuhing Mar 4, 2009 at 10:52 AM 
Can I lookup the Manager field from the AD using this custom action? Thanks!

Kristian_V Feb 19, 2009 at 1:58 PM 
The property to get an email address based on a user (e.g. Created By) is Email and not E-Mail as stated elsewhere. Does anyone has a complete list for properties for Lookup function?

Thanks

brendenward35 Jan 29, 2009 at 3:30 PM 
Does this userinfo field use the Active Directory account or does it pull data in from SharePoint central admin profile accounts?
I have a horrible feeling it is Active Directory which will provide us with very little details so this useful tool cannot be used.
Any advice will be much appreciated.
Thanks

nwade Jan 21, 2009 at 2:51 PM 
Nevermind...I'm an idiot. It worked after I filled out a new form. I was running the workflow on an existing item.

nwade Jan 21, 2009 at 2:46 PM 
When I use the LinkTitle property and display the value of that in an email it comes up as ????. Should the LinkTitle property be something that can be selected or do I simply type in LinkTitle (or "LinkTitle" with quotes)? I must be doing something wrong if others are getting it working.

Saulius Jan 8, 2009 at 2:52 PM 
Please help manage exception, when field is empty, ex. if department field is empty I received:
System.NullReferenceException: Object reference not set to an instance of an object.
at DP.Sharepoint.Workflow.LookupUserInfo.Execute(ActivityExecutionContext executionContext)
Maybe it's posible to receive empty string or at least "N/a".
Thanks.

amila_h Dec 24, 2008 at 8:16 AM 
Is this still working only with libraries ? I tried with a list but failed.

coustack Dec 8, 2008 at 1:17 PM 
I am able to return the email but it seems to add a 1;# before the address. Anyone else have this problem and were able to resolve it?

rujodi Dec 4, 2008 at 4:40 PM 
I was able to get the Account Name from the "Person or Group" field type by doing a lookup "Name" but I am not sure if that will work unless you use that field type. However from the Person or Group field type you can use "E-Mail" to get the user's email address and use "LinkTitle" to the the user's name.

drxanadu Nov 25, 2008 at 8:51 PM 
How do I get Account Name based on Email?
How do I get Account Name based on Full Name?

rujodi Nov 10, 2008 at 5:20 PM 
To retrieve a user's email address use "E-Mail".

ani Nov 4, 2008 at 5:22 PM 
Hello

How to retrieve a users email address? I tried Work e-mail, email, Email address, any suggestion ?

mgarofalo Oct 22, 2008 at 2:21 PM 
what is the property name to retrieve a users email address? I've tried Work e-mail, email, Email address and all return out of range errors in workflow. Any ideas?

cehammontree Sep 19, 2008 at 8:55 PM 
Arg... Never mind my last post... after reading unclepaul's post on the main page about activating this feature I was telling myself that it was.. well then I noticed that my "Web Application" wasn't even the right app.. I had mistakenly assumed this was activated server wide.. not at the application level... Another note, I had to restart SPD for it to "redownload" from the server after "correctly" activating the right web application..

cehammontree Sep 19, 2008 at 8:36 PM 
Does this only work with MOSS? I'm trying to use this via plain old WSS 3.0 and when I select the custom Actions I get nothing in the Action box.

jamessl Sep 19, 2008 at 3:19 PM 
Please can anyone tell me whether this is a fix for the lack of functionality of LookUp User Info in lists? I'd really like to resolve the customer field in the free MS IT Helpdesk WSS application which is displaying as DOMAIN\user in workflow emails.

petpet Sep 17, 2008 at 4:46 PM 
Hi, I'd like to ask you what's the right order to get a full name from the Created by person ( as described dprior with LinkTitle):
Lookup LinkTitle property for MyList:Created by, store in Variable:Variable. Is this rught ?
How can I work with variable value later ?
thanks in advance

Winson Sep 2, 2008 at 1:15 AM 
I've tried this one but I still got ??? in the email. So I've written a C# program to fix this problem. It works fine! So please tell me the way to post this C# program for everyone.

hmmm Aug 1, 2008 at 2:08 PM 
Excellent! Worked a treat Thanks dprior

dprior Jul 30, 2008 at 9:56 PM 
To get the Users Full Name and not domain\username, you need to use LinkTitle as the property lookup. You should receive the users Full name back.

hmmm Jul 29, 2008 at 2:55 PM 
If I put in Name, I get Domain\username
If I put in FirstName I get ???????
property for; is using current item: Modified By
I need to get the First name and Last name fields
Is there any issues with SP1?
thanks in advance

ekapic Jul 21, 2008 at 3:25 PM 
I developed a couple of activities that pull that information out of MOSS User Profile store. Feel free to get them from my blog: http://edinkapic.blogspot.com/2008/05/user-profile-sharepoint-designer.html

firebat Jul 7, 2008 at 8:55 PM 
Anyway to get the Manager's Name? That would be extremely useful.

mnaji Jul 3, 2008 at 1:36 PM 
i need to get the Manager name. is that possible? i tried but not working for me...

hinshelmw May 7, 2008 at 8:51 AM 
OK, created a project for a profile version http://www.codeplex.com/MOSDActivities

hinshelmw May 6, 2008 at 2:59 PM 
This feature is not using the UserProfileManager but the SiteUserInfoList objects. This means that the fields that are availlable are diferent from the users profile. You can only get:
Content Type ID : 0x010A004A2DA8C209A5544B95C86E5DE652660B
Name : ##useraccount##
Approver Comments :
File Type :
Account : ##useraccount##
Work e-mail : ##EMAILAddress##
About me : <div></div>
SIP Address : ##SIP##
Locale :
Calendar Type :
AdjustHijriDays :
TimeZone :
Time Format :
Alternate Calendar Type :
CalendarView Options :
WorkDays :
WorkDay StartHour :
WorkDay EndHour :
Is Site Admin : True
Deleted : False
Picture :
Department : GTC
Title : ##Title##
Is Active : True
First name : Roddy
Last name : Crossan
Name : ##useraccount##
Work phone : +44 141 551 6068
Office : Aggreko Technology Centre
User name : ##useraccount##
Web site :
Responsibilities : BI Support
ID : 2
Content Type : Person
Modified : 19/04/2008 00:00:06
Created : 13/02/2008 13:45:59
Created By : ##username##
Modified By : 1073741823;#System Account
Has Copy Destinations :
Copy Source :
owshiddenversion : 26
Workflow Version : 1
UI Version : 512
Version : 1.0
Attachments : False
Approval Status : 0
Edit :
Name : ##useraccount##
Select : 2
Instance ID :
Order : 200
GUID : {20A045C3-3DE2-4630-ADF1-327AF7E3F3A2}
Workflow Instance ID :
URL Path : /_catalogs/users/2_.000
Path : 2;#_catalogs/users
Modified : 19/04/2008 00:00:06
Created : 13/02/2008 13:45:59
Item Type : 0
Effective Permissions Mask : 0x7fffffffffffffff
Name : A##useraccount##s
Unique Id : a0f870f7-68a0-480f-8e30-371b63ec919f
ProgId :
ScopeId : {B2662D04-A75F-42F5-8B32-A5E0F4401876}
HTML File Type :
Edit Menu Table Start : 2_.000
Edit Menu Table End : 2
Name : ##useraccount##
Name : ##useraccount##
Type :
Server Relative URL : /_catalogs/users/2_.000
Encoded Absolute URL : http://##site##/_catalogs/u

File Name : 2_
Property Bag :
Level : 1
Is Current Version : True
Group : ##useraccount##
Edit :
Name : ##useraccount##
Picture :
Name : ##useraccount##
Name : ##useraccount##
Edit :
Selection Checkbox : 2
Content Type : Person

This would be much better as the profile info

markwms May 2, 2008 at 1:27 PM 
I've got the same questions as liamkennedy.

When I lookup on the following field names, I get the following results:
If I put in Department, I see the correct department.
If I put in Name, I get Domain\username
If I put in displayName I get ??????
If I put in PreferredName I get ??????
If I put in First Name I get ???????

Mich Apr 18, 2008 at 6:45 AM 
First of all: Many thanks fpr your work, it really helps me :)
Now about my problem:
I get an System.ArgumentOutOfRangeException and Property not found Error when i try to lookup to some fields (e.g. Manager).
The fields are filled in the profile... What can i do?

liamkennedy Apr 15, 2008 at 4:48 PM 
I'm trying to get the "friendly name" of the user to appear rather than the login id (eg... DOMAIN\user). I thought I should be able to specify "Name" however that still brings out the login ID. Any ideas on how I can get this? Thanks!!

vbvbvb Mar 18, 2008 at 1:22 PM 
The action to 'Lookup x property for user' is not avaliable if X is a null. This is from workflow jornal : System.NullReferenceException: Object reference not set to an instance of an object.
at DP.Sharepoint.Workflow.LookupUserInfo.Execute(ActivityExecutionContext executionContext)

EricSammann Jan 9, 2008 at 8:46 PM 
I seem to have the same problem as hasmb. The action to 'Lookup x property for user' is not avaliable as an option if a list is selected in the 'What SharePoint list should this workflow be attached to?' If a document library is selected then several other actions are viewable. Most actions make sense to be viewable only to a doc library. It would be nice if the Lookup user property was avaliable to lists as well though.

CherylD Jan 8, 2008 at 8:27 PM 
I am having similar problem as yannis. I am only able to retrieve the "Name" attribute of the Userlist. Which happens to be identical to the Name lookup field... something is missing here, perhaps in the C# code that doesn't specify return fields in the query??

yannis Oct 4, 2007 at 1:02 PM 
Additionally to my previous comment, the error message that I get is: "System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values. Parameter name: Property not found"

yannis Oct 4, 2007 at 12:59 PM 
Even though I can get standard AD values (e.g. "Department" - as in the screenshot) I have trouble getting 'extensionAttribute1' value. Does anyone know why this happens?

hasmb Oct 3, 2007 at 12:06 PM 
this action is just working on the document library not working on the lists