Skip to main content

I have a people picker field (called EmployeeName) in my form that brings in the current users preferred name. I then have a calculated value field that matching EmployeeName to bring in the user name. However the user name comes in with the claim token and domain name when all I want is the user name. I have tried different options in the replace function of the calculated value field and I am close but cant get rid of the | does anyone know how to do this??

I tried using replace(EmployeeName, "i:0#.w|admhn"

Use the formula: subString(replace(EmployeeName,"i:0#.w|domain",""),2,length(replace(EmployeeName,"i:0#.w|domain","")))

201727_pastedImage_1.png

Outcome:

201728_pastedImage_5.png


you have to escape these characters since they are given special meaning.

use

replace(EmployeeName, "i:0#.w\|admhn\\", "") 

Thank you so much!!!


Reply