How to import all office 365 users in a sharepoint list

Copper Contributor

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 

3 Replies

@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

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?