Fix “Get-PnPListItem : The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.” Error

Problem: When trying to get list items from a SharePoint Online list using Get-PnPListItem cmdlet with a query parameter, I got an error message “Get-PnPListItem : The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.” Root Cause:  The requirement was to get all list items created…

Read more

Import-Module : Could not load type ‘Microsoft.SharePoint.Administration.DesignPackageType’ from assembly ‘Microsoft.SharePoint.Client, Version=16.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’

Problem: When trying to import PowerShell module for SharePoint Online with “Import-Module -Name Microsoft.Online.SharePoint.PowerShell”, got an error message: PS C:\> Import-Module -Name Microsoft.Online.SharePoint.PowerShell                  Import-Module : Could not load type ‘Microsoft.SharePoint.Administration.DesignPackageType’ from assembly ‘Microsoft.SharePoint.Client, Version=16.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c’. At line:1 char:1 + Import-Module -Name Microsoft.Online.SharePoint.PowerShell +…

Read more

Fix “Connect-SPOService : The term ‘Connect-SPOService’ 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

Problem: When trying to connect to SharePoint Online through PowerShell cmdlet: Connect-SPOService -URL https://crescent-Admin.SharePoint.com, got an error message and could not connect to SharePoint Online from PowerShell: Connect-SPOService : The term ‘Connect-SPOService’ is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name,…

Read more

Fix “You have to delete all the items in this folder before you can delete the folder” Error in SharePoint Online

Problem: When trying to delete a folder with sub-folders and files, I got an error message “You have to delete all the items in this folder before you can delete the folder” in SharePoint Online or OneDrive. You may also see the “Request was cancelled by event received. If attempting to delete…

Read more

Fix “Connect-SPOService : Current site is not a tenant administration site.” Error in SharePoint Online Management Shell

Problem: When trying to connect to SharePoint Online using SharePoint Online Management Shell, I got an error message: “Connect-SPOService : Current site is not a tenant administration site.” Root Cause and Solution: The script was trying to connect to SharePoint Online as: “Connect-SPOService -Url https://crescent.sharepoint.com”, But the problem is: It should connect…

Read more

SharePoint Online: Fix “An error occurred while enumerating through a collection: The collection has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested” in PowerShell

Problem: Error in SharePoint Online CSOM PowerShell script:“An error occurred while enumerating through a collection: The collection has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested” Root cause: Every collection must be explicitly loaded before accessing its members….

Read more

SharePoint Online: Fix “The collection has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested” Error in PowerShell

Error: The collection has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested. Root Cause: You must load the object before you are trying to retrieve its properties! Solution: Here is how the problem can be resolved: Please note,…

Read more

SharePoint Online: Fix “The remote server returned an error: (403) Forbidden.” Error in PowerShell

Error: Exception calling “ExecuteQuery” with “0” argument(s): “The remote server returned an error: (403) Forbidden.” in PowerShell scripts for SharePoint Online. Troubleshooting Checklist for 403 forbidden in SharePoint Online PowerShell: Follow this checklist to resolve Executequery 403 forbidden error in SharePoint Online PowerShell: You may have provided the credentials of another tenant,…

Read more

Excel Web Access Web Part Missing in SharePoint Online?

Problem:  Excel Web Access Web Part Missing in SharePoint Online Solution: Excel Web Access Web Part helps display an Excel workbook in SharePoint pages and it’s available only in the SharePoint Enterprise edition (and in Office 365, It’s only available on the Enterprise Plans E3 and E4). If you are using the…

Read more

Content Editor, Script Editor Web Part Missing in SharePoint Online?

Problem: Content Editor WebPart in SharePoint Online is Missing! Fix SharePoint Online Content Editor web part missing Issue: In Modern SharePoint Online sites (E.g., Group sites, Communication Sites), Self-serviced sites, and Root site, custom scripting is disabled by default! So, how to get a content editor web part in SharePoint Online? To…

Read more