Get all User in my Company into a Sharepoint list

[Anonymous]

Hello all,
I need help with the creation of a flow. We already have a license for the Premium Connectors so that would not be a problem.
We would like to create a Get query where we list all internal employees that are imported into a sharepoint list. The sharepoint list is simple with the columns "Firstname", "Lastname" and "Email".

[joe_hannes_col · Accepted solution]

Hello @Anonymous,

You would not even need a Premium Connector for this 🙂

You could use the "Search for users (V2)" action of the Office 365 Users connector. If you leave the search term blank, it will return all the users in your AAD.

If you add an Apply to each on the value of the action, you can fill your SharePoint list with the fields returned by the "Search for users (V2)" action.

The list returned by the action will contain guests and mailboxes too though, so you might want to filter them out first.

[joe_hannes_col]

I'm sorry @Anonymous, my first reply is probably not what you were actually asking for.

If I understand correctly, you want to use Power Automate to set up a process that can be triggered by a GET request and will respond with data about employees saved in a SharePoint list.

You could achieve this by using the "When a HTTP request is received" trigger. You will have to set the "method" to "GET".

In your flow, you can retrieve an array of say employees from your SharePoint list.

Using the "Response" action, you can send a response to the caller of your flow including the desired information:

[moritz0815]

Hello,

I am opening this post again.
When I apply the action "Search for users (V2)" with empty search field, I still get only "[]" as output value.
I have already set Pagniation to 2000.

Maybe someone can tell me what can go wrong here.

[erikregiovvarml]

Hi! Late answer but im also looking at this try set "Is search term required" to no (its under advanced settings). 

[erikregiovvarml]

Im struggling with this though it seems that there is a limit of 999 hits someone know if you can exceed that? 

[EricGrassi]

Same is happening here

[mechilletorres]

Hi, 

In your search for users action, click on the ellipsis and choose Settings, turn the Pagination and input any numbers this will allow you to get everything beyond 999

[rgundes]

Thank you so much @mechilletorres! It worked perfectly and now I have all employees on a sharepoint list.