Showing results for 
Search instead for 
Did you mean: 
New Member

Search for Users by Department

I simply want to search for users that belong to a specific department.  I feel like I'm missing something simple.  Is this possible?



Dual Super User II
Dual Super User II

Re: Search for Users by Department

There is no easy way to retrieve users based on the department listed in their profile.  Two possible workarounds

  1. If you don't have a large number of total users you can just search for users with a blank search query and then filter the results on the client using a Filter Array based on the department value returned.
  2. If the department has a specific manager you could use the Get direct reports for that manager and get all the users in the department.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources


August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!


Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (4,759)