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.
@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.
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.
Hi @ericonline ,
Maybe you can try the following configuration:
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 🙂
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']`
Hi @v-bacao-msft ,
Unfortunately, only 999 records max are returned. I have 50k + in my org. How do I up this number?
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~!
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 🙂
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!