SharePoint Lists are great for tracking activities. There are many scenarios where you may want to store a collection of documents for each List item. In this blog I explain how to use Column formatting to create the link to the documents related to a List item. In this example, we have a List that will track enquires and a Library with a folder per … Continue reading Link SharePoint List to a Document Library
There have been several high profile ransomware incidents in New Zealand recently. The impact can be very high and the recovery process can be a difficult road in some cases. There are many things that can be done to mitigate the risk of ransomware but it is hard to be 100% safe. As well as the disruption to your business, there can also be privacy … Continue reading SharePoint Online Ransomware Recovery
Last week there was some big news for Visio fans as Microsoft announced Office 365 will be included with most business subscriptions, from Business Standard to the E5 Enterprise subscription and everything in between. Judging from the feedback I’ve had after posting the news on LinkedIn, many people have wanted this for years! The web only version of Visio is great for basic diagrams and … Continue reading Visio App coming to Office 365
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
Microsoft provides a couple of ways to send out an update or digest email. You can use a simple Alert on the site pages library or use the built in News Digest feature to manually send a digest of selected articles. Sometimes you may need to create a custom solution and Power Automate is the right tool for the job. In this video I demo … Continue reading Creating a Custom SharePoint News Digest with Power Automate
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
If you Office 365 Tenant has been around for a while, chances are the root site is a classic team site. Having the ability to swap this site (or any other site) with a new site, means you can build the replacement site and switch over when ready. Sounds simple, but beware as there are a few fish-hooks to be aware of. The Invoke-SPOSiteSwap PowerShell … Continue reading SharePoint Site Swap
SharePoint lightbulb moments 