SharePoint Online: Delete Alerts using PowerShell

Requirement: Delete Alerts in SharePoint Online How to Delete Alerts in SharePoint Online? How to turn off alert notifications in SharePoint Online? Well, To delete an alert from SharePoint Online, follow these steps: Login to SharePoint Online >> Navigate to Site Settings page. Unde…

SharePoint Online: Find Site Column Usage in Lists and Libraries using PowerShell

Requirement: Find a Site Column usage in SharePoint Online Site Collection SharePoint Online: PowerShell to Get a Site Column's usage in lists and libraries of a Site Collection: #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Serve…

SharePoint Online: Create Alerts using PowerShell CSOM

Requirement: Create SharePoint Alert using PowerShell How to Create Alerts in SharePoint Online? Alerts in SharePoint Online helps to track changes such as addition/changes/delete to the content E.g. Lists and libraries, pages, etc. To create an Alert for a SharePoint Online document library,…

SharePoint Online: Export Document Library Metadata to Excel

Requirement: Export SharePoint Online Document Library Metadata to a CSV file. Export Document Library Metadata to CSV using PowerShell: To export a document library's metadata into Excel, You can use: "Export to Excel" button on any SharePoint Online library. However, this func…

SharePoint Online: Remove User or Group from Folder Permissions using PowerShell

Requirement: Remove user from folder permissions in SharePoint Online. How to Remove user from folder permissions in SharePoint Online? How to restrict access to folder in SharePoint Online? To remove a user or group from SharePoint Online Folder's permissions, follow these steps: Naviga…

How to Create OneDrive for Business Site Collections using PowerShell?

Requirement: Pre-Create OneDrive for Business Sites using PowerShell. OneDrive for Business is a Microsoft's cloud-based storage solution that lets users to store and work on files that are personal to them. Its similar to a SharePoint Online document library with full control granted to u…

SharePoint Online: Remove List from Search using PowerShell

By default, all SharePoint Online lists and libraries appear in search results. There are some cases you want to remove a particular list's contents from appearing in search results. Say e.g. You want to hide images library's content from appearing in search results.   How to Remove a l…

SharePoint Online: Read / Update Person or Group Field (People Picker) Values using PowerShell

Requirement: Get or Set "Person or Group" Field Values in SharePoint Online using PowerShell. Person or Group field provides searchable list of people and groups when they add or edit an item. It acts like a auto complete field when you type the first 4 character of the user names. H…

SharePoint Online: How to Disable Microsoft Flow (Power Automate) in Lists and Libraries?

Requirement: Disable flow in SharePoint Online. Microsoft Flow is a great tool to automate business processes by building workflows . In some cases, to take control over customization, You may want to disable Flows by hiding the "Flow" button in modern lists and libraries in SharePoi…

Create Search Service Application in SharePoint 2016 Multi-Server Farm using PowerShell

The Search Service Application in SharePoint provides search functionality, as its name implies. We have to use PowerShell scripts to configure search service application from SharePoint 2013 on wards as there is no user interface to configure the Search topology from SharePoint Central Admin - a…

Fix SharePoint Online "The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator." in PowerShell

Problem: When trying to get list items from a SharePoint Online list through PowerShell, got this error message: Exception calling "ExecuteQuery" with "0" argument(s): "The attempted operation is prohibited because it  exceeds the list view threshold enforced by the adm…

SharePoint Online: Rename Files in Document Library using PowerShell

Requirement: Rename files in SharePoint document library using PowerShell How to Rename a Document in SharePoint Online? Renaming a file in the SharePoint Online document library is pretty straight forward. The quickest way to rename a document is: Right-click on your desired File and sele…