PowerShell PnP sort SharePoint choice column

Question

We are using this below script to add new values to our choice column, but need the option to sort the SharePoint list column choice values ascending. There are over 150 values, and just putting new values on the end/bottom of the dropdown isn't user friendly.

Connect-PnPOnline -Url "https://MySite/sites/Sandbox" -UseWebLogin
$field = Get-PnPField -List aaa-f31e-4cc0-b193-bbb -Identity Schedule
[xml]$schemaXml = $field.SchemaXml

$varNewChoice = $schemaXml.CreateElement("CHOICE")
$varNewChoice.InnerText = "Thursday"
$schemaXml.Field.CHOICES.AppendChild($varNewChoice)

Set-PnPField -List aaa-f31e-4cc0-b193-bbb -Identity Schedule -Values @{SchemaXml=$schemaXml.OuterXml}

*** Update >> Was able to get this code to both add value and sort:

Connect-PnPOnline -Url "https://ourtenant.sharepoint.com/sites/Sandbox" -UseWebLogin
$field = Get-PnPField -List "Space Request Form" -Identity "Schedule"
$ctx = Get-PnPContext

$fieldChoice = [Microsoft.SharePoint.Client.ClientContext].GetMethod("CastTo").MakeGenericMethod([Microsoft.SharePoint.Client.FieldChoice]).Invoke($ctx, $field)

$ctx.Load($fieldChoice)
Invoke-PnPQuery

$choices = $fieldChoice.Choices
$choices += "Bentley"

$fieldChoice.Choices = $choices | Sort-Object 

$fieldChoice.UpdateAndPushChanges($true)
Invoke-PnPQuery

Answer 1

In the order, we enter the value in choice column, those get rendered that way. So, if you have more items to the choice column, for me the workaround would be - copy the previous choice column value to a excel and add your new entry over there, then apply sorting that excel column and finally copy the entire column and paste into the actual choice column in SharePoint (this will replace the the previous choice entries).

How to sort column value alphabetically in excel, refer to the below article :

How to alphabetize in Excel: sort columns and rows A-Z or Z-A

How to sort SharePoint choice column value using the PnP PowerShell?

Using the below code - we can sort the SharePoint choice column value.

#Connect to PNP Online
Connect-PnPOnline -Url "yoursiteurl"

$field = Get-PnPField -List "yourlist" -Identity "mychoice"

$ctx = Get-PnPContext

$fieldChoice = [Microsoft.SharePoint.Client.ClientContext].GetMethod("CastTo").MakeGenericMethod([Microsoft.SharePoint.Client.FieldChoice]).Invoke($ctx, $field)

$ctx.Load($fieldChoice)
Invoke-PnPQuery

$choices = $fieldChoice.Choices
$choices += "below"

$fieldChoice.Choices = $choices | Sort-Object 

$fieldChoice.UpdateAndPushChanges($true)
Invoke-PnPQuery

Reference:

PowerShell PnP sort SharePoint choice column

PowerShell PnP sort SharePoint choice column