Display Office 365 User Profile Properties in PowerApps

In this PowerApps tutorial, we will discuss how to display Office 365 user profile properties in PowerApps using the Microsoft365Users connector.

Display Office 365 User Profile Properties in PowerApps

So before going to start, you have to connect your PowerApps App with Microsoft365Users connector.

You can create a PowerApps canvas app (Tablet layout or Phone layout).

Go to the Data and search Microsoft365Users and try to connect it. Once the connection gets success you can see like below:

Display Office 365 User Profile Properties in PowerApps

Next, I have added two screens here. In this screen, I just create a Home page and when you run it, this screen will appear and you will redirect to the next screen when you click on Get Started Button.

Microsoft365Users connector

Here I have added Labels and Image control to bind the data which will retrieve from the user profile.

Now everything you will get from Micrisoft365Users.UserProfile(userID) formula.

PowerApps Microsoft365Users connector

The same steps you can follow for other controls as well. Here I bind Email id in the label control. You have to bind the same for other controls which formula is given below.

Display user profile properties powerapps

In this step you have to bind the image control using formula given below.

Display email user profile properties powerapps

Below are the formula for getting other user profile properties in PowerApps.

Microsoft365Users.UserProfile(User().Email).TelephoneNumber

Microsoft365Users.UserProfile(User().Email).OfficeLocation

Microsoft365Users.UserProfile(User().Email).Department

Microsoft365Users.UserProfile(User().Email).JobTitle

Microsoft365Users.UserProfile(User().Email).Country

Microsoft365Users.UserProfile(User().Email).DisplayName

Microsoft365Users.UserProfile(User().Email).Mail

Office365Users.UserProfile(User().Email).City

Office365Users.UserProfile(User().Email).CompanyName

Office365Users.UserProfile(User().Email).GivenName

Office365Users.UserProfile(User().Email).Id

Office365Users.UserProfile(User().Email).MailNickname

Office365Users.UserProfile(User().Email).mobilePhone

Office365Users.UserProfile(User().Email).PostalCode

Office365Users.UserProfile(User().Email).Surname

Office365Users.UserProfile(User().Email).UserPrincipalName222

Office365Users.UserProfile(User().Email).AccountEnabled

Office365Users.UserProfile(User().Email).BusinessPhones
image 219

You may like following PowerApps tutorials:

In this PowerApps tutorial, we discussed how to get user profile properties in PowerApps Canvas App. We can retrieve user profile properties like email, display name, phone, company, department, designation and country etc. in PowerApps.

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

Get update on Webinars, video tutorials, training courses etc.

Rajkiran Swain

Rajkiran is currently working as a SharePoint Consultant in India . Rajkiran having 7+ years of experience in Microsoft Technologies such as SharePoint 2019/2016/2013/2010, MOSS 2007,WSS 3.0, Migration, Asp.Net, C#.Net, Sql Server, Ajax, jQuery etc.He is C#Corner MVP (2 Times).

>