SharePoint Online offers the useful feature of news links to avoid duplication of news articles and promote existing posts across different sites. This is especially beneficial when news creation is enabled for various departments or directorates, allowing them to share significant news organization-wide. However, the News WebPart might display both the news links and the original articles, resulting in duplicated content. To manage this, you can utilize the OriginalSourceUrl column, which stores the link to the source news article.

#Parameters $SiteURL = “https://contoso.sharepoint.com/teams/app-ar" $ListName = “Remittances” $dateTime = (Get-Date).toString(“dd-MM-yyyy”) $invocation = (Get-Variable MyInvocation).Value $directorypath = Split-Path $invocation.MyCommand.Path $fileName = “\RemittanceDuplicateReport-” + $dateTime + “.csv” $OutPutView = $directorypath + $fileName Connect-PnPOnline -url $SiteURL -Interactive $ListItems = Get-PnPListItem -List $ListName -PageSize 500 | Where {$_.FieldValues.Month -eq ‘202402’ } #Array for Results Data $DataCollection = @() ForEach($Item in $ListItems) { #Collect data $Data = New-Object PSObject -Property @{ SourceRef = $Item[“DocumentSourceReference”] GroupingRef = $Item[“GroupingReference”] Provider = $Item[“Provider”].

Maintaining up-to-date list items, especially when dealing with choice fields, can be a daunting task sepcially after choice field values are updated. We need a way to update these old values to the correct new ones. The Challenge SharePoint lists use choice fields to categorise items. Over time, the need to update these choice values can arise, whether due to changes in terminology, business processes, or error correction. Manually updating these values across numerous list items is not only time-consuming but also prone to human error.