SharePoint Online: Grant Site Owner Permission to a User with PowerShell

Requirement: Grant Site Owner Permissions to a User in SharePoint Online How to Grant Site Owner Permissions to a User in SharePoint Online? By adding people to the SharePoint Online site owners group, they can manage the site and perform typical site administration activities such as setup site branding and structure, add…

Read more

SharePoint Online: Get File Size using PowerShell

Requirement: Get file size in SharePoint Online using PowerShell How to Get the File Size in SharePoint Online? To get the size of a file, you can follow these approaches:  Edit the list view of the document library and include the “File Size” column in it Go to the “Storage Metrics” page,…

Read more

SharePoint Online: How to Get a List using PowerShell?

Requirement: PowerShell to Get a List in SharePoint Online. SharePoint Online: PowerShell to Get a List Here is how to access SharePoint Online list programmatically using PowerShell. Let’s get a list by title: You can use this script to get any list or library from a given SharePoint Online site. PnP PowerShell…

Read more

How to Add Twitter Feed in SharePoint Online?

Requirement: Add Twitter feed to SharePoint Online. How to Add Twitter Feed to SharePoint Online? You may want to add Twitter feeds that are relevant to your audience on your SharePoint Online site. In the past, we used Script Editor Web Part for embedding Twitter code into SharePoint. Well, not anymore in…

Read more

Fix “There was an error while attempting to get the themes” Error in SharePoint Online

Problem: When trying to change site theme in SharePoint Online through “Settings >> Change the Look >> Theme” got an error message “There was an error while attempting to get the themes”. Workaround: When you do multiple changes to the site’s look and feel like changing header, icons, and themes in one…

Read more

How to Embed Excel Spreadsheet to Modern SharePoint Online Pages?

Requirement: Display Excel Spreadsheet in SharePoint Online. SharePoint Online: How to Embed an Excel Spreadsheet? In modern SharePoint Online sites, we don’t have Excel Web Access Web Part that integrates an Excel sheet into SharePoint pages. However, we can use the Embed web part to display an Excel spreadsheet in SharePoint Online:…

Read more

SharePoint Online: Link to Force Download a Document Instead of Open

Requirement: Force download a file instead of opening in SharePoint Online. SharePoint Online: URL to Document Download Instead of Open Documents linked in SharePoint Online pages, navigation menu, lists, etc. opens in the browser (or in client application!) directly either in Read-only mode or in Edit mode, based on user permissions. What…

Read more

SharePoint Online: How to Register a Never Expiring App ID Secret with Azure AD?

Requirement: Register a never expiring App for SharePoint Online using Azure AD. Any App ID (or Client ID) registered through SharePoint Online has an expiry date of 1 year by default. How do I register an App ID that’s never expiring? Well, You have to register the App through Azure AD! Here…

Read more

SharePoint Online: Upload Large Files using PowerShell

Requirement: Upload large files to SharePoint Online using PowerShell PowerShell to Upload a large file to SharePoint Online If you try to upload files with > 250 MB file size to SharePoint Online using CSOM Files.Add method, or PnP PowerShell Add-PnPFile methods you’ll end up in errors: “The remote server returned an…

Read more

SharePoint Online: How to Disable Subsite Creation?

Requirement: Disable subsite creation in SharePoint Online. How to disable subsites in SharePoint Online? The traditional information architecture in SharePoint site collections and subsites is site collections have a top-level site and may have a number of sub-sites underneath. However, the recent recommendation from Microsoft is to avoid subsites and create site…

Read more