cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Office365Users.SearchUser() Search by location/department/jobtitle

if I use  Office365Users.SearchUser({searchTerm:TextInput1.Text,top:500}) , it will only search by user name. Is there a way to search all other fields as well.

e.g. If type in Marketing in the textinput field, the gallery will return everyone from marketing department.

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Office365Users.SearchUser() Search by location/department/jobtitle

Hi @agent3154,

 

According to https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-office365-users:

SearchUser

Search for users: Retrieves search results of user profiles

Input properties

Name Data Type Required Description
searchTerm string no Search string. Applies to: display name, given name, surname, mail, mail nickname, and user principal name

Output properties

Property Name Type Description
Department string Department of the user.
DisplayName string Display name of user.
GivenName string Given name of user.
Id string User id
JobTitle string Job Title of the user.
Mail string Email id of user.
MailNickname string Nickname of user.
Surname string Surname of user.
TelephoneNumber string Telephone number of user.
UserPrincipalName string User Principal Name.
AccountEnabled boolean Account enabled flag.

 

But in my App, I had a connection to Office 365 Users, and I inserted a Text box and set its Text property to show information about current user, for example: Office365Users.MyProfile().DisplayName, it worked well and user DisplayName was shown. When I set its Text property to show user Department, I got the same issue with you, no error message and no user Department information was shown. And I also tried to show information about another user, I can also get information about DisplayName, ID, etc. but I can’t get Department information.

 

It is a limitation of the connector. The Microsoft Graph API supports filtering on department, but it is not exposed by the connector. We are currently working on a fix. 

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate I
Advocate I

Re: Office365Users.SearchUser() Search by location/department/jobtitle

I'm looking for a similar solution.  I'm looking to generate gallaries of all employees of a specific JobTitle, Department, or Location.

Highlighted
Advocate II
Advocate II

Re: Office365Users.SearchUser() Search by location/department/jobtitle

In this Casse the Office365Users.SearchUser() Connector is not reliable in Tenants with more then 999 Users, because the filter on JobTitle, Department or Location is established after the top:999 User Limit. No Pagination in Batches possible with this Connector. So the filters on JobTitle, Department or Location are not delegable. Suboptimal Connector Design.... 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

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