Finally! We can now see how many Private Channels a Microsoft Teams Team has, directly from the SharePoint Admin Center! As a reminder, when you create a Private Channel, it creates another SharePoint site with different permissions. Meaning a Team could have many other SharePoint sites that we couldn’t see, and therefore, do “things” that would have been regrettable!

In this short and sweet post, we’ll see where to find the information about Private Channels in SharePoint Online.
 

In case you haven’t seen, there’s a new feature when you share a document from SharePoint Online: Open in review mode only. In this blog post, we’re going to have a look at how it works, and what’s the experience from a reviewer perspective.
 

How does it work?

When you’re about to share a document, you’ll see the option in the popup. You must have allow editing checked, or the option will be greyed out.

There are so many features in SharePoint (on-prem & online) that some may be overlooked. Lately, I was working on a PowerApps with Power Automate in the background, and I needed to set default values for some items’ fields, and surprisingly, my first thought was to set those values within the flow.

But I have noticed a couple of things by doing it this way. First, that Power Automate was slow to set the value, and second, it was also adding a new version (i.e.: 2.0) to the item! Which I didn’t want as I was using specific trigger conditions to the flow based on the item version.

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! 🚀

CSV file

Nothing specific in the .csv file compared to other methods of creating items. The difference will only rely on the command parameters. For this example, I just have three (3) columns/headers in my list:

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:

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? 😟

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? Then read on! 😉

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). And we also have a files on its own (SPO Roadmap.pptx) at the same level as the Folder1.