People Picker Display Text - InfoPath Dev
in

InfoPath Dev

People Picker Display Text

Last post 09-05-2014 05:41 PM by JenniferLindsay. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 08-28-2014 04:09 AM

    People Picker Display Text

    I have created a form that uses People Picker from a SharePoint Site.

    When the person is picked the display is Dimitrio P Adrian.

    How can I change this to Adrian P Dimitrio

    I cannot change or add an entry in the Database.

    If possible could this be done in non code

    Regards

    Adrian 

     

     

  • 09-05-2014 05:41 PM In reply to

    Re: People Picker Display Text

     Unfortunately you can't change the display of a people picker.  However you can include a calculated value field that will display the name in the correct order. Just use something like the following formula as the default value for the calculated value: 

    concat(substring-after(substring-after(DisplayName," ")," "), " ", substring-before(substring-after(DisplayName," ")," "), " ", substring-before(DisplayName," "))

    Jennifer Lindsay
    Qdabra® Software/InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™

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