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".

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.

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

Btw, the same activity for SharePoint 2010: http://www.harepoint.com/Products/HarePointWorkflowExtensions/Default.aspx

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.

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!

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/

Dear Sir, how is it possible to get user mobile information through your plugin ? . i tried Mobile , Cell , PhoneCell didnt work out

Hi! where did you find the "lookup" action? My 2007 designer does not have it.

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.

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.

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

Look for fields name of your Sharepoint installation...If i want find email in russian installation i use
Адрес электронной почты
in field Lookup

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.).

Can you add the option to parse multiple users field (user1;user2;user3) in the next release?

Thanks, it's a great project!

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.

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,

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.

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..

Can I lookup the Manager field from the AD using this custom action? Thanks!

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

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

Nevermind...I'm an idiot. It worked after I filled out a new form. I was running the workflow on an existing item.

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.

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.

Is this still working only with libraries ? I tried with a list but failed.

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?

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.

How do I get Account Name based on Email?
How do I get Account Name based on Full Name?

To retrieve a user's email address use "E-Mail".

Hello

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

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?

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..

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.

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.

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

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.

Excellent! Worked a treat Thanks dprior

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.

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

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

Anyway to get the Manager's Name? That would be extremely useful.

i need to get the Manager name. is that possible? i tried but not working for me...

OK, created a project for a profile version http://www.codeplex.com/MOSDActivities

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

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 ???????

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?

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!!

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)

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.

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??

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"

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?

this action is just working on the document library not working on the lists