Unanswered

Why does user().Email return email in a different format from a list of people?

(0) Share

Report

Posted on by ralphtrickey

User.Email returns my network login in the format xy1234@company.org and a Sharepoint List of people has it in the format first.last@company.org.

This makes it impossible to check if the current user is part of an 'Admin' list 100%.

I'm switching to see if comparing Displayas and Fullname will work.

Thanks,

Ralph

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

v-monli-msft on at

Like (0)

Report

Hi @ralphtrickey,

The information returned by User() function is for the current PowerApps user. It will match the "Account" information that is displayed in the PowerApps players and studio, which can be found outside of any authored apps. This may not match the current user's information in Office 365 or other services including SharePoint user profiles. For your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-user

Regards,

Mona

Was this reply helpful? Yes No
ralphtrickey 54 on at

Like (2)

Report

Sorry, that wasn't really a question.

I understand that there are technical reasons for the emails differing, but to the developer, this is a very clear bug, no matter how you may try to explain why it's happening unless you can suggest a configuration change that would make them align.

If Sharepoint and Powerapps were from different companies, I would accept it and move on. That isn't the case here.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

This issue is not solved. user().email and [metadata type people].email does not return the same value.
In PowerAps it is then impossible to check of filter based on this information. And except the full name there is no other alternative (no unique ID).

Was this reply helpful? Yes No
AngryBatVoice 203 on at

Like (1)

Report

Here's a recent video discussing this issue:
PowerApps User() function & Office 365 Users (2019)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you for this valuable information !
In fact my application was working... execpt for some users... Those have a blank in their family name that is one time replaced by a . (in email) and another time ignored (login). So matching was not working for them.

1 people found this reply helpful.

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Its not a bug. It happens when your AD admins decide to have an email address that doesn't match the user's User Principal Name (UPN). By default AD makes these the same, but some organizations decide they want to differentiate between them. That is a decision made by your IT staff, not a flaw in the product.

Was this reply helpful? Yes No