NameLookup does not pull Phone number

I have 2 fields that looks for username, the gets the email address and phone number from user's person document.

Creator_Email: @NameLookup([NoUpdate]; @UserName; "OfficePhoneNumber")
Creator_Ext: @NameLookup([NoUpdate]; @UserName; "OfficePhoneNumber")

The problem is there is one user reported that the extension did not pull out. It came out blank.
1. I have checked on the person document and the phone number is there
2. the email address pull out correctly, but when I tested changing the first letter of first and last name to lower case (ie. Test.User@domain.com to test.user@domain.com), the field that pulls the email address still show up with Upper case.
3. I have tried to take the user.id and test it on a different PC and the problem persists.

Any idea why this happens? I know there are 2 address books set up in the company and that is not ideal but I have checked the 2 address books and make sure all the needed information are there.
LVL 2
coronoahcoroAsked:
Who is Participating?
 
coronoahcoroConnect With a Mentor Author Commented:
Actually I change from [NoUpdate] to [ForceUpdate] and it works ok now
0
 
IanThCommented:
sounds like there is a problem with the extension number for the affected user like it has a control character or something
0
 
coronoahcoroAuthor Commented:
I have deleted the number and added it back in but still no result.
0
 
umeliCommented:
Did you try to change from [NoUpdate] to [Exhaustive]?
0
 
coronoahcoroAuthor Commented:
Found the solution myself
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.