How to Invite a Guest User to Azure AD for SharePoint Online?

Requirement: Invite guest user to SharePoint Online Azure AD. How to invite a guest user to SharePoint Online Azure Active Directory? SharePoint Online allows us to invite external users to collaborate. However, If the Sharing policy for your SharePoint Online tenant or site is set to “Existing guests – Only guests already…

Read more

SharePoint Online: Convert Classic Team Site to Communication Site

Requirement: Convert Classic Team Site to Communication Site in SharePoint Online. SharePoint Online: How to Convert Classic Team Site to Modern Communication Site? Communication sites are ideal to broadcast news, announcements, reports, etc. to broader audiences such as teams or the entire organization. The responsive, dynamic site design delivers great experiences for…

Read more

How to Disable Export to Excel Button in SharePoint Online?

Requirement: Disable Export to Excel in SharePoint Online. How to Disable Export to Excel in SharePoint Online? A business team wanted to remove the ability to export list data into Excel. How do I disable or hide the “Export to Excel” button in modern SharePoint Online lists? Option 1: Create a Custom…

Read more

Download SharePoint Documents from CSV File using PowerShell

Requirement: Download files in SharePoint document library from a CSV file to local disk. PowerShell Script to Download Documents from SharePoint : My CSV has “URL” and “FileName” columns in it, and here is the PowerShell to download SharePoint documents from a CSV file to a local disk or network drive. The…

Read more

SharePoint Online: Monitor Site Collection Storage Usage with PowerShell

Requirement: Monitor SharePoint Online storage metrics and Send E-mail on current usage. SharePoint Online: Storage Usage Report using PowerShell By default, SharePoint Online storage management is set to “Automatic” and all storage allocations are automatically managed from the central pool of storage. However, In your environment, if the storage management option is…

Read more

Fix “Get-SPWeb : The term ‘Get-SPWeb’ is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.” Error in PowerShell

Problem: When trying to run a PowerShell script in SharePoint, got this error Get-SPWeb : The term ‘Get-SPWeb’ is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and…

Read more

Fix “A compliance policy is currently blocking this site deletion” Error in SharePoint Online

Problem: When trying to delete a SharePoint Online site collection, getting an error message “Can’t Delete Site: A compliance policy is currently blocking this site deletion”. Also, in SharePoint Admin center, we get an intimation saying “This site has a compliance policy set to block deletion.”  Root Cause: This is because retention…

Read more

Find All InfoPath Form Libraries in SharePoint Online using PowerShell

Requirement: Find All InfoPath Form libraries in SharePoint Online How to Find All InfoPath Form Libraries in SharePoint Online Site? To get all form libraries in the SharePoint Online site collection, use the below PowerShell script. This script checks if the template ID of any list is 115 to decide it’s an…

Read more

SharePoint Online: Get Subsite Permission Report using PowerShell

Requirement: PowerShell script to get subsite permissions in SharePoint Online How to Get Subsite Permissions in SharePoint Online? To get permissions of a SharePoint Online subsite, Click on Setting gear >> Click on the “Site Permissions” link Click on “Advanced Permission Settings” in the site permissions page This gives you all users…

Read more

SharePoint Online: Bulk Update Metadata Properties from a CSV File using PowerShell

Requirement: Bulk Update Metadata of Multiple Documents from a CSV in SharePoint Online. SharePoint Online: PowerShell to Bulk Edit Metadata Properties from a CSV File We’ve a document library with a 100s of documents in several sub-folders and wanted to bulk update metadata of all those documents. While quick edit is one…

Read more