David Ramalho, Author at SharePoint Tricks

Published January 12, 2020 by David Ramalho

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 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.

7 Comments

Published December 15, 2019 by David Ramalho

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.

One Comment

Published November 24, 2019 by David Ramalho

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.

2 Comments

Published November 10, 2019 by David Ramalho

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.

One Comment

Published October 27, 2019 by David Ramalho

Check all SharePoint sites collections with App Catalog active

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 a PowerShell Command to extract this information and also provide the URL that you can access to verify the information on this hidden list.

…

6 Comments

Published October 20, 2019 by David Ramalho

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 to publish something with a public URL.

One Comment

Published October 6, 2019 by David Ramalho

Microsoft Teams DND to allow specific users

Often during our daily work, we’ve notification pop-up here and there on our screens, this disturbs our concentration on certain tasks. When that happen you can miss the logic that you’re developing to complete a task. To overcome these situations, modern communication tools allow you to set your availability to “Do-not-Disturb(DND)”. But, I’ll say that it depends. There are some persons that you may want to be disturbed by.

Verify if the current user is internal or external in SPFx

In some of the SharePoint Framework solutions, it’s important to understand if the user is either or not an external user from your Office 365. With a few lines of code using the PnP.js, we can verify this.

4 Comments

Published September 15, 2019 by David Ramalho

Remove title header on SharePoint Online

When creating a new page a header with the title of the page will be shown to the user. In the current days, it’s not possible to remove that header from the page using the SharePoint interface. Today, we will share a PowerShell that allows you to remove that area from the page and some article that you can use with different options.

11 Comments

Published September 9, 2019 by David Ramalho

Add Thumbnail field in multiple SharePoint sites

Recently I have seen on the community that when you add a column with the internal name of Thumbnail, SharePoint automatically generates a preview of the document. In the post below, we’ll add this column to multiple SharePoint sites that have the list or library that you intend to have the preview of the document. This feature has been requested on the SharePoint User Voice.

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