SharePoint Online has a list view threshold (LVT) of 5,000 items, which can cause performance issues if exceeded. This post provides a workaround through filtering libraries/lists to stay within this limit and avoid common problems associated with large lists. The Problem When a SharePoint library exceeds the 5,000-item threshold, various issues can arise. These include: Inability to Browse Folders Navigating through folders becomes challenging and sometimes impossible through desktop office apps (Excel, Word,etc.

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.

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.