Author: <span class="vcard">David Ramalho</span>

When a user creates a News Post on a SharePoint site there are a couple of options out-of-box that will send some notifications. However, if an user accesses the Microsoft Teams, for example, he will never know something as been added to the site. So the option shown on this blog post is the most easy and fastest way to get information to Microsoft Teams.

A couple of days ago someone asked about how they can create a SharePoint list from an Excel file. There are a couple of methods available to perform this task but on this blog post, I will do the easiest way on my opinion to make this to happen.

Photo by ConvertKit on Unsplash

Microsoft Teams allow you to quickly increase your collaboration and creating live events are extremely useful for some scenarios inside your organization. These type of event have some key features that you’ll not be able to get from the regular meetings that are organized on a daily bases. This features can be used for example to share a new product that you’re planning to release, have some training session, webinar, etc.

When you sharing PnP PowerShell scripts with someone, sometimes these users don’t have the option to install cmdlets on their machines and that will lead to some questions back and forth about the script not working as expected. So, we can save the modules required to perform our task on the PC and then execute from there the code.

Photo by freestocks on Unsplash

In my last blog post, I shared a PowerShell script that allows you to export a term set to a CSV file. This script has similar purposes but with fewer lines of code. This will extract the complete term group instead of the Term set as well. If you which, you can edit the file created and delete the unwanted term set that was created by this command.


Photo by PDPics on Pixabay

This is one of the most used features of SharePoint and sometimes, we may create this term set on a testing site and we need to transfer this term set to other sites. I’ve created a PowerShell script that allows you to export this to a CSV file. You can then use SharePoint OOTB functionality to import the term set to your taxonomy somewhere else.

Photo by Brett Jordan on Unsplash

When creating new pages with News Post often we don’t know exactly the images. Same happen with some document that you may want your company to have access on when creating the new pages. So a couple of days I cross with the feature on SharePoint Online that allows you to create these
Organization Assets. To enable this, it’s needed to run a couple of cmdlets.

PowerShell is used to complete multiple tasks nowadays, for example, we can have an Azure Function that runs PowerShell. This is also applicable if you want someone that works with you on a project that you’ve done a task or something as been created. A good way is to create a specific channel on Microsoft Teams Team with this connector that informs us when the PowerShell has finished.

Sometimes when building some internal processes to organizations, it’s possible that it is required to create a SharePoint list. However, sometimes it can create confusion for the end-user that sees the list there. So we can hide that list from the SharePoint site to avoid this. Everything will work as normal on the list and it’ll be accessible via URL. This scenario can be used as well when you’re building a new list using List Formatting and you don’t want the list to be available just yet. This is possible to be done in a SharePoint with a few steps. We’ll use the PNP Powershell and Office 365 CLI to demonstrate.

When we’re collaborating inside our organizations we often send links with access to the document. This task is done in a dairy and sometimes it is difficult to understand which files as been shared. So a couple of weeks ago, I cross with this feature that is recent on SharePoint/OneDrive that allows you to get a report, on CSV, to verify which files are being shared.