Forum Discussion
Add an AD group to a SharePoint List User/Group column
Lee-Martin Did you add Azure AD group directly inside SharePoint group? and the SharePoint group is added to person or group column settings?
If yes, you cannot directly search the users in nested (Azure AD) group like this. You might be able to search the whole AD group using group name but you cannot select the users inside it.
You need to add all users directly inside SharePoint group to select it in person or group column.
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.
- ganeshsanapAug 11, 2022MVP
Lee-Martin Yes, correct.
Either you have to manually add all AD group users to SharePoint group OR you have to build custom solution (maybe using PowerShell or Power automate) which will read all users of AD group & add them one by one to SharePoint group.
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.
- MA512Nov 29, 2022Copper ContributorWow...this is a terrible solution on Microsoft's part! I need to be able to restrict a sharepoint column to users who are in a large dynamic AD group. There's no way I'm adding and managing 350 individual users to create a NEW sharepoint group. There's really no other solution Microsoft has that could make use of existing AD groups???
- ganeshsanapDec 01, 2022MVP
MA512 No, above is the limitation as per the current design by Microsoft.
You can add new feedback/idea on SharePoint feedback portal and request for new feature supporting Azure AD groups in person or group columns: SharePoint feedback portal
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.
- ShivamG950Jul 07, 2023Copper Contributor
can you help me how to power automate will read all users of AD group & add them one by one to SharePoint group ,ganeshsanap
- ganeshsanapJul 07, 2023MVP
ShivamG950 You can get Azure AD group members using "Get group members" action in Azure AD connector.
Then you can use Send an HTTP request to SharePoint action to add users to SharePoint group or you can add directly Azure AD security to SharePoint permissions like shown here: SharePoint Online: Grant Permissions to Azure AD Security group using Power Automate and REST API
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.