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
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 tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (2,544)