Get all User in my Company into a Sharepoint list

(0) Share

Report

Posted on by Community Power Pla...

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

All responses (8)

Answers (1)

rgundes 3 on at

Like (0)

Report

Re: Get all User in my Company into a Sharepoint list

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

Like (1)

Report

Re: Get all User in my Company into a Sharepoint list

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

2023-02-06 21_16_...
EricGrassi 2 on at

Like (0)

Report

Re: Get all User in my Company into a Sharepoint list

Same is happening here
erikregiovvarml 37 on at

Like (0)

Report

Re: Get all User in my Company into a Sharepoint list

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

Like (0)

Report

Re: Get all User in my Company into a Sharepoint list

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

Like (0)

Report

Re: Get all User in my Company into a Sharepoint list

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.
joe_hannes_col 1,843 Super User 2024 Season 1 on at

Like (0)

Report

Re: Get all User in my Company into a Sharepoint list

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:
Verified answer

joe_hannes_col 1,843 Super User 2024 Season 1 on at

Like (1)

Report

Re: Get all User in my Company into a Sharepoint list

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.