Hide view in Microsoft Lists
Photo by Brando Louhivaara on Unsplash Microsoft Lists views are powerful, and you can adjust them as your need. You can have basic ones for regular users and more advanced ones, for instance for the admins of the site. Obviously, all the views are available for all the users which will have access to them. However, a few weeks ago I found that you can hide those views. The… Continue Reading David Ramalho’s Article on...
Create folders on SharePoint Document Library from CSV
Photo by Maarten van den Heuvel on Unsplash There are a few options to achieve this result, you can do a PNP template, create a folder individually and that onwards, and there is a command that will create all the folders if you respect some logic which I will use here. I recommend you update your PNP PowerShell to make sure you got the same cmdlets used by the script. We will… Continue Reading David Ramalho’s Article on...
Custom View Formatting on Microsoft Lists to show Announcements
Announcements are a big part of a SharePoint landing page and there are a few options out there either using out-of-the-box webpart or you can build an SPFx webpart. A few days ago, I was looking for an example using List formatting and I couldn’t find it on the community repo. Therefore I decided to create this sample which should be available soon on the community Git Hub of List… Continue Reading David Ramalho’s Article...
How to enable your Microsoft Viva Connections Dashboard
Microsoft Viva Connection enables the users to have quick access to data and information using Microsoft Teams and with that increase the communication across your company. As you can imagine Teams relies on SharePoint to provide such experience and in order to activate this functionality you need to set up a couple of settings in SharePoint. To do this you need to set up on your… Continue Reading David...
Change a SharePoint content type using Power Automate
Photo by Javier Allegue Barros on Unsplash A few weeks ago, I need to change a content type from SharePoint into another one. There are a few alternatives to do either by using a custom solution, Power Automate and/or logic apps. The idea was when an item is created change the content type from x to y. To achieve this, you have 2 different options: When an item is created… Continue Reading David Ramalho’s Article on their...
Send a message to Microsoft Teams using Microsoft Graph in SPFx
A few days ago, I got a challenge that required me to send a message from a SharePoint page into a Microsoft Teams chat and that can be achieved using Microsoft Graph. I created a blank SPFx project and this post will go to the most important elements. You can also take a look at a sample webpart that I built using this process. First, you need to add to the package-solution.json… Continue Reading David Ramalho’s Article...
Create multiple SharePoint sites using CSV file
In a few days ago, I have been asked me to create a couple of sites and I create a simple PowerShell script using PnP Framework. Creating these sites on the SharePoint administration centre can take a while since you can only create one at the same time. If you are using a script like this will allow you to do a bit more on that also allow you to run other settings that you want...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...