cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cooper01
Continued Contributor
Continued Contributor

Get current user UPN without O365 Users connector?

My goal is to get the current user's row from the Dataverse system Users table in my canvas app. I want to get this row on user name/UPN, not email. I can get the current user's UPN using the O365 User's Connector, but I don't have any other use for that connector within the apps so wondering if there is any other way to get the UPN value? I am familiar with User() but this only returns email.

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User III
Dual Super User III

If the UPN is different in your organization from the email then your only real choice is to either use the Office365users connection or access AzureAD through something like the SystemUsers table in Dataverse.  Office365Users is a standard connection, anything else will require a premium license and/or elevated priveledges.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

3 REPLIES 3
Pstork1
Dual Super User III
Dual Super User III

In most organizations email and UPN are the same value.  Have you verified that this is not true for your tenant?



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cooper01
Continued Contributor
Continued Contributor

Yes, they are usually the same but not always.

Pstork1
Dual Super User III
Dual Super User III

If the UPN is different in your organization from the email then your only real choice is to either use the Office365users connection or access AzureAD through something like the SystemUsers table in Dataverse.  Office365Users is a standard connection, anything else will require a premium license and/or elevated priveledges.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,637)