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: Find All Lists with Unique Permissions using PowerShell

Requirement: Get All Lists and Libraries with Unique Permissions using PowerShell How to check if a list is using Unique permissions or inheriting permissions from the parent? To get if list or library has unique permissions, follow these steps: Navigate to the list and then go to List or Library Settings. On…

Read more

SharePoint Online: How to Hide “Create Site” Link in SharePoint Start Page?

Requirement: Disable Create site link from SharePoint Online home page! The “Create Site” link in SharePoint Online Home (https://crescenttech.sharepoint.com/_layouts/15/sharepoint.aspx) helps end users to create their own modern SharePoint sites. We got a requirement to disable this “Create Site” Link as a policy decision. How to Hide the “Create Site” Link in SharePoint…

Read more

SharePoint Online: How to Use CAML Query in PowerShell?

Requirement: Use CAML Query with PowerShell in SharePoint Online. CAML is an XML-based query language, It stands for Collaborative Application Markup Language and used to query against items from SharePoint lists and libraries. CAML Query Elements and Operators: Here is the commonly used elements and operators in CAML queries. Operator Meaning Eq…

Read more

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 the Site Settings page. Under the “Site Administration” section, click on the…

Read more

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: This script gets a particular site column’s usage in lists and libraries and prints the finding as below:

Read more

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, follow these steps: Go to your SharePoint Online site,…

Read more

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 functionality doesn’t give you details such as: Number of Versions, Filesize,…

Read more

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: Navigate to your SharePoint Online list or library where the…

Read more

How to Create OneDrive for Business Site Collections using PowerShell?

Requirement: Pre-Create OneDrive for Business Sites using PowerShell. OneDrive for Business is Microsoft’s cloud-based storage solution that lets users store and work on files that are personal to them. It’s similar to a SharePoint Online document library with full control granted to users so that they can add, update, and delete files…

Read more