How to make dynamic group member that synchronize with sharepoint list

Prita Dewi 20 Reputation points
2024-02-20T07:18:36.21+00:00

Hi. I want to make a group on Azure AD, but the members are dynamic based on Sharepoint list. Do anybody know how to setting the Azure AD group with this scenario? Thank you.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,028 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,160 questions
SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
545 questions
0 comments No comments
{count} votes

Accepted answer
  1. Debarchan Sarkar - MSFT 1,126 Reputation points Microsoft Employee
    2024-02-21T01:36:21.8733333+00:00

    Yes, you can create dynamic group memberships in Azure Active Directory (Azure AD). Here's a step-by-step guide on how to do this: Start by signing into the Azure portal. In the left-hand navigation pane, select the Azure Active Directory service, and then select Groups. Select New Group, choose the Group Type as Security. Provide a name and description for the new group — say, "SharePoint Users". For Membership type, choose Dynamic User. In the Dynamic membership rules section, you need to write a query that represents your SharePoint list members. Unfortunately, Azure AD doesn't support natively fetching users from a SharePoint list. You must have some common attribute among all users who are part of your SharePoint list. This could be job title, department, user location, or any other attribute. Once you have identified such an attribute, you can use it in forming your rule. For example, if you want to include all users from the "Sales" department, your rule might look like this: (user.department -eq "Sales") Click on Add Query, then Create.

    Please note that these steps only work if the specific user properties used in the dynamic group rules are available and synchronized into Azure AD. If your scenario involves a SharePoint list which is not directly related to any user property or attribute in Azure AD, you may need to explore custom synchronization solutions or use PowerShell scripting to update group members based on changes in the SharePoint list.

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. BhargavaGunnam-MSFT 28,766 Reputation points Microsoft Employee
    2024-02-20T19:11:12.9266667+00:00

    Hello Prita Dewi, Welcome to the Microsoft Q&A forum.

    The below blog and Vidoe tutorial explained about how to create dynamic groups in Azure AD based on sharepoint list.

    https://blog.atwork.at/post/Dynamic-groups-accessing-SharePoint-Online

    Video tutorial

    Please go over them and let us know if you have any further questions.

    1 person found this answer helpful.
    0 comments No comments