SharePoint Integration

Re: How can retrieve email address from the Infopath people/Group picker

gregc72 — Tue, 09 Apr 2013 13:17:35 GMT

I'm having the same issue. "I used substrings" was a little vague but enough to go on and do a little research.

What I'm doing is setting a People picker with a rule based on the selection of another piece of data. I get the double commas.

In the rule I set the Field which is a lookup to a secondary data source with some filtering then the text looking for in this case ",," and what I wanted to translate it to "," using the Substring Translate function.

So, My Rule Value looked like this translate(DisplayName[Project_Number = Project Number], ",," , ",") This did not accomplish what I thought it would, still returned the double comma.

Could you elaborate on what you did a little bit more? Thanks.

Re: How can retrieve email address from the Infopath people/Group picker

traveladic — Wed, 11 Jan 2012 22:51:18 GMT

got it resolved just used substrings

Re: How can retrieve email address from the Infopath people/Group picker

traveladic — Wed, 11 Jan 2012 21:15:37 GMT

I am having a problem related to this,

I have a people/group selector on a sharepoint site which infopath is to read and use for sending email but when AccountId is pulled down it add an extra comma to the AccountId witch outlook doesn't recognize

example: "smith, bob" is what I want "smith,,bob" is what I get.

I check the information on the sharepoint site and it is ok, and all my other people/group picker in infopath work so it something in the data connection.

Re: How can retrieve email address from the Infopath people/Group picker

warrtalon — Sun, 09 Jan 2011 23:47:28 GMT

What do you need to do with this email address? The AccountId value works for sending emails if you're trying to send workflow emails based off this field. If that's not good enough, you can retrieve the WorkEmail value of the user's profile from the User Profile Service by using the technique on my blog. You must first set the query parameter of GetUserProfileByName to the AccountId value, then query, then set some other text field to the WorkEmail value of that data set. You can't add this value to the Contact Selector schema, though, so don't bother with that.

InfoPath - Get user information without writing code (extended)

One trick you'll need to know is that you can't fire a rule on the Contact Selector nodes, so you'll need to do this:

Create a dummy text field called "username" that won't be shown on the form
Set its default value to the AccountId node of the Contact Selector
Add a rule to the username field that first sets the AccountName query field of GetUserProfileByName to the username field, then queries the web service, then sets the email field's value to WorkEmail per the article above

How can retrieve email address from the Infopath people/Group picker

herohero — Mon, 13 Dec 2010 22:20:51 GMT

How can retrieve email address from the Infopath people/Group picker?When I add the people/Group picker into the infopath form, I only get 3 fields DisplayName,AccountId,AccountType.Can anyone show me how can I get the email either by configurations or by code.