General

Re: Get email address from people picker

traveladic — Tue, 08 May 2012 15:27:01 GMT

Don't know how your SharePoint site permission are managed but this works for me.

In the people picker the AccountId field contains the username with the domain example infopathdev\traveladic. I use substring-after(accountid, "\") which change it to travaladic which the email data connection can resolve.

The only problem I have had with this method is, I can only get it to work with one person selected in the people picker. When I try this with multi people it only return the first name selected.

Re: Get email address from people picker

Alec Pojidaev — Mon, 12 Mar 2012 20:51:57 GMT

Here is how:

http://alecpojidaev.wordpress.com/2008/12/16/infopath-codeless-programming-walkthrough/

Re: Get email address from people picker

Jay@Work — Sun, 11 Mar 2012 19:32:55 GMT

Thanks Jody, I'm hoping to get something that will be forever automated

Re: Get email address from people picker

Jay@Work — Sun, 11 Mar 2012 19:30:33 GMT

Exactly, so that article is no good for me.
I need to be able to send FirstName LastName (Is that what is called Displayname?) and return the email address for that person.

The example uses FirstName and assumes the CurrentUser

Re: Get email address from people picker

JodyG — Fri, 09 Mar 2012 22:59:43 GMT

Not sure if this will help because I am not using SP...just an Access DB...

I gathered all short names (such as J. DOE) and corresponding emails of my dept and stored them in a db table and added as a secondary data source.

Added a role and approval section that has fields such as "Requestor:" or "Final Approval:" in which the requestor fills names out.

Created different email submits for each role.

On the "To:" field in the email submit, I used the follwing rule expression:

@Email_Adress[@ShortName = @Requestor] or @Email_Adress[@ShortName = @Engineer]...etc.

This gives an email address from the table filtered by user input of short name = particular role.

Fairly low tech and a bit of work to setup...but works good for the little stuff I am doing. Downside, I had to know upfront EXACTLY what everyone's email address is.

Having that said, if you don't know the exact email address...you could probably use concat() or a simlar expression to build the address based on user input.

Hope that helps :)

Re: Get email address from people picker

ErnestoM — Fri, 09 Mar 2012 16:08:16 GMT

But in that scenario, wouldn't FirstName need to be unique for the method to return only one email address?

Re: Get email address from people picker

Jay@Work — Thu, 08 Mar 2012 19:47:09 GMT

Thanks UserProfileService is the example I had seen but all the examples I saw assumed the email required was for the current user.

Assuming domain/johnd

We enter our user name in the people picker as johnd and this resolves to John Doe.
I'd need to take that value and return john.doe@ourdomain.com and put it "somewhere" so I could use it for an email action later.

I've seen examples that take the first name of the current user and match this to FirstName and return email

Re: Get email address from people picker

ErnestoM — Thu, 08 Mar 2012 13:50:27 GMT

People Picker is pretty limited. It's no wonder that people turn to third party tools or complex methods; you have to work around the restrictions in People Picker. I wrote a blog post a few weeks ago. I think the easiest alternative might be to use SharePoint’s UserProfileService to obtain the user’s info.

Get email address from people picker

Jay@Work — Thu, 08 Mar 2012 05:37:00 GMT

I've googled this and seen 2007 offerings that either spoke of 3rd party options or long winded ways of doing this (usually using the CurrrentUser as the example)

I hoped there might be something easier with 2010.
I have a form that includes a people picker which points to our main SP site and works fine.

I'd like an action on my form that gets the email address of the person in the people picker and sends the form to them as an attachment.

Also, is there a way to add an action to a people picker? I only seem to be able to find a formatting option under rules.