How to Enable-Disable Comments in SharePoint Online List?

The new comments feature introduced in SharePoint Online modern lists allows users to comment on SharePoint Online list items. Disable Comments in SharePoint Online List Items Although comments in SharePoint Online list items is a great new feature, in some scenarios you may want to hide it! E.g. It may cause confusion…

Read more

SharePoint Online: Get List Item Count using PowerShell

Requirement: Get list item count in SharePoint Online using PowerShell. How to Get List Items Count in SharePoint Online? The “Site Contents” page in SharePoint Online gives you the number of items in each list and library along with the name, type, and last modified date information. (URL: https://<tenant>.sharepoint.com/_layouts/Viewlsts.aspx) SharePoint Online: PowerShell…

Read more

SharePoint Online: PowerShell to Read List Items

Requirement: PowerShell to read list items in SharePoint Online SharePoint Online: PowerShell to Read List Items You can read SharePoint Online list with PowerShell in these three simple steps: Step 1: Connect to SharePoint Online Site To start with, we need the connection context to the SharePoint Online site.   Step 2:…

Read more

SharePoint Online: Delete All Unique Permissions from a Site Collection using PowerShell

Requirement: Remove unique permissions from a SharePoint Online site collection and restore permission inheritance from the parent. PowerShell Script to Restore Permission Inheritance in SharePoint Online SharePoint Online allows us to manage permissions at a more granular level when we need unique permissions to objects such as subsite, list, folder, or list…

Read more

SharePoint Online: Find and Delete Duplicate List Items using PowerShell

Requirement: Find and Delete Duplicate Items in SharePoint Online list using PowerShell Find Duplicate Rows in a SharePoint Online List using PowerShell Let’s find duplicate items in “Projects” list in SharePoint based on the column: ProjectName. This gets all list items with the same “ProjectName” value found on the list. PowerShell to…

Read more

SharePoint Online: Grant Permission to List Item using PowerShell

Permissions are hierarchical in SharePoint from the Top Site collection till the List Item level. When items are created in a list or library, they inherit the permissions of that list or library. However, This inheritance can be broken and permissions can be applied directly to the items. To set unique permissions…

Read more

SharePoint Online: Export Permissions of a Site, List, Item using PowerShell

Requirement: Export permissions applied on a particular SharePoint Site, List or List Item to CSV report. PowerShell to Export Permissions of a Site, List, List Item in SharePoint Online: This PowerShell script extracts and exports Immediate (not on any underlying objects) permissions of the given object. E.g. get list permissions. This exports…

Read more

SharePoint Online: PowerShell to Loop Through List Items

Requirement: SharePoint Online PowerShell to Loop through List Items Make sure you have SharePoint Online Client SDK downloaded and installed in your machine before running the script: https://www.microsoft.com/en-us/download/details.aspx?id=42038 PowerShell to Loop through List Items in SharePoint Online Here is a basic example for iterating through each list item in a SharePoint Online…

Read more

SharePoint Online: Create List Item based on Specific Content Type

Requirement: Add list item with specific content type in SharePoint Online. How to Add a New List Item of a specific content type in SharePoint Online? Say we have a customized content type “Business Contacts” for the contacts list and want to add a new item of the given content type. To…

Read more