Extract email address from Person Picker control - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Extract email address from Person Picker control

Last post 10-29-2012 03:43 PM by brice235i. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 10-28-2012 06:41 PM

    Extract email address from Person Picker control

    Hi, does anyone know how to extract an email address from a person picker control?  I tried using

    concat(substring-after(AccountId, "\"), "@domain.com")

    Unfortunately the address does not resolve.

    Thanks in advance.

  • 10-29-2012 09:45 AM In reply to

    Re: Extract email address from Person Picker control

    Have you verified the account id contains the domain when the form is used in the browser?
    Hilary Stoupa

  • 10-29-2012 03:43 PM In reply to

    Re: Extract email address from Person Picker control

    Thank you.

    I should have mentioned that this technique was working for the form when it was published as am InfoPath Filler form. It stopped working when I published as a web browser form due (end users on different versions of InfoPath).  The emails fail to trigger.

    concat(substring-after(AccountId, "\"), "@domain.com") The Account ID returned DOMAIN\userID.

    As a rough work around I created the following fields:

    Full Name: DisplayName (of person picker control)

    First Name: substring-after(IssuerFullName, ",")

    Last Name: substring-before(IssuerFullName, ",")

    Dot: .

    Email suffix: @domain.com

    IssuerEmail: concat(IssuerFirstName, Dot, IssuerLastName, santos.com)

    I changed the data connection to send to IssuerEmail, and this works.

    Only problem is some people have a middle initial in their email address.  I've added the email text field to the form and invited users to edit if necessary.

    If you know of any better way I'd really appreciate hearing about it.

    Thanks again,

    Nicolle.

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.