cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Show an employee's workspace using Office 365

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 😄

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

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

View solution in original post

2 REPLIES 2
v-bofeng-msft
Community Support
Community Support

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

Anonymous
Not applicable

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)

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,184)