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?
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
@NMBabu-1149 ,
I think you have asked the query for this on another question https://docs.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 .
2 people are following this question.
