cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
alex5p
Level: Powered On

Using AD to pull user's email

I am currently using a dropdown menu connected to an AD group that contains people. This particular group has people that aren't part of the company. We have their email addresses saved in AD. How would I go about getting their email address. Not their email address at our company. 

 

Example.

my company is named ABC so emails are Cindy@abc.com

this lady named Cindy works at DEF so her email is cindy@DEF.com

 

Cindy does have a email at ABC which is cindy@ABC.com but I need powerapps to pull the cindy@DEF.com.

 

There is a spot in AD that asks for contact information of users and there is an email spot that has cindy@DEF.com. Don't know how I would grab it from there. Currently I am using 

investmentsName.Selected.mail

and that grabs cindy@ABC.com 

 

I basically need her REAL email so I can use it in flows to send an email off a certain condition.

1 ACCEPTED SOLUTION

Accepted Solutions
v-siky-msft
Level 10

Re: Using AD to pull user's email

Hi @alex5p ,

 

Azure AD connector can only get the SMTP address for users.

If you want to get another domain email, you can use Substitute() function to replace the @ABC to @DEF.

Please try this:

Substitute(investmentsName.Selected.mail, "@ABC","@DEF")

Best regards,

Sik

View solution in original post

3 REPLIES 3
SKH19
Level 10

Re: Using AD to pull user's email

I'm not sure where the other email address is being stored in Azure AD. I don't see an additional email field in Contact Info:

Annotation 2019-12-09 160246.png

 

 

alex5p
Level: Powered On

Re: Using AD to pull user's email

@SKH19 if you go to the active directory users and computers there is a space for email. i think it's labeled as a contact maybe?

v-siky-msft
Level 10

Re: Using AD to pull user's email

Hi @alex5p ,

 

Azure AD connector can only get the SMTP address for users.

If you want to get another domain email, you can use Substitute() function to replace the @ABC to @DEF.

Please try this:

Substitute(investmentsName.Selected.mail, "@ABC","@DEF")

Best regards,

Sik

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 Kudoed Authors (Last 30 Days)
Users online (3,991)