Category Archives: SharePoint

How to download ‘ALL’ files from a very large document library?

Summary My customer had a large document library on SharePoint Online with a deep folder structure. The total number of items is 2.7 million (2,743,321). They want those documents downloaded to the local folder. I know, this is an actual … Continue reading

Posted in MS Graph, PnP.PowerShell, SharePoint, SharePoint 2013, Technical Stuff | Leave a comment

How to get all sites from the tenant using MS Graph API?

Summary The PnP PowerShell command Get-PnPTenantSite to get all sites from the tenant takes longer time. Additionally, it does not have asynchronous ways to get the information in the Azure Durable Function. This article uses the MS Graph API List … Continue reading

Posted in MS Graph, SharePoint | Leave a comment

How to hide welcome message for an empty SharePoint List?

Summary Create a new custom list, you will notice this new list will have the following message as shown below. An image.. + “Welcome to your new list” + “Select the New button to get started” This post should help … Continue reading

Posted in SharePoint, Technical Stuff | 1 Comment

How to turn on versioning on ALL document libraries for a site?

Summary The requirement is to turn on versioning for all site document libraries, including subsites. Also, the Major version number should be 500. The following Set-PnPList command can be used to set the Versioning and Major version as 500 for … Continue reading

Posted in PnP.PowerShell, SharePoint | Leave a comment

How to get SharePoint audit reports using Office 365 Management APIs?

Summary The following are the customer concerns with the SharePoint sites on Microsoft 365 cloud regarding audit reports. SPO site collection admins do not receive the same GUI presentation for site audit reports that were available on the SharePoint on-premises. … Continue reading

Posted in PnP.PowerShell, SharePoint 2010, SharePoint 2013, Technical Stuff | 1 Comment

Application Lifecycle Management (ALM) for Power Platform (PP) 3 of 3

Summary This is the final part of the three-part blog post. Part1 and Part2 posts were focused on the basic settings for the Classic UI mode pipeline setup. In this post, I will explain more advanced, modular, and factory pattern … Continue reading

Posted in Power Apps, Power Apps, Power Automate, SharePoint, Technical Stuff | 1 Comment

How to get a list of Site Collection Admins for a SharePoint site?

Summary My customer had a requirement to get the list of Site Collection Admins (SCAs) for any site within the tenant for anyone in the organization. The need of the user is to find additional information from the SCA. This … Continue reading

Posted in Azure, PnP.PowerShell, SharePoint | Leave a comment

How to automate and govern the “Sites.Selected” permissions using a custom tool?

Summary Earlier, I posted an article regarding the “Sites.Selected” MS Graph permission to create the granular permissions for sites. The following is the link for the article. How does the MS Graph “Sites.Selected” permission work for granular permissions for SPO … Continue reading

Posted in Azure, PnP.PowerShell, SharePoint | 2 Comments

How to resolve “The attempted operation is prohibited because it exceeds the list view threshold.” for Remove-PnPWeb?

Summary A customer got the following error for removing a sub-site. Clearly, the issue was due to a large list or lists present in the sub-site. Since the entire subsite needs to be deleted with the large list, to eliminate … Continue reading

Posted in SharePoint, SharePoint 2010, SharePoint 2013 | Leave a comment

How does the MS Graph “Sites.Selected” permission work for granular permissions for SPO sites?

Summary To provide granular access for the sites the Azure Access Control (ACS) was used in the past. The app id and secret can be created using the add-ins, more info is described here. Note: Please check ACS retirement info. … Continue reading

Posted in PnP.PowerShell, SharePoint | 7 Comments