When working with SharePoint lists, there might be times when you need to restore items to a previous version. Whether it’s due to an error, unwanted changes, or simply needing to revert to an earlier state, SharePoint’s versioning feature is a lifesaver. I used the script to undo bulk changes made by a Power Automate flow after the process failed halfway due to some data needing correction. For data integrity, the bulk update needed to be undone before running the Power Automate flow again after the data corrections were made.

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.

Leveraging ChatGPT to Generate Test Data for SharePoint Lists Using PnP PowerShell Utilizing ChatGPT to generate test data for various applications is a powerful capability. After stumbling upon the sample script Create test users using MS Graph API from list or ask ChatGPT to generate test users by Valeras Narbutas on creating test users with MS Graph API, I decided to explore using ChatGPT to generate a list of data. This script harnesses OpenAI’s ChatGPT model to effortlessly generate a list of wellbeing activities.

Optimising Large List Updates with PnP Batch: Handling Throttling and Enhancing Efficiency In this article, we explore how to efficiently update a large SharePoint list containing approximately 60,000 items using PnP-Batch. Updating such a substantial number of items individually can be time-consuming and prone to throttling issues. Prior to using PnP Batch , it was taking more than 12 hours to update 60k one by one. The article highlights the benefits of using PnP Batch, which significantly reduces the time taken for updates by sending fewer requests.

Expanding Doughnut Chart in Microsoft Lists: Visualize Data in Segments and Track Progress The doughnut chart is a powerful visualization tool that allows users to represent data in segments and track progress against targets. Frederico Sapia’s Doughnut Chart with percentage and values displayed is a valuable custom chart for Microsoft Lists, enabling users to visualize data effectively. However, the original chart allowed for only six slices, limiting its flexibility. In this blog post, we explore how to extend the doughnut chart to support up to nine slices, and we’ll also demonstrate how to display the percentage of each segment within the chart.