Unanswered

Sync to azureAd to sharepoint directory

(0) Share

Report

Posted on by CU27021323-0

We have a cloud environment and need to create a flow that synchronizes with Azure AD to update a company directory in SharePoint. Despite extensive searching, there appears to be very limited information available on this technique.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

SwatiSTW 741 Super User 2025 Season 2 on at

Like (1)

Report
You want to sync Azure AD users to a SharePoint list to keep a company directory up to date, but there’s not much clear info available. Here's a simple way to do it using Power Automate and Azure AD connector.

create a SharePoint list called "Company Directory" with columns
Title (text)
Email (text)
Job Title (text)
Department (text)
Office Location (text)
UserPrincipalName (text)

go to Power Automate and create a new flow with trigger "Recurrence"
set interval as per need (daily or weekly)

add action "Azure AD - Get users"
leave fields empty to get all users
go to settings of this action > turn on Pagination > set threshold to 1000

add "Apply to each" loop for value from Get users

inside loop add action "Get items (SharePoint)"
Site Address = your site
List Name = Company Directory
Filter Query =
UserPrincipalName eq '@{items('Apply_to_each')?['userPrincipalName']}'
Top Count = 1

add condition
expression =
length(body('Get_items')?['value']) > 0

if true (user exists), add action "Update item"
ID =
body('Get_items')?['value']?[0]?['ID']
update fields with values from Azure AD like
Title = displayName
Email = mail
Job Title = jobTitle
Department = department
Office Location = officeLocation
UserPrincipalName = userPrincipalName

if false (user not found), add action "Create item"
fill all SharePoint fields with Azure AD user values

flow is ready, save and test

Was this reply helpful? Yes No
CU27021323-0 4 on at

Like (0)

Report

Hi SwatisSTW, I created the flow base on your information provided, I do not see it add the new people already in the azureAD. is running succeedful.

Was this reply helpful? Yes No