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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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:
Actually I change from [NoUpdate] to [ForceUpdate] and it works ok now
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
coronoahcoroAuthor Commented:
Found the solution myself
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.