Power Automate can be used to set permissions on items in SharePoint Lists and Libraries. This can allow custom permissions to be set based on metadata or other parameters. In this post I will explain how to set permissions on an item using a Flow that triggers on item creation. Microsoft provides some documentation on Power Automate and SharePoint permissions, but this only helps with … Continue reading Setting SharePoint Permissions with Power Automate
I love the simplicity of Modern SharePoint News Posts, they make it easy to create and publish nice looking news posts with rich content. There are a few things that could be improved, for example creating a site where many people can contribute News Posts means the home page of the site is also editable. Making the home page read only removes the Add button, … Continue reading SharePoint tip: Create a News Post button
Almost every day I get asked “where should I save this?”. Sometimes it from clients, sometimes it’s from my team and sometimes I’m asking myself. Will so many choices of where you could save you document, it is no wonder any people simply don’t know. Do I save to the network drive, SharePoint, OneDrive, Teams, somewhere else? Oh it’s all to hard, I’ll save to … Continue reading Where should I save my stuff?
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
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