Microsoft Lystavlen - the Online display board

Lystavlen is the danish word for 'the display board'. This blog is all about sharing the beauty of Microsoft Online Services

Quick Tip: How to list all user profiles in SharePoint Online

Quick Tip: How to list all user profiles in SharePoint Online

  • Comments 11
  • Likes

To list the user profiles of all SharePoint Online users in your tenant you can follow these steps

  1. Navigate to the User Profiles tab in the SharePoint Administration Center and click Manage User Profiles


  2. In the "Find profiles" text box type i:0#.f|membership

  3. Click the Find button to see the list of all user profiles



  • Currently there is no way to list external users (PALs)
  • In case you wonder - the "f" in the search string means we are using forms based authentication
  • Great post! thanks.

  • Cool..tip of the day :) Thanks for sharing..

  • Cool but how to export this list?

  • How would a user (non-admin) find a list of all users?

  • Nice tip, thanks.

    Is there any way you can get pass the 50 user limit in the query?

  • a non-admin user can search People and contentclass=SPSPeople since all non-anonymous external users are associated with Microsoft account.

  • Great tip thanks

  • Have had a ticket open for days with MS on how to do just this!
    Just need to export this as a csv and work out how to make it only have current users

    The issue I have is when a user leaves there profile stay and HR complain as they then still show in the org charts

    Deleting the profile on SPO will have to be an additional step in the leavers process :(
    I don't like manual processes

  • Great tip.. My list cuts off at 50. How can I get the full list?

    Your search returned too many results. Only the first 50 results are shown on this page

  • Hi,
    How to get all the user profiles using CSOM?

  • Thank you! I was searching for this since long

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment