cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ericonline
Community Champion
Community Champion

Search by Job Title?

Hello,

I need to search our entire org by Job Title. 

Example: Show all people within my org with "Project Manager" in their Job Title. I found a way to do this in PowerApps but the search is limited to only 999 people. I need a way to query the entire AD of an org. 

Thoughts?

13 REPLIES 13
RobElliott
Super User
Super User

@ericonline have you considered using Filter which can be delegated so can deal with larger data sets than 999 items? We use the search slightly differently in that we import the spreadsheet of muti-thousand items into the app but it might be a function that could work for you.

filter.png

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

 

Jcook
Super User
Super User

Hello,

If you did want to use flow,

You can use the Office 365 Users connector and
Use Search for users action.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others



Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





v-bacao-msft
Community Support
Community Support

 

Hi @ericonline ,

 

Maybe you can try the following configuration:

124.PNG

 

Best Regards,

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

Hi @RobElliott ,

I need to use the O365Users connector to perform the search. I need to search our Active Directory for people with JobTitle "XYZ". Basically, need to create the "Table1" in your example 🙂

ericonline
Community Champion
Community Champion

Hi @Jcook , 

Unfortunately, just like the O365SearchUsers Connector in PowerApps is limited to 999 results, so too is the Flow O365SearchUsers Action. Passing it a blank parameter limits out at 999 as shown below. 

Where: "COUNT profiles" is `length(body(GET_o365_profiles)?['value']`

image.png

Hi @v-bacao-msft ,

Unfortunately, only 999 records max are returned. I have 50k + in my org. How do I up this number?

Thank you

The ideal solution would be to include "JobTitle" as a search parameter. We already have "Name", "UPN", "MailNickname", etc.

Just add JobTitle AND the ability to up the number of responses to 100k and we're all good~!

image.png

@Anonymous 

Hi @ericonline

Try settings a threshold limit on the action.

This can be done by clicking the 3 dots on the search users action and clicking settings.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





ericonline
Community Champion
Community Champion

@Jcook ,

Yep, i'm on the same track. I entered "50000" for the "Top" field, then turned on Pagination with a 50000 threshold. 

It took 8 mins to run with 999 records. Might be awhile (4.1667 hours) before I reply with the results 🙂

Fingers crossed! It appears to be working, but the Flow isn't finished running yet...

image.png

Anonymous
Not applicable

What input do you have? Do you have excel file or something?

 

If yes you can list a rows in the table, make a condition and put it to another file. You generally can do it even only at excel 😉 

Would you be able to show me your full flow so I can see how you used the Job Title for the search? I'm in a similar situation where I need to pull user names from this list.

@ericonlineit would be awesome if you could share this flow with the rest of the community!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (1,329)