Display Office 365 User Profile Details in Power Apps

Leveraging the Office 365 Users Connector in Power Apps

Power Apps empowers organizations to build sophisticated business applications that integrate directly with Microsoft 365 services. A frequent requirement is displaying information about the currently logged-in user, such as their name, email, department, job title, manager, phone number, and profile photo. Fortunately, the Office 365 Users connector simplifies this process, allowing Power Apps to retrieve user profile data directly from Microsoft 365 and Azure Active Directory without the need for custom APIs.

This connector is a powerful tool that supports fetching not only basic profile information but also details about a user's managers and direct reports, as well as their profile photos.

Why Display User Profile Information in Power Apps?

Integrating user profile data offers several key benefits:

• Personalize Applications: Tailor the user experience based on individual user data.
• Reduce Manual Data Entry: Automate the population of user-specific fields.
• Improve User Experience: Provide users with relevant, readily available information.
• Automate Approval Processes: Automatically route approvals based on an employee's manager.
• Create Employee Directories: Build internal directories with comprehensive contact information.
• Support Role-Based Applications: Dynamically adjust application features based on user roles and departments.

Understanding the Office 365 Users Connector

The Office 365 Users connector provides direct access to user profile information stored within Microsoft 365. It allows you to retrieve a variety of attributes, including:

• Display Name
• Email Address
• Job Title
• Department
• Manager
• Phone Number
• Direct Reports
• User Photo

This connector is readily available within Power Apps, Power Automate, Logic Apps, and other Microsoft services.

Step-by-Step Guide to Displaying User Information

Step 1: Add the Office 365 Users Connector

Begin by opening your Power Apps canvas app. Navigate to the Data pane and select 'Add data'. Search for and choose the 'Office 365 Users' connector. You will be prompted to connect using your Microsoft 365 account. Once connected, your Power App can access profile information from your organization's directory.

Step 2: Display Current User Information

To display basic information about the logged-in user, you can use the following Power Fx functions:

• User Name: User().FullName
• User Email: User().Email

These functions are built-in and provide immediate access to the current user's credentials.

Step 3: Retrieve Extended Profile Details

For more detailed profile attributes, you'll utilize the Office 365 Users connector. Here are some common examples:

• Display Name: Office365Users.MyProfile().DisplayName
• Department: Office365Users.MyProfile().Department
• Job Title: Office365Users.MyProfile().JobTitle
• Email Address: Office365Users.MyProfile().Mail

These attributes can be directly bound to label controls or form fields within your Power App.

Step 4: Display User Profile Photo

To showcase the user's profile picture:

1. Insert an Image control onto your canvas.
2. Set its Image property to the following formula: Office365Users.UserPhotoV2(User().Email)

This will display the logged-in user's Microsoft 365 profile photo.

Step 5: Display Manager Information

Many approval workflows require identifying a user's manager. The connector makes this straightforward:

• Manager Name: Office365Users.Manager(User().Email).DisplayName
• Manager Email: Office365Users.Manager(User().Email).Mail

This allows for seamless integration of manager details directly from Microsoft 365.

Step 6: Display Phone Number

To display the user's phone number, you have a couple of options:

• Direct Mobile Phone: Office365Users.MyProfile().MobilePhone
• Business Phones (first entry):

  First( Office365Users.UserProfileV2( User().Email ).businessPhones ).Value

This information can be valuable for contact details within employee-focused applications.

Example: Employee Profile Screen Layout

Consider designing an employee profile screen. A typical layout might include:

• Profile Photo: Using an Image control bound to Office365Users.UserPhotoV2(User().Email).
• Employee Name: A Label control displaying Office365Users.MyProfile().DisplayName.
• Job Title: A Label control displaying Office365Users.MyProfile().JobTitle.
• Department: A Label control displaying Office365Users.MyProfile().Department.
• Manager: A Label control displaying Office365Users.Manager(User().Email).DisplayName.
• Contact Information: Labels displaying email and phone numbers.

This structure can create a professional and informative employee profile card within Power Apps.

Performance Optimization: Caching User Data

To enhance performance and reduce the number of connector calls, it's best practice to retrieve and store user profile information once when the app starts. Use the App.OnStart property for this:

Set(
    varUserProfile,
    Office365Users.MyProfileV2()
);

Then, reference this variable throughout your app:

• varUserProfile.DisplayName
• varUserProfile.Department
• varUserProfile.JobTitle

This approach significantly improves performance by minimizing redundant API calls.

Real-World Use Cases

The Office 365 Users connector is versatile and applicable in numerous scenarios:

• Employee Directory: Display comprehensive employee information and contact details.
• Approval Applications: Automatically determine manager information for routing approvals.
• Help Desk Solutions: Quickly identify requestors and relevant support teams.
• HR Applications: Present employee profiles, departmental structures, and contact information.
• Visitor Management: Automatically populate employee contact information for visitors.

Best Practices

To maximize the effectiveness and efficiency of using the Office 365 Users connector:

• Use MyProfileV2: Prefer V2 functions (like MyProfileV2 and UserPhotoV2) when available for potentially richer data or improved performance.
• Cache Profile Information: Store user profile data in variables (e.g., using App.OnStart) rather than repeatedly calling the connector.
• Handle Missing Photos: Implement logic to display placeholder images if a user's profile photo is unavailable.
• Avoid Excessive Connector Calls: Retrieve profile data once during app initialization.
• Utilize Manager Information for Approvals: Leverage the manager hierarchy for automated approval routing.

Benefits Recap

Leveraging the Office 365 Users connector offers significant advantages:

• Personalized Applications: Automatically display relevant user information.
• Improved User Experience: Reduce manual data entry and streamline workflows.
• Faster Development: Utilize existing Microsoft 365 profile data, saving development time.
• Better Automation: Integrate manager and department information into workflows and approvals.
• Centralized User Data: Consistently retrieve profile information directly from the authoritative source in Microsoft 365.

Conclusion

The Office 365 Users connector is an invaluable asset for Power Apps developers. By seamlessly integrating employee profile information—names, emails, departments, managers, and photos—directly from Microsoft 365, organizations can build more personalized, efficient, and user-friendly applications. This not only enhances the user experience but also significantly reduces manual effort and speeds up development cycles.