https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/124350.aspxFri, 13 Aug 2021 19:29:47 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124350Evanz0https://www.infopathdev.com:443/forums/thread/124350.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=124350<p>&nbsp;</p>https://www.infopathdev.com:443/forums/thread/124349.aspxFri, 13 Aug 2021 19:28:43 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124349Evanz0https://www.infopathdev.com:443/forums/thread/124349.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=124349<p>Hi, I am trying to use the concat for a name field to get the first name and last name (a period between first and last name) as <a href="mailto:Lisa.Sanchez@XXX.com">Lisa.Sanchez@XXX.com</a> from the people picker. </p><p>I create a name field and insert from &quot;<i>Fx</i>&quot; with concat(<span style="font-size:11pt;mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;">substring-before(DisplayName), &quot;@&quot;), &quot;@XXX.com&quot;) and <font face="Arial"><b><font color="#767676">People picker</font></b> returns display name in flow run as &#39;Sanchez, Lisa&#39; (the way user profiles are created there is a comma between first and last name)&nbsp;</font>as Sanchez, <a href="mailto:Lisa@XXX.com">Lisa@XXX.com</a> which does not give me the correct email address. I wonder is there any &quot;Substring&quot; settings to get the correct email format from the people picker&nbsp;as <a href="mailto:Lisa.Sanchez@XXX.com">Lisa.Sanchez@XXX.com</a><font color="#000000"> ? It&#39;s greatly appreciated. </font></span></p><p>&nbsp;Best Regards, &nbsp;</p>