Author Archives: Pankaj

About Pankaj

I am a Developer and my linked profile is https://www.linkedin.com/in/pankajsurti/

How to create Site Columns using field schema xml in Power Automate?

Summary This is a very simple blog to create site column using Schema XML. The Schema XML can be extracted with PnP.PowerShell. First manually create the Site Column on your site. After you are happy with the created fields you … Continue reading

Posted in Power Automate, Uncategorized | Leave a comment

How to setup certificate in MAG Azure Function App for PnP.PowerShell?

Summary The PnP.PowerShell supports PowerShell Core. There are few things you must do to make the PowerShell Code to work in Azure Function App. In this article, I will go through the steps by step all pre requisites. Step by … Continue reading

Posted in MS Graph, PnP.PowerShell | 3 Comments

DOs and DON’Ts for Performant PowerApps

Summary I have watched multiple MVP’s video talking about PowerApps performance. Here I want to make this as a list of DOs and DON’Ts for PowerApps performance. Limit data connections DO: Use less data connectors in your app. DON’T: Don’t … Continue reading

Posted in Uncategorized | Leave a comment

How to remove SCA users from Site Collection Admins?

Summary This is kind of similar requirement from my previous blog article. How to remove users from multiple Azure AD Groups? But in this article I will provide only the code for removing the Site collection Admins from SharePoint Site. … Continue reading

Posted in Uncategorized | Leave a comment

How to remove users from multiple Azure AD Groups?

Summary For my customer there were many Modern Team Sites in the tenant. These sites had 4 to 5 users present in the Owners group. These users were added when the sites were originally created by a automated script. But … Continue reading

Posted in PnP.PowerShell | 1 Comment

How to always return array object in PowerShell?

Summary I have a PowerShell Script, I get all items from the SharePoint list. After getting all items I want to filter by a condition so I used the Where-Object as following. All worked fine, the condition was hitting for … Continue reading

Posted in Uncategorized | Leave a comment

Get-PnPListItem errors “The attempted operation is prohibited because it exceeds the list view threshold.” for over 5,000 items.

Summary I have written Site Provisioning Engine in Azure Function using PnP.PowerShell. There is request list name “Master Site Inventory”. This list grew in size over time. The provisioning engine was working fine but it stopped working with above error. … Continue reading

Posted in Uncategorized | Leave a comment

How to create a SharePoint List using Power Automate?

Summary Many times the application I have built requires the list to be created on a Site. I found in GitHub sample app (by April Dunnam) to create this list(s) using REST call in Power Automate. I will document this … Continue reading

Posted in Power Automate | Leave a comment

How to export SharePoint List Template using PnP PowerShell?

Summary I occasionally need to duplicate SharePoint List Definition from one site to other or some time create a new list from the existing list. PnP.PowerShell can rescue using the Template methods. Get-PnPSiteTemplate Save-PnPSiteTemplate Invoke-PnPSiteTemplate Using the Get-PnPSiteTemplate you can … Continue reading

Posted in Uncategorized | Leave a comment

How to get new team creation in MS Teams using MS Graph Notification API?

Summary A colleague asked me how to get a notification when anyone creates a Team on MS Teams? The answer is pretty simple you would use the MS Graph Notification API. There is an MS Learn session here. What I … Continue reading

Posted in MS Graph | Leave a comment