Hmm, good question. It looks like it's just searching variants of the name from the tooltip (I tried searching Sales in mine too, and it came back blank). You could either: 1. Search to get everything, then use Filter Array to filter on department; or 2. Use the "get direct reports" action instead, and feed it a manager's login name (assuming everyone in the department reports to them)

@@bi-omeI ended up using the first option with a Filter Array and it's working properly. Wanting to give you a video idea since I just did this with my team not too long ago - creating a dynamic approver process through sharepoint and power automate.

@@luigir2459 Awesome! I have been meaning to make a video on approvals, it's on my list for sure. 😄

I think we have over 20,000 employees. If I get all and then filter, I am risking a performance problem? Or since it’s all in the cloud, am I ok? I can’t seem to get the filter array to work right. Where would it be positioned in the order?

@@Romenet310 Worst case MS will throttle the flow - I think your allowed usage depends on the licensing. Pagination supposedly maxes out at 100k but I don’t have a large number of users so I couldn’t test it. If you’re willing, please try it and let me know how it does! If it doesn’t work, the official way to be doing this is to use a scheduled PowerShell script (would require an admin account and local admin access on the machine).

Thanks! Licensing info isn't in the user profile. You can get it with Graph API with an HTTP action, but people typically use PowerShell for that sort of thing--

You would need to do a Graph API call for that, here's the documentation: learn.microsoft.com/en-us/graph/api/user-assignlicense?view=graph-rest-1.0&tabs=http If you want to use Power Automate, it'd be the HTTP connector, but most people get licensing data with PowerShell - there's a slew of PowerShell scripts available for it out there online because that's how most administrators manage licensing at scale.

Yeah, what you'd probably need to do here is use a "parse json" action on your users variable, then for-each loop on the items in it to create an item for each. You'd need to decide how you handle updates to it, otherwise it'll just add all the users every time it runs and you probably don't want duplicates, so it's more complicated than it seems at the outset, particularly if you need to remove individuals that leave on top of that. I'll put "get data from somewhere and put it in a SP list" on my queue. 😀

PA won’t be handling anything with 500k I don’t think - people normally get around size issues with pagination settings or querying in parts, but 500k is too big.😅 PowerShell will probably be your best bet - it’ll let you set ResultSetSize to increase the max size. learn.microsoft.com/en-us/powershell/module/activedirectory/get-adobject?view=windowsserver2022-ps

Yeah, if you get all the emails in an array variable, or even Excel would probably work, you can “apply to each” on those and use “get user profile” instead of the search action and append the outputs to a variable (or add rows to Excel).

@@bi-ome thanks so much!

Thanks! Yes - there is a limit, but I could not seem to find any record of what the return limit actually is in the documentation, what was the number it stopped at for you? The search does not support wildcards and seems to only search from the beginning of the username (for example I searched for "christine" and got results, but nothing with using my domain). Your best bet is probably to try the HTTP Request action in Power Automate and query the Graph API: learn.microsoft.com/en-us/graph/api/user-list?view=graph-rest-1.0&tabs=http

The number, which stopped me was around 100.000. I tried the suggestion 'HTTP Request Action' you made (with UserPrincipialName), but it gives me the 'Error Code: 500', and I think it's because of the administrative permission, which I don't have. But I solved my problem in a different way: I got the UserIDs (about 150) from our internal website and copy them to Excel programmatically. Then I use 'List rows present in a table' in order to read them, appended to array, and then search them in 'Search for Users (V2)' with 'Apply to Each'. Finally I got them with their departments, which I later use in my Power BI Dashboard. Thanks again! Your video about Search for Users saved me and showed me the Power of 'Power Automate' !!!