Forum Discussion

Navid2132's avatar
Navid2132
Copper Contributor
Sep 28, 2021

How to import all office 365 users in a sharepoint list

Hi everyone my question is I want to create a Sharepoint list and import automatically all Office 365 users info like Name Last Name Department Email etc. in a SharePoint list is it possible 

    • ganeshsanap's avatar
      ganeshsanap
      MVP

      Nivedhana Navid2132 

      You can use Power automate flow for these requirements. Follow steps:

      1. Create a power automate flow > manually triggered flow if this is a one time activity Or scheduled flow to run it regularly.
      2. Get all users from AAD tenant using List Users action
      3. Use apply to each action to iterate through all results from list users action 
      4. Inside apply to each action, create new item in SharePoint list using Create item action based on data returned from step 2

      Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

      For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

      • Lijun_Chen's avatar
        Lijun_Chen
        Copper Contributor
        Hi ganeshsanap,

        I am also trying to get a full list of users of my organization in Sharepoint List. Can you provide more detailed specific instructions on how to do this?

Resources