Create multiple list items with a CSV file using Invoke-PnPRestMethod

Did you know that there’s also a PnP PowerShell command that will use a REST request? Meaning we’ve got a different syntax, (sometimes) better performance, but the same results. In this post, we’ll create items in a SharePoint Online list using the Invoke-PnPSPRestMethod by importing a CSV file. Let’s go! 🚀 REST API If you’re not familiar with SharePoint REST API, have a look at the official documentation. CSV file Nothing specific in the .

Update specific list items in SharePoint with PowerShell

In this post, we’ll have a look at a specific cmdlet: Set-PnPListItem. We have a couple of interesting parameters (including the -Batch one!), depending on what we’re trying to do. If you used this cmdlet before, and particularly to update something without creating a new version of the file, we used the -SystemUpdate parameter which I’ve found great and really useful. Now we have new ones which are under -UpdateType:

Find who deleted files in SharePoint using PowerShell (from the recycle bin)

Recently, I’ve seen a few requests about how can we get who deleted files in a SharePoint Online site? You know… that “Deleted by” column in the recycle bin? But have you tried to get the value of that column with PnP PowerShell? Of course you have, by using the DeletedBy property of Get-PnPRecycleBinItem… And have you noticed something like, blank results? 😟 Well, I’ve stumbled on that too! Some CSOM objects are not returned (blank) and this is not an easy fix unfortunately, BUT changes might come in the future.

Use list formatting samples to enhance your SharePoint Lists & Libraries

SharePoint Online has come a long way visually from the old days, and also from an “out-of-the-box” functionality point of view. A lot of things don’t require organisations to code or script to get something decent. BUT, we also have fantastic contributions from the Community with List Formatting samples! And that’s what we’re going to look at today! So… Do you want your SharePoint lists and libraries to look better? Yes?

Copy or Move files (not folders) to another library or Site using PowerShell

In today’s post, we’ll have a look at something that could potentially be your mini “re-organisation / migration” project. We’ll see how to copy or move files to another location, either on the same site but different library, or a completely different site. Starting Point Let’s have a look first at our current (dummy) structure. We have SitePnP1 where we’ll use the default Documents document library. Inside this library, we have a folder called Folder1 with files inside (nested files).

Find missing metadata in SharePoint using PowerShell

Did you know that fields in SharePoint Online set as “required” are not so… required anymore? It may be a pain for some, but they are now used as ‘guidance’ with a yellow background color instead and other signs like the red dot in the View. It means that users can upload documents without filling the required values and leave the site! 😕 This is not ideal if you use this metadata for your Search is it?

Working with Views in SharePoint

Having different Views in your SharePoint lists & libraries can be very useful. It allows you to see information in a different way pretty quickly, and remove the noise. In this post, we’ll have a look at the available options so you can choose what’s best for you! Default View Out of the box, SharePoint sets the default view to “All items” for lists, and “All Documents” for libraries. Meaning there’s no specific filtering.

Check if SharePoint site is connected to a Microsoft Teams with PowerShell

First post of 2021, and in this brief post, we’re going to see how we can check if our SharePoint Online sites have a Microsoft Teams team associated to it. Why is it brief? Because PowerShell PnP is making it very easy! 🤩 From now on, we’re also going to focus on the new PnP PowerShell module available for PowerShell Core. This is the module we’re familiar with, but available on Windows, MacOS, or Linux!