Author Posts

May 23, 2017 at 12:32 pm

Hi,

Have an specific issue.

Have local AD with different security groups. I want to add members to sharepoint online groups.

Am not quite sure how to attack this issue. Assume the best way is to export all the groups to an csv and use this to add members to the groups in SP.
Will be naming the groups on both end exactly the same.

Need some assistance with the looping. (Struggling to wrap my head around the best way to foreach)

What I go :

$adminUPN="admin@customer1.onmicrosoft.com"
$orgName="Customer1"
$userCredential = Get-Credential -UserName $adminUPN -Message "Type the password."
## Download : https://www.microsoft.com/en-us/download/confirmation.aspx?id=35588 (sharepoint online powershell)
Connect-SPOService -Url https://$orgName-admin.sharepoint.com -Credential $userCredential

Get-ADGroup -SearchBase "OU=Sec_group,DC=contoso,DC=Local" -filter * | select name | Sort-Object name | export-csv C:\report\adgroups.csv
$import = import-csv C:\report\adgroups.csv
foreach ($user in $import) {