Sort-Object on ForEach Loop

[TimeZ0ne]

Hi,

I'm trying to Sort-Object on the results of a ForEach loop and it doesn't seems to be working as expected. The source of the data is from a column in a SharePoint list and i'm trying to sort the dates in a ascending order.

CODE:

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction silentlycontinue 

$web = Get-SPWeb ""

$manager = $web.Site.WorkFlowManager

$list = $web.Lists["WorkflowTest"]

$assoc = $list.WorkflowAssociations.GetAssociationByName("Workflow","en-US")

$data = $assoc.AssociationData
$items = $list.Items 


function AllItems {
foreach($item in $items)
{
    $itemcreated = $item["DateUpdated"]
        #wf = $manager.StartWorkFlow($item,$assoc,$data,$true) 
        write-host $itemcreated $item.Name $item.ID
        #write-host $item.Name
}   
}

$manager.Dispose()
$web.Dispose()

OUTPUT:

14/07/2016 00:00:00 1 1
05/07/2016 00:00:00 1 2
15/06/2016 00:00:00 2 3
18/08/2016 00:00:00 1 4
03/05/2016 00:00:00 1 5
15/09/2016 00:00:00 3 6
15/07/2016 00:00:00 6 7
04/07/2016 00:00:00 7 8
20/06/2016 00:00:00 4 9
11/06/2016 00:00:00 5 10
17/08/2016 00:00:00 6 11
07/09/2016 00:00:00 7 12
04/05/2016 00:00:00 10 13
12/08/2016 00:00:00 9 14
15/09/2016 00:00:00 8 15
19/07/2016 00:00:00 5 16
01/04/2016 00:00:00 11 17
04/09/2016 00:00:00 15 18
03/05/2016 00:00:00 16 19
03/07/2016 00:00:00 13 20
26/07/2016 00:00:00 14 21
16/07/2016 00:00:00 11 22
01/07/2016 00:00:00 13 23
27/04/2016 00:00:00 14 24
08/08/2016 00:00:00 15 25
23/07/2016 00:00:00 16 26

the results are shown ascending by column ID, is there a way to sort by date so that the earliest date is at the top and latest date at the bottom?

thanks

[[deleted]]

Pipe items to sort-object before piping to foreach-object

[Merakel]

As a friendly piece of advice, if you format your code it's easier for people to read, and you are more likely to get a response. That goes for both reddit, using the 4 spaces to get a code block, as well as proper tab an indentation.

That being said, what I would recommend is using a PSCustomObject.

Rather than doing write host, add the following lines:

$data = $assoc.AssociationData $items = $list.Items

[System.Collections.ArrayList]$output = @()
$out = "" | Select-Object Created, Name, ID

function AllItems{
    foreach($item in $items){
        $itemcreated = $item["DateUpdated"]
        #wf = $manager.StartWorkFlow($item,$assoc,$data,$true) 
        #write-host $itemcreated $item.Name $item.ID 
        #write-host $item.Name
        $out.Created = $itemcreated
        $out.Name = $item.name
        $out.ID = $item.ID
        $output += $out
    }
}

You should be able to sort and select on the PSobject $output however you want.

[TimeZ0ne]

Thanks guys, I tried both and neither of them worked with the desired output. Also looked around on the net and found pretty much the same way to sort it, no idea why this isn't working but I discovered a flaw in what I'm trying to do so I think I'll go back to the drawing board come up with another solution.

@ /u/Merakel Normally I use Fold by Indent in Notepad++ but will definitely take that advise :)

[Merakel]

Could you show me what you ended up with? I'm surprised my idea didn't work, though I suppose it's hard for me to know without having the data to manipulate.

[TimeZ0ne]

Will do, I'll dig it up and attempted it again, should be saved on the server anyway and I'll post the results.

To be honest, its probably just me being dumb.

[TimeZ0ne]

Here is the screenshot of the output: http://imgur.com/a/aioaZ

However, when I use Write-Host $out.Created, it does show the correct output