Display Office 365 User Profile Details in Power Apps

A few days ago, a client asked how to display Office 365 user profile details directly within their Power Apps app. They wanted the app to automatically display information like the user’s name, email, and job title without manual input.

To achieve this, we connected Power Apps to the Office 365 Users connector, allowing the app to pull real-time profile data for the logged-in user and display it on the Power Apps screen.

In this article, I will explain how to display Office 365 user profile details in Power Apps.

Display Office 365 User Profile Details in Power Apps

The image below shows how all the Office 365 user information (Name, Email, Phone, etc.) appears on the Power Apps screen.

So let’s get started!

Connect the Office 365 User Connector

In Power Apps, a connector called Office 365 Users helps you see user profiles in your organization using your Office 365 account. You can view your own profile, check someone else’s profile, or find a user’s manager and team members.

Go to the Data tab, click + Add data, search for Office 365 Users, and select the Office 365 Users connector, as shown below.

Office 365 Users in Power Apps

Next, insert 10 Labels for names (left side) and add 10 labels to view the results. Also, add an Image control at the top left corner to view the user’s profile picture. Now let’s discuss one by one:

Power Apps Office 365 User Profile Picture

To display the Office 365 user profile photo, select the image control and set its Image property as:

Office365Users.UserPhotoV2(User().Email)

Or

Office365Users.UserPhoto(User().Email)

Or

Office365Users.UserPhotoV2(Office365Users.MyProfileV2().userPrincipalName)

You can use any of the above codes.

NOTE:

Office365Users.UserProfile returns basic user info like name, email, and job title in Power Apps.

Office365Users.UserProfileV2 provides more detailed info, including extra properties like office location, state, preferred language, etc. in Power Apps.

It will display the image/photo of the current user from the Office 365 account.

Power Apps Office 365 User Display Name

To get the current user’s display name from the Office 365 account, apply the code below to the Label’s Text property:

Office365Users.UserProfileV2(User().Email).displayName

 Or

Office365Users.UserProfile(User().Email).DisplayName

It will display the display name of the current user from the Office 365 account.

Power Apps Office 365 User Email

To retrieve the current user’s Email from the Office 365 account, apply the code below to the Label’s Text property:

Office365Users.UserProfileV2(User().Email).mail

Or

Office365Users.UserProfile(User().Email).Mail

It will display the current user’s email address from the Office 365 account.

Power Apps Office 365 User Phone

To get the current user’s mobile phone number from an Office 365 account, set the code below to the Label’s Text property:

Office365Users.UserProfileV2(User().Email).mobilePhone

Or

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

It will display the mobile phone number of the current user from the Office 365 account.

Power Apps Office 365 User Company Name

To get the current user’s company name from an Office 365 account, set the code below to the Label’s Text property:

Office365Users.UserProfileV2(User().Email).companyName

Or

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

It will display the company name of the current user from the Office 365 account.

Power Apps Office 365 User Department

To display the current user’s department from an Office 365 account, set the code below to the Label’s Text property:

Office365Users.UserProfileV2(User().Email).department

Or

Office365Users.UserProfile(User().Email).Department

It will display the current user’s department from the Office 365 account.

Power Apps Office 365 User Job Title

To display the current user’s job title or designation from an Office 365 account, set the code below to the Label’s Text property:

Office365Users.UserProfileV2(User().Email).jobTitle

Or

Office365Users.UserProfile(User().Email).JobTitle

It will display the job title of the current user from the Office 365 account.

Power Apps Office 365 User City

To show the current user’s city from an Office 365 account, set the code below to the Label’s Text property:

Office365Users.UserProfileV2(User().Email).city

Or

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

It will display the city of the current user from the Office 365 account.

Power Apps Office 365 User State

To retrieve the current user’s state from an Office 365 account, set the code below to the Label’s Text property:

Office365Users.UserProfileV2(User().Email).state

It will display the current user’s state from the Office 365 account.

Power Apps Office 365 User Country

To get the current user’s country from an Office 365 account, set the code below to the Label’s Text property:

Office365Users.UserProfileV2(User().Email).country

Or

Office365Users.UserProfile(User().Email).Country

It will display the current user’s country from the Office 365 account.

Power Apps Office 365 User ID

To display the current user’s ID from an Office 365 account, set the code below to the Label’s Text property:

Office365Users.UserProfileV2(User().Email).id

Or

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

It will display the current user’s ID from the Office 365 account.

Here are a few more formulas for additional Power Apps user profile information from the Office 365 account.

Office365Users.UserProfileV2(User().Email).givenName
Office365Users.UserProfileV2(User().Email).surname
Office365Users.UserProfileV2(User().Email).mailNickname
Office365Users.UserProfileV2(User().Email).userType
Office365Users.UserProfile(User().Email).BusinessPhones
Office365Users.UserProfileV2(User().Email).userPrincipalName
Office365Users.UserProfileV2(User().Email).officeLocation
Office365Users.UserProfileV2(User().Email).postalCode
Office365Users.UserProfileV2(User().Email).preferredLanguage
Office365Users.UserProfileV2(User().Email).aboutMe
Office365Users.UserProfileV2(User().Email).streetAddress
Office365Users.UserProfileV2(User().Email).accountEnabled

This way, we can get and display all the Office 365 User profile information in Power Apps. Also, you may like some more Power Apps articles:

• Create a Custom Calendar in Power Apps
• Filter SharePoint List Items in Power Apps
• Power Apps Container Control
• Power Apps Create Custom Progress Bar Using SharePoint Choice Values
• Create Login Page in Power Apps Using SharePoint
• Submit Data From Power Apps to Excel

Preeti Sahu

Preeti Sahu is an expert in Power Apps and has over six years of experience working with SharePoint Online and the Power Platform. She is the co-author of Microsoft Power Platform: A Deep Dive book. As a Power Platform developer, she has worked on developing various tools using Power Apps and Power Automate. She also makes Microsoft 365 videos and shares them on YouTube.