Unanswered

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

Categories:

Governance & administering

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

joe_hannes_col 1,843 Super User 2024 Season 1 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
joe_hannes_col 1,843 Super User 2024 Season 1 on at

Like (0)

Report

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:

Was this reply helpful? Yes No
moritz0815 201 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
erikregiovvarml 37 on at

Like (0)

Report

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

Was this reply helpful? Yes No
erikregiovvarml 37 on at

Like (0)

Report

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

Was this reply helpful? Yes No
EricGrassi 2 on at

Like (0)

Report

Same is happening here

Was this reply helpful? Yes No
mechilletorres 38 on at

Like (1)

Report

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

Was this reply helpful? Yes No
rgundes 3 on at

Like (0)

Report

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

Was this reply helpful? Yes No