Email different in app compared to SharePoint people picker

Like (1) Share

Report

Posted on 23 Apr 2025 13:46:36 by rpersad

742

When I checked the app the people picker variable shows the email with capitalized letters, however, when I check the people picker in SharePoint the email is shown in all common letters.

The Office365Users.MyProfileV2() also returns the email in all common letters.

Therefore when making the comparison Office365Users.MyProfileV2() = varUser.Email it return false.

Example:

Office365Users.MyProfileV2().Email returns the email john.doe@email.com

varUser.Email returns the email John.Doe@email.com

I checked the active directory and the email is set to all common letters.

Categories:

General Questions

All responses (4)

Answers (0)

Suggested answer

Michael E. Gernaey 42,301 Super User 2025 Season 1 on 23 Apr 2025 at 23:31:47

Like (0)

Report

Email different in app compared to SharePoint people picker

Hi @rpersad

Yeah as in my first post, you need to use Lower() to convert them to be the same.

Its a standard issue.
BCBuizer 22,096 Super User 2025 Season 1 on 23 Apr 2025 at 20:03:13

Like (0)

Report
Email different in app compared to SharePoint people picker

Hi @rpersad,

As per @Michael E. Gernaey,s suggestion, you may use the Lower() function to convert all characters to lower case:

Lower(Office365Users.MyProfileV2()) = Lower(varUser.Email)

If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.
rpersad 742 on 23 Apr 2025 at 18:16:32

Like (0)

Report

Email different in app compared to SharePoint people picker

Hi @Michael E. Gernaey,

I updated my post to include more information.
Suggested answer

Michael E. Gernaey 42,301 Super User 2025 Season 1 on 23 Apr 2025 at 17:38:44

Like (0)

Report

Email different in app compared to SharePoint people picker

Hi @rpersad

It really helps if you share pictures of what you are referring too as you are saying words, but not sharing the details that you see.

So just to be clear

MyProfileV2() I assuming you mean .mail, is the person's actual email

User().Email is actually their UPN NOT their email

If you want them to match for sure, then use the

Lower(User().Email)

on both sides. Yes you may get a delegation warning, which we can get around, but since its just that person check its not a big deal.