Take control of files created on SharePoint that are not published
Jan10

Take control of files created on SharePoint that are not published

Did you know that if you’re a SharePoint Site collection owner you cannot see all the pages created? A few days ago, I notice that I should have a certain number of pages on the Site Pages library (80 or something) but only a few appear for my user. You can verify how many files you have on the particular library on the Site contents of your site. This happens because the page was… Continue Reading David Ramalho’s...

Read More
How to enable/disable the comments on SharePoint Lists
Dec13

How to enable/disable the comments on SharePoint Lists

One of the recent updated for Microsoft Lists / SharePoint List Online was the possibility to comment on each item of a list that allows you to interact with other users for that particular item. This is a great feature which will be helpful to many organization and will help users to extend their collaboration. However, it’s possible that some organization may want to disable or enable… Continue Reading David...

Read More
Verify all the SharePoint sites that belong to Microsoft Teams Private Channels
Nov22

Verify all the SharePoint sites that belong to Microsoft Teams Private Channels

When creating a Microsoft Teams private channel by default, it creates a brand new SharePoint site which will store all the information related to that private channel. This is a special site that contains a couple of settings. I will leave at reference an article that you can check to check those settings. I will share some PnP PowerShell commands that will help us to get this… Continue Reading David Ramalho’s Article on...

Read More
How to know who view files/pages on SharePoint
Nov01

How to know who view files/pages on SharePoint

A couple of days ago I come across a SharePoint feature that is very useful to check who view the file that is a SharePoint document library. This feature can be very useful to check who viewed that particular file. This feature will allow you do understand you saw your meeting records if you’re saving then on SharePoint.  Usually, that feature is deactivated on all the sites…. Continue Reading David Ramalho’s Article on...

Read More
Remove Microsoft Teams Deleted Teams
Oct26

Remove Microsoft Teams Deleted Teams

A few weeks ago, I was playing with the Microsoft Teams creation using Microsoft Graph endpoint and as expected, a couple of teams were created because of that. Using these endpoints can be extremely useful to automate a process on our organization. However, when you’re doing this it will create a lot of “testing” teams. This is also applicable to Teams that are not… Continue Reading David Ramalho’s Article on their blog...

Read More
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

SCOTtish summit 2021

On February the 27th Scottish Summit 2021 will come to you as a virtual event. With over 250 sessions from all Microsoft technologies. You need to register for your FREE ticket and download the Scottish Summit App to see all the great sessions.