Skip to main content

Notifications

Community site session details

Community site session details

Session Id : rBK+ieLoFfq+IzaEKwSu3g
Power Apps - Power Apps Governance and Administ...
Answered

Get all User in my Company into a Sharepoint list

Like (0) ShareShare
ReportReport
Posted on 29 Jun 2021 07:07:09 by

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

  • rgundes Profile Picture
    3 on 15 Mar 2024 at 21:46:17
    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 Profile Picture
    38 on 06 Feb 2023 at 13:17:20
    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

  • EricGrassi Profile Picture
    2 on 01 Feb 2023 at 15:07:59
    Re: Get all User in my Company into a Sharepoint list

    Same is happening here

  • erikregiovvarml Profile Picture
    37 on 12 Jan 2023 at 10:32:25
    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 Profile Picture
    37 on 12 Jan 2023 at 10:31:26
    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 Profile Picture
    201 on 12 Oct 2022 at 06:46:19
    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 Profile Picture
    1,843 Super User 2024 Season 1 on 30 Jun 2021 at 07:32:04
    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:

    joe_hannes_col_1-1625038317558.png

     

  • Verified answer
    joe_hannes_col Profile Picture
    1,843 Super User 2024 Season 1 on 30 Jun 2021 at 07:23:46
    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.

    joe_hannes_col_0-1625037861703.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Power Apps Governance and Administering

#1
Vince_K Profile Picture

Vince_K 2

#1
getsplash Profile Picture

getsplash 2

#1
BCBuizer Profile Picture

BCBuizer 2 Super User 2025 Season 1

Overall leaderboard

Featured topics