How to customize channel email on Microsoft Teams
Sep21

How to customize channel email on Microsoft Teams

Do you know you can send email to Microsoft Teams channel? If so you are familiar with this feature, you know it generates an email that is far from being friendly. With this blog post, I will show how you can make some configurations to have a friendly email which will be a lot easier for the end-user. If you are not aware of the feature that I’m talking about on this blog post… Continue Reading David Ramalho’s...

Read More
Show/hide the New button from a SharePoint Document Library
Sep20

Show/hide the New button from a SharePoint Document Library

There are some scenarios where the document libraries on SharePoint are used only to upload files. For example, let’s say that you have a sales team that need to upload to a document library an excel every week. Therefore, maybe the new button to have an option to create a new folder or create a new document doesn’t make much sense. So, if click on that button as admin of the… Continue Reading David Ramalho’s...

Read More
Add multiple users in a SharePoint site
Aug03

Add multiple users in a SharePoint site

A few days ago, I had a request to add multiple users in a SharePoint site but using the default interface, I can only add one by one. If we have a long list of users that need to be added to the site this tasks can take a while. So I come up with a PowerShell that will do this task based on a CSV file that contains the email that will make this process faster For this PowerShell, I… Continue Reading David Ramalho’s...

Read More
Discover all the private channels on Microsoft Teams
Jul05

Discover all the private channels on Microsoft Teams

Creating private channels is possible by default on your organisation and probably all organisation will have these types of the channel on Microsoft Teams. But from a governance perspective that can leave the user to create those without any criteria. So on this post, we will share a PowerShell script that will allow getting all the private channels on your organisation. This… Continue Reading David Ramalho’s Article on...

Read More
How to make Microsoft Graph request using PnP and Office 365 CLI
Jun14

How to make Microsoft Graph request using PnP and Office 365 CLI

Information Circuit Board Graphics Concept Microsoft Graph has a lot of commands that you can use to do some tasks. That will require you to manage and built the OAuth and from there make the request to Graph. But you can use the PnP PowerShell to perform this task. The commands will enable all of this and you don’t have to manage anything. The first step is to authenticate with the… Continue Reading David Ramalho’s...

Read More
The required Office 365 role to run PnP Powershell with Scopes
May31

The required Office 365 role to run PnP Powershell with Scopes

Authorized Allowance Permission Permit Approve Concept When installing using PnP PowerShell using the Scope connection, it’s required to connect with an account with some additional permissions and often, we just take the easy route, give or ask Global Admin. With that role, I will be able to do anything with the scopes, but in some organizations granting this type of permissions can take… Continue Reading David...

Read More
Setup an alert when a file is edited on OneDrive
May17

Setup an alert when a file is edited on OneDrive

Photo by Scott Graham on Unsplash When you share the file from your One Drive with external users, often is to collaborate during the lifecycle of the document. There are some scenarios where you may want to know when that file is edited. So we have PowerAutomate where you can create a Flow to detect these changes. However, there are some tricks that you need to use in order to detect… Continue Reading David...

Read More
Schedule a Team conversation on Microsoft Teams
May04

Schedule a Team conversation on Microsoft Teams

With the increasing use of Microsoft Teams new scenarios are raised for the people and a couple of days ago I saw something about how can a user schedule a Team conversation. This option is not available out-of-the-box probably because you can have the app to install this on your phone and can easily create a post whenever is needed. However, there are some people that don’t have any… Continue Reading David Ramalho’s...

Read More
Get notified by email when a news post is created on a SharePoint site
Apr26

Get notified by email when a news post is created on a SharePoint site

Photo by Bram Naus on Unsplash If you looking for publishing news content to your organization quickly and with perhaps looking to SharePoint News should be the way to go. You’ll have access to multiple tools and get for example content displayed from multiple sites. If you have the SharePoint App on your phone, you’ll be notified once something new is published. However, there are some… Continue...

Read More
Notify your Team when a news post is published on SharePoint site
Apr19

Notify your Team when a news post is published on SharePoint site

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. This option has some… Continue Reading David Ramalho’s Article on...

Read More
How to export a table from Excel to SharePoint list
Apr12

How to export a table from Excel to SharePoint list

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. The required action to be able to export the Excel file to a SharePoint list is to create a table from your Excel file. After that, you… Continue Reading David Ramalho’s Article...

Read More
Enable Microsoft Teams Live Events for Everyone
Apr01

Enable Microsoft Teams Live Events for Everyone

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… Continue Reading...

Read More
Run PnP PowerShell with saved module
Mar22

Run PnP PowerShell with saved module

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. For this script to work, you need to know the… Continue Reading David Ramalho’s...

Read More
Export Term group with PnP PowerShell
Mar08

Export Term group with PnP PowerShell

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. <span… Continue Reading David...

Read More
Export SharePoint Term Set to CSV
Feb23

Export SharePoint Term Set to CSV

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. This… Continue Reading David Ramalho’s...

Read More
Enable Organization assets on SharePoint Online
Feb09

Enable Organization assets on SharePoint Online

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… Continue Reading...

Read More
Send a message to Teams channel with PowerShell using Webhook
Jan26

Send a message to Teams channel with PowerShell using Webhook

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…. Continue Reading David...

Read More
Hide SharePoint list from Site Contents
Jan12

Hide SharePoint list from Site Contents

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… Continue Reading David...

Read More
Get a report of files shared in SharePoint or OneDrive
Dec15

Get a report of files shared in SharePoint or OneDrive

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. The reports… Continue Reading David Ramalho’s...

Read More
Add Office 365 CDN rule to have a document library for each SharePoint site
Nov24

Add Office 365 CDN rule to have a document library for each SharePoint site

On SharePoint online, there is a possibility to activate a feature on the tenant that allows you to have CDN on some libraries inside your SharePoint. Typically, there are multiple files stored in this service and they will load faster on the page if you have this service activated. By default, this feature is not activated on the SharePoint Online, so first, we need to run the… Continue Reading David Ramalho’s Article on...

Read More
External Users Message – SPFx Extension
Nov10

External Users Message – SPFx Extension

A few weeks ago, I’ve submitted my first contribution to the community repository of SharePoint Framework solutions, in this case for the extension. This was built with the purpose to send a message to your external users that access your SharePoint site. You can present this message to all your SharePoint sites using the Tenant wide extension list on your Tenant App Catalog. You… Continue Reading David Ramalho’s...

Read More
Check all SharePoint sites collections with App Catalog active
Oct27

Check all SharePoint sites collections with App Catalog active

Image by TeroVesalainen from Pixabay If you have SharePoint custom solutions, you can have then installed globally, on your Tenant App Catalog or on the site collection – Site App Catalog. Each time that you create the Site App Catalog, you will see that on the site collection but if you do this process for multiple sites, you may forget each one has that feature active. So today, we’ll use… Continue Reading David...

Read More
Create an Azure Web App to host HTML
Oct20

Create an Azure Web App to host HTML

Sometimes, we need to quickly create an HTML page to share some content. In this case, it was a GIT presentation that was built and I had the idea to create an Azure web app to store this information since it’s an HTML page. This will help in the case we need to share this information with anyone. I’ll explain step-by-step the process that I’ve done. This could be one of the fastest ways… Continue Reading David...

Read More