Hi Karin,

Would the contains() function work you instead of endsWith()? My initial guess is that the endsWith() function is battling against the way SharePoint stores a value for the Person and Group column in the background. I think what you see onscreen for that column is a bit different than the value that is stored behind the scenes. 

Jason

Hi @Karin_EM 

The value in the People Picker field "Authorized Approver" is actually the Login ID.

It doesn't contain the Display Name. As such, your function

EndsWith("Authorized approver", "/C") will always evaluate to False.

Use the userProfileLookup function to obtain the Display Name (which contains the /C or /CS). 

userProfileLookup("Authorized approver", "PreferredName") 

The final function should look something like below

EndsWith( userProfileLookup("Authorized approver", "PreferredName"), "/C")

@JRoberts suggests using the Contains() function. I agree! This is actually better because if the Display Name has a space e.g. "Garrett /C ", the Endswith() function will not evaluate as you intended. 

Again, this would also work but you still need to use the userProfileLookup() function first.

Contains( userProfileLookup("Authorized approver", "PreferredName"), "/C")

Below is a form with the People Picker, 2 Calculated Value fields and their formulas. 

Cheers

PS: Name and Email photoshopped. I don't work for Nintex... yet