web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Show an employee's wor...
Power Apps
Answered

Show an employee's workspace using Office 365

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello, how do you want to know if this is possible in powerapps using Office 365 users?
what happens is that I have a combobox and in the items event I have the following formula

Office365 Users.SearchUser ({searchTerm: cbres.SearchText; top: 10}). DisplayName

 

 

This formula allows the user to enter the name of the employee they want to search for and filter it, but I want that when the user clicks on the combobox below in a text box, it shows where the employee works, not the name of the company, show your work area for example, accounting, management, marketing

 

captrue.PNG

If this is possible, how could I do it so that the texbox will show me this information?   , Many many Thanks 😄

 

Categories:
  • Verified answer
    v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous :

    Could you please tell me what "workspace" is ? Where can I find it?

    I assume workspace is "OfficeLocation".If so,you could try:

    Set the combo box's Items property to:

    Office365 Users.SearchUser ({searchTerm: cbres.SearchText; top: 10})

    Set the label's Text property to:

    YourCombobox.Selected.OfficeLocation

    Best Regards,

    Bof

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @v-bofeng-msft  

    What if forgive me is that I did not know the name of the field but thanks to your formula I was able to show it in the text label, thank you very much, the field I needed was that of the department, but I could already solve it
    at the end I chose to use:


    Office365 Users.SearchUserV2 ({searchTerm: cbresponsable.SearchText}). Value

     

    in the search fields property I put ["DisplayName"]

    and already on the label put:


    cbresponsable.Selected.Department (as you indicated it to me a thousand thanks for trying to help me)

     

    y ya en la etiqueta coloque
    cbresponsable.Selected.Department (como me lo indicaste mil gracias por intentar ayudarme)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 397 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 354

#3
WarrenBelz Profile Picture

WarrenBelz 232 Most Valuable Professional

Last 30 days Overall leaderboard