Category Archives: Technical Stuff

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 | 1 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 | 5 Comments

How to get raw data from PFX certificates?

Posted on November 15, 2021 by Pankaj

Summary This article will show the step-by-step PowerShell commands to read the raw data from the certificate. Prerequesite is you need to create a sample PFX file. It is very easy to create such files using the PnP Powershell module. … Continue reading →

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

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

Posted on November 7, 2021 by Pankaj

Application Lifecycle Management (ALM) for Power Platform (PP) 1 of 3 Application Lifecycle Management (ALM) for Power Platform (PP) 3 of 3 You will have two build pipelines and one release pipeline. 1. Create two build pipelines Follow the following … Continue reading →

Posted in Power Apps, Power Apps, Power Automate | 1 Comment