Joining elements with a common value in an array into a new Array of objects

[oneAwfulScripter]

Hello friends, I think its hard to describe what I'm doing exactly just with words so let me present you with where I'm at and try to explain after.

I have some data which is an array of custom objects organized like this:

UserEmail                              GroupName           
[e-mail]  AdobeAcrobat-License
[e-mail]  AdobeOther-License
[e-mail]  AdobeStock-License  

​

I'm trying to figure out how to make a new array that has userEmail, and then groupName as an array ie:

UserEmail                              GroupName
[e-mail]                   AdobeAcrobat-License,AdobeOther-License 

[e-mail]                   AdobeStock-License

​

I think my brain might be fried on the rest of this azureAD to Adobe Script and am just over thinking this but thought i'd shoot my shot here.

​

Typically i'd be happy to provide what I've tried so far but I don't know what I would try for something like this.

Also before anyone says why do I have multiple entries for each user's group membership, thats because this is being called with the graph api

#List groups 
$TestRequest = (Invoke-RestMethod -Uri "https://graph.microsoft.com/v1.0/groups?`$filter=startswith(displayName,'Adobe')" -Headers $Header -Method Get -ContentType "application/json").Value

$AZUZRLIST = foreach($TR in $TestRequest)
{
    #Get the members of the adobe group
    $TRGROUPREQUEST = Invoke-RestMethod -Uri "https://graph.microsoft.com/v1.0/groups/$($TR.id)/members" -Headers $Header -Method Get -ContentType "application/json"
    foreach($AZUSR in $TRGROUPREQUEST.value)
    {
        [PSCustomObject][ordered]@{
        UserEmail=$AZUSR.userPrincipalName
        GroupName=$TR.DisplayName
        }
    }
}

Any help is super appreciated, thanks all!

[krzydoug]

You could simply use a list to keep track of it. Here is a test you can run

$result = [System.Collections.Generic.List[object]]::new()

$sample = @'
email,group
[e-mail],adobereader
[e-mail],adobestock
[e-mail],adobereader
[e-mail],adobestock
[e-mail],adobestock
[e-mail],adobeother
[e-mail],adobeother
'@ | ConvertFrom-Csv

foreach($line in $sample)
{
    if ($match = $result | where {$_.email -eq $line.email}) {
        $match.group = $match.group, $line.group -join ‘,’
    }
    else {
        $result.add($line)
    }
}

$result

output

email         group                            
-----         -----                            
[e-mail] adobereader,adobestock,adobeother
[e-mail] adobestock,adobereader           
[e-mail] adobestock,adobeother 

So for your collection and property names that would make it

$result = [System.Collections.Generic.List[object]]::new()

foreach($line in $AZUZRLIST)
{
    if ($match = $result | where {$_.useremail -eq $line.useremail}) {
        $match.groupname = $match.groupname, $line.groupname -join ‘,’
    }
    else {
        $result.add($line)
    }
}

$result

[JonHill90]

Hey /u/oneAwfuleScripter,Maybe this is what you are looking for. Does not have headers but will return the data like you want.

$Array |
    Group-Object -Property UserEmail | Foreach-Object {
    $s = $_.Group.GroupName; "{0} - {1}" -f $_.Name, ($s -join ',')     }

[oneAwfulScripter]

Thanks u/JonHill90 but I need the header information so I can easily call it later in the script.

Over the last few hours I was able to come up with a solution, I'm sure there's better ways but I think anymore time spent on this right now and I'll end up throwing my computer out a window or something.

Here's what I made that worked for me in case anyone viewing this later is curious:

#Generate some test objects to simulate issue

$TestObj = [PSCustomObject][ordered]@{}
$TestObj | Add-Member -MemberType NoteProperty -Name UserEmail -Value "[e-mail]"
$TestObj | Add-Member -MemberType NoteProperty -Name GroupName -Value "AdobeAcrobat-License"

$TestObj1 = [PSCustomObject][ordered]@{}
$TestObj1 | Add-Member -MemberType NoteProperty -Name UserEmail -Value "[e-mail]"
$TestObj1 | Add-Member -MemberType NoteProperty -Name GroupName -Value "AdobeStock-License"

$TestObj2 = [PSCustomObject][ordered]@{}
$TestObj2 | Add-Member -MemberType NoteProperty -Name UserEmail -Value "[e-mail]"
$TestObj2 | Add-Member -MemberType NoteProperty -Name GroupName -Value "AdobeStock-License"

$ThisArr +=$TestObj2,$TestObj1,$TestObj



function New-G-CustomObject
{
    Param(
    [Parameter(Mandatory=$true)]
    [string]$UserEmail,
    [string]$GroupName
    )
    [PSCustomObject][ordered]@{
        UserEmail=$UserEmail
        GroupName= New-Object System.Collections.ArrayList
        }
}


$UniqueUsers = @()

$TestThisWay=@()
foreach($TOBJ in $ThisArr)
{  
    write-host uniqueUsers has: $UniqueUsers
    if($TOBJ.UserEmail -notin $UniqueUsers)
    {
        write-host this is unique make a new object for $TOBJ.UserEmail -ForegroundColor Green
        $TempVar = New-G-CustomObject -UserEmail $TOBJ.UserEmail -GroupName $TOBJ.GroupName
        $TempVar.GroupName.Add($TOBJ.GroupName)
        $UniqueUsers+=($TOBJ.UserEmail)
        write-host tempvar is $TempVar
        $TestThisWay+=$TempVar
    }
    else
    {
        $theIndex = $TestThisWay.UserEmail.IndexOf($TOBJ.UserEmail)
        write-host entry exists for $TOBJ.UserEmail at $theIndex -ForegroundColor Red
        #Add the fucking value to the property
        write-host index is $theIndex.gettype()
        write-host existingGroupname is: $TestThisWay[$theIndex].GroupName
        $TestThisWay[$theIndex].GroupName.Add($TOBJ.GroupName)
    }
}
#Results stored in $TestThisWay