cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
NigelP
Level 8

PowerApps and Alias Email Addresses

Hi

I have a strange issue.

I have a user that has an Alias Email address.

I am using SHarePoint lists to hold records.

When I save a record the Login username is saved which seems to have the Alias email address associated with it and when I get the email address using User().Email it is a different email address.

IS there a way I can get all of the email addresses for a user or a way of getting a consistent email address for a user ?

As a last resort, can I do a LookUp using the User's Username rather than the email address ?

 

Thanks

 

Nigel

1 ACCEPTED SOLUTION

Accepted Solutions
NigelP
Level 8

Re: PowerApps and Alias Email Addresses

Hi @iAm_ManCat 

 

You were right the UPN was different from the email address.  Although it only happened in one of many countries.  The work around was to run the query with the email address and if that returned no results, then repeat the query using the UPN.

 

This seemed to fix the issue.

 

Regards

 

Nigel

View solution in original post

3 REPLIES 3
Super User
Super User

Re: PowerApps and Alias Email Addresses

Just a hunch here, but does their Primary SMTP address match their UPN?

I would think if not using single-sign-on then you could have different Primary SMTP and UPN, which could cause this.

 

User logs in with their UPN, but a check with User().Email would likely look at their Primary SMTP address.

 

If this is the case, you could get the user to have the alias as a secondary email alias and then set their primary SMTP to match their UPN which would result in consistent email address values.




Don't forget to 'Mark as Solution' if a post answered your question and always 'Thumbs Up' the posts you like or helped you!
NigelP
Level 8

Re: PowerApps and Alias Email Addresses

Hi @iAm_ManCat 

 

I will see if IT will let us do that.

 

Thanks

 

Nigel

NigelP
Level 8

Re: PowerApps and Alias Email Addresses

Hi @iAm_ManCat 

 

You were right the UPN was different from the email address.  Although it only happened in one of many countries.  The work around was to run the query with the email address and if that returned no results, then repeat the query using the UPN.

 

This seemed to fix the issue.

 

Regards

 

Nigel

View solution in original post

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,085)