Showing results for 
Search instead for 
Did you mean: 

User().email and SharePoint person.mail return different values

I have created an app that queries for data from SP list. In the list I have "Person or group" field which is filled with some user accounts.


Some users have different e-mail from alias - for example their e-mail is and their alias is


Now when I do the User().mail what I get is user alias.

When I query SP list for I get e-mail of the person.


It would be good if PowerApps would make distinction between an alias (UPN) and e-mail as this is raising some issues. It would be great if User() function would also return "Claims" like SP list query does, so we could do easy comparison of the values and query SP data based on the current user.

Community Support
Community Support

Hi @PWrobel,


About feature requests or and ideas about PowerApps, please consider to post in below forum where others can vote.



Mona Li

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users


We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (106,343)