Category Archives: Uncategorized

How to get a list of all SharePoint list names that were Customized with PowerApps?

Summary The SharePoint List can be customized. It is as shown here. But question is how to find out all the list names which are customized for PowerApps? Answer It is very simple, I saw multiple places and I want … Continue reading

Posted in Uncategorized | Leave a comment

How to take an action in Power Automate only when certain field’s value have changed?

Summary Here is the scenario, there is a list named “OrderList” with the following five fields. The end users change any of these fields except Order Status. The Order Status field is changed externally. Field Name Field Type OrderID Number … Continue reading

Posted in Uncategorized | Leave a comment

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

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 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 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 create HTML table for Get Items in Power Automate?

Summary A question from user is that how to send multiple pending items from a list in an HTML table format. The desired results in email is the following with ID, Title and Clickable link item. Step by Step Solution … Continue reading

Posted in Uncategorized | 1 Comment

How to create Power Automate flow which can be manually triggered?

Problem It is simple to create a flow for ‘when item created or modified’ triggers. But the customer raise following questions. How to create a Power Automate flow which can be manually triggered? How can end user pass inputs to … Continue reading

Posted in Power Automate, Uncategorized | Leave a comment