Category Archives: Technical Stuff

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

Posted on April 28, 2022 by Pankaj

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

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

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

Posted on April 15, 2022 by Pankaj

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 do CI/CD pipelines build for an SPFX on Azure DevOps for the site collection app catalog?

Posted on March 14, 2022 by Pankaj

Summary My customer needs a way to help the developers to create CI/CD pipeline build for the developers. The customer has the Azure DevOps Server (ADOS). They need guidelines for the DevOps process for SPFx projects. The requirement is to … Continue reading →

Posted in Technical Stuff | Leave a comment

Why should you use compose versus variables in apply-to-each action?

Posted on March 11, 2022 by Pankaj

Summary If you have large Power Automate flow and you have used a lot of variables and have looping, I bet your flow performance is not good. If that is the problem, please keep reading you may benefit from this … Continue reading →

Posted in Power Automate | Leave a comment

How to add Power Virtual Agent (PVA) Bot to a SharePoint page?

Posted on February 3, 2022 by Pankaj

Summary As you know the Power Virtual Agent (PVA) is a low-code and no-code solution. It is very easy to create a Bot quickly. Now, if you want this bot on the SharePoint page. There are a few options and … Continue reading →

Posted in Technical Stuff | Leave a comment

The tenant-wide flag DisableCustomAppAuthentication in relation to Access Control System (ACS)?

Posted on February 2, 2022 by Pankaj

Summary If you have used the Access Control System (ACS) and using its APP ID and APP Secret in the PnP.PowerShell module it may not work. The Connect-PnPOnline will work fine but when I try to get any command to … Continue reading →

Posted in Technical Stuff | Leave a comment

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

Posted on January 22, 2022 by Pankaj

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?

Posted on January 16, 2022 by Pankaj

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 | 1 Comment

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

Posted on December 17, 2021 by Pankaj

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?

Posted on December 15, 2021 by Pankaj

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 | 4 Comments