Pull information from Azure, Teams or Office to create a Sharepoint business directory

Question

I am looking for an option to take user properties information in Azure, Office or Teams that will create a Phonebook listing for internal users in SharePoint. Basic data only (Username, Phone, Email, Department, Role)

Answer 1

Hey Toni

I see several possibilities to achieve this. Some might be:

Option A: Power Automate Flow using Connector "Search for users V2"

Create a Power Automate flow that gets all users through "Search for users V2" connector and write them into a SharePoint list one after the other using the "SharePoint - Create list item" connector.

Office 365 Users - Connectors | Microsoft Learn

Option B: Create Power App and query Company Directory directly

PowerApp that queries and lists Company directory with the "Office 365 Users" connector. Once finished you could deploy the App to Teams through Teams Admin Center. This approach has the advantage that you do not have to have a SharePoint list that is in constant Sync with your AAD since it queries the directory directly.

Connect to Office 365 Users connection from Power Apps - Power Apps | Microsoft Learn

Option C: Power Automate Flow using HTTP Connector and Microsoft Graph API

You could create a Power Automate flow that gets all users through HTTP connector (Premium) and writes them into a SharePoint list one after the other. This approach probably needs an Azure AD App Registration.

List users - Microsoft Graph v1.0 | Microsoft Learn

Option D: Using PowerShell

Alternatively you could also create a PowerShell script that reads out all Company users and writes them into a specific SharePoint list.

Get-AzureADUser (AzureAD) | Microsoft Learn