Search by Job Title?

[ericonline]

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?

[RobElliott]

@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.

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]

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

[v-bacao-msft]

Hi @ericonline ,

Maybe you can try the following configuration:

Best Regards,

[ericonline]

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]

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']`

[ericonline]

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

[ericonline]

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~!

@Anonymous 

[Jcook]

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

[ericonline]

@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 🙂

[ericonline]

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

[Anonymous]

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 😉 

[A-IT]

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.

[RBMN187]

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