How to display AAD info

[Anonymous]

I have a requestor form. I'm letting the user select their name in an Lookup field connected to AAD. After the record is saved, I have the view displaying the requestor name and when they click the name it opens another form with the requser name. Unfortunately, it doesn't display anything but the name. I'd like to show the requestor email and business phone. I created a form for the AAD table (inside this project's solution) but that isn't the form that gets displayed when the user opens the requestor. Where or how, should I be doing this?

[FLMike]

Hello,

You want to use the Office365Users connector. You can do a search for the information as such

Office365Users.UserProfile(InfoAbout.Text).City
Office365Users.UserProfile(InfoAbout.Text).CompanyName
Office365Users.UserProfile(InfoAbout.Text).Country
Office365Users.UserProfile(InfoAbout.Text).Department
Office365Users.UserProfile(InfoAbout.Text).DisplayName
Office365Users.UserProfile(InfoAbout.Text).GivenName
Office365Users.UserProfile(InfoAbout.Text).Id
Office365Users.UserProfile(InfoAbout.Text).JobTitle
Office365Users.UserProfile(InfoAbout.Text).Mail
Office365Users.UserProfile(InfoAbout.Text).MailNickname
Office365Users.UserProfile(InfoAbout.Text).mobilePhone
Office365Users.UserProfile(InfoAbout.Text).OfficeLocation
Office365Users.UserProfile(InfoAbout.Text).PostalCode
Office365Users.UserProfile(InfoAbout.Text).Surname
Office365Users.UserProfile(InfoAbout.Text).TelephoneNumber
Office365Users.UserProfile(InfoAbout.Text).UserPrincipalName
Office365Users.UserProfile(InfoAbout.Text).AccountEnabled
Office365Users.UserProfile(InfoAbout.Text).BusinessPhones

Connect to Office 365 Users connection from Power Apps - Power Apps | Microsoft Learn

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[gulshankhurana · Accepted solution]

Hi @Anonymous 

If you are using a model driven app then you'd need to edit the Main form of AAD User to add the mail and business phone number there.

 

 

One you save and publish the form and refresh the app on the front end then this should achieve your objective.

However, I would have done things differently though. I would edit the 'Quick View' form (in the first screenshot above) to include mail and business phone on that form first.

I would then add that quick view form on the table where you have the Requester lookup. 

In my example, I have added the Requester Lookup column (looking up to AAD User table) on the Account form. Underneath the Requester column, I added that quick view form that I edited above.

 

 

Once I save and publish the form, this is how the Account form looks on the front end:

 

and once the AAD User is selected in the Requester column, it automatically comes up with the related details of that AAD User in a read-only quick-view form underneath, thereby making this info readily available for the users so that they don't have to navigate away to AAD User table to look for AAD User's emial or phone number.

 

I hope this information helps. Please give a Thumbs Up to my reply if you appreaciate my efforts. If it helps you with your query then please also accept it as a solution so that it can help others with similar queries.

Thanks.

Kind regards

Gulshan

[danducati]

This has been super helpful, thank you!! Question:

I need to pull email addresses from our MS Entra ID table into my main form. However, I have not been able to do so since it is not the primary column in that table. I then found your solution & it now works perfectly!!

But how can I get that email field added to my main table so the form can be forwarded to that email address for approval? I'm not a developer but hopefully there is an easy way to do it. Thank you!