There are many things we do with SharePoint that can be either scripted or formatted that require some sort of code. In my previous post, I talk about how it can assist content creators, but what about people who are building things? Here are two examples that might inspire you to try this yourself, the first is a PowerShell script and the second some JSON … Continue reading ChatGPT and SharePoint, what else can it do?
Do you have a file server full documents in the old Word document format? This blog explains how to use PowerShell to bulk convert files from .DOC to .DOCX. The script can be run against a folder full of documents, automatically crearting a new version in .DOCX format. The same script can be easily modified to convert Word documents of any format to PDF format. … Continue reading Converting Word document format with PowerShell
Do you need to keep data in SharePoint Lists in sync with source data on a local server? Microsoft provides a Data Management Gateway giving access via Power Platform, however this requires premium licensing, that sometimes is hard to justify. Another option to explore is using PowerShell to keep the data up to date. Using this method can reduce the need for premium data connectors … Continue reading Updating SharePoint Lists with New-PNPBatch
There are a number of ways to upload files to SharePoint, but every now and then I get asked to do something a bit different. In this case it was to migrate files from a database into SharePoint. The database had a file path reference with documents stored in a file structure on Windows file share. Success would see over 80,000 documents transferred into just … Continue reading Upload files to SharePoint Library Subfolders with PowerShell
Custom Vision is service for creating computer vision models that can be interacted with via a REST API. Custom Vision is powered by Cognitive Services. Here is a simple demo using PowerShell to determine whether a flag is from New Zealand or Australia. These flags have a lot of similarities, including the Union Jack, blue back ground and Stars, so I thought it would be … Continue reading Custom Vision with PowerShell
Here is a script I wrote to bulk upload files and metadata into SharePoint. To make this work you need two things, a CSV file containing the names of the files to upload and the metadata associated with the item. In this example, the CSV file has the following format: filename,cust_number,document_type The script reads the CSV file, creates a folder in the document library named … Continue reading PowerShell:Bulk load files into SharePoints
I recently had the need to locate all list columns in a SharePoint site of a particular data type. My first thought was someone must have done this before and after a quick hunt around in Google discovered that it wasn’t the case. I wrote a simple script to output the names of lists and fields of a particular type using PowerShell. It is easy to … Continue reading SharePoint Powershell List Column Queries
SharePoint lightbulb moments 