SharePoint Online: CAML Query with IsNull and IsNotNull Examples in PowerShell

May 30, 2019    , , , ,
Requirement: Get all items from a list where a particular filed value is Null. SharePoint Online: CAML Query IsNull Example Here is the example of how IsNull operator can be used in CAML: #Parameters $SiteURL = "https://crescent.sharepoint.com/sites/marketing/" $ListName= "Doc…

Find All Office 365 Group Owners using PowerShell

May 28, 2019    ,
Requirement: Get Office 365 Group Owners How to Get Office 365 Group Owners? To get Office 365 group owners from Microsoft 365 admin center, Login to the Microsoft 365 Admin Center site: https://admin.microsoft.com Expand Groups and Click on Groups link in the left navigation.  The groups…

Fix "Connect-AzureAD : The term 'Connect-AzureAD' is not recognized as the name of a cmdlet, function, script file, or operable program." Error

May 28, 2019    , ,
Problem: When trying to connect to Azure AD from PowerShell, using: "Connect-AzureAD" cmdlet, received an error: "Connect-AzureAD: The term 'Connect-AzureAD' is not recognized as the name of a cmdlet, function, script file, or operable program." Solution: Instal…

SharePoint Online: Get Files and Sub-Folders Count on Each Folder in a Document Library using PowerShell

May 25, 2019    , , , , , ,
Requirement:  Get the count of files and sub-folders at each folder in a SharePoint Online document library. How to Get the Number of Files and Sub-Folders at Each Folder of a Document Library? When a document library has multiple folders, sub-folder and files, you can get the number of files …

SharePoint Online: How to Add External User using PowerShell?

May 20, 2019    , , , , , ,
Requirement: Add External User to SharePoint Online using PowerShell. How to Add an External User in SharePoint Online? SharePoint Online provides an excellent solution when you have to share any site, list, library, or document with users outside your organization such as vendors, clients, o…

SharePoint Online: Change UI to Modern Experience or Classic Experience using PowerShell

May 19, 2019    , ,
Requirement: Change Classic Experience to Modern Experience and Modern UI to Classic in SharePoint Online. How to Activate Modern Experience from Classic? The modern experience in SharePoint Online lists and libraries is faster, mobile friendly and easier to use.  It brings new functionalities…

SharePoint Online: Error Handling with Try Catch in PowerShell

May 13, 2019    , , ,
One of the best practices while writing PowerShell scripting is handling potential errors to ensure smooth execution of the script when something goes wrong. Who can guarantee a script can run correctly in different environments every time? Error handling in PowerShell is made easy with try-…

SharePoint Online: How to Disable "Delete this list"?

May 08, 2019    , , , , , ,
Requirement: Disable delete on a SharePoint Online List or Document Library. How to Disable Delete options for List or Document Library in SharePoint Online? We have a requirement to disable any accidental deletes on certain SharePoint Online lists and document libraries that are provisioned…

SharePoint Online: Get Attachments Report in a List using PowerShell

May 08, 2019    , , , , ,
Requirement: Generate a Report to get an Inventory of all Attachments in a SharePoint Online List. PowerShell to Get All Attachments in a SharePoint Online List This PowerShell extracts data from all attachments, such as Number of Attachments, Size, Filename, URL, etc. to a CSV file. Import-…

SharePoint Online: How to Set Item-Level Permissions in a List?

May 07, 2019    , , , , , ,
Requirement: Set Item Level Permission in SharePoint Online List. What is Item-level Permission in the SharePoint Online List? When you want to restrict all items in a list either with read or edit access to only those who created that item, You can utilize Item-level permission settings in Sh…

SharePoint Online: Create Multiple Subsites from a CSV File using PowerShell

May 06, 2019    , , , ,
Requirement: Create Multiple sub-sites in SharePoint Online using PowerShell. SharePoint Online: How to Create Multiple Subsites using PowerShell? Creating a subsite in SharePoint Online with PowerShell is explained in my other article:  How to Create a Subsite using PowerShell in SharePoint O…

SharePoint Online: Get List Experience Settings using PowerShell

May 06, 2019    , , , , ,
Requirement: Get List Experience Settings in SharePoint Online using PowerShell. How to Get SharePoint Online List Experience? To get list experience configuration of a list or library in SharePoint Online, Navigate to the list or library settings >> Click on the "Advanced Setting…

How to Assign User to SharePoint Online Administrator Role in Office 365?

May 06, 2019    , , , ,
Requirement: Set SharePoint Online Administrator As the SharePoint Online administration is done by people other than Tenant Admin (or Global Administrator!) in most of the companies, You may need to delegate roles in Office 365, so that users get administrative privileges to specific services …

SharePoint Online: Copy Values from One Column to Another using PowerShell

May 04, 2019    , , , ,
Requirement: Copy values from one column to another column in SharePoint Online list. PowerShell to Copy List Column Value in SharePoint Online To copy values between columns in the same list, use this PnP PowerShell script: #Parameters $SiteURL = "https://crescent.sharepoint.com/sites/p…

SharePoint Online: Change Column Order in List using PowerShell

May 01, 2019    , , , , , ,
Requirement:   Change Column Ordering in SharePoint Online List. How to Change the Column Order in SharePoint Online? To change the order of columns in a SharePoint Online list or library, do the following: Navigate to the list or library where you want to reorder the columns. Click on Sett…

Powered by Blogger.