PowerShell script should read each line item from “Azure AD Group” sheet of the attachment and create a Azure AD group. Also assign owner permission to all the email Ids listed in the “Owners” sheet

Question

PowerShell script should read each line item from “Azure AD Group” sheet of the attachment and create a Azure AD group. Also assign owner permission to all the email Ids listed in the “Owners” sheet

NM Babu 1

In a CSV file I have 2 sheets. One is for Creating of group email accounts and the second one is for adding all the users as owners to all the groups. How to automate this by using PowerShell scripts?

Shashi Shailaj 7,651 Reputation points Microsoft Employee Moderator

2022-04-01T15:43:16.767+00:00

@NM Babu ,
I think you have asked the query for this on another question https://learn.microsoft.com/en-us/answers/questions/794746/assign-bulk-owners-to-bulk-azure-active-directory.html as well. I have answered that however , its not based on a single excel file with details in 2 different sheets. It should be possible to automate but I will have to test this scenario . We may need to obtain the user's objectId from the email address and the group object ID as well . I have based my other solution on ObjectId using the Add-AzureADGroupOwner . Could you please check and see if that one works for you ?? You may have to modify your csv file using excel to have everything in the same sheet rather than different one and same group in each line item . Please let us know .

Thank you .