Find and Replace User ID in SharePoint InfoPath Forms using PowerShell

Requirement: Replace User IDs in InfoPath Forms. Little background: A particular user’s User account changed in Active directory and in SharePoint we ran Move-SPUser cmdlet to accommodate the user’s SAM account name change. However, There are many InfoPath form libraries with bunch of InfoPath forms in it – with old user id….

Read more

Get All List and Libraries Inventory of a SharePoint Site Collection using PowerShell

Requirement: Get All Lists and Libraries Inventory of a SharePoint Site Collection PowerShell to Get Site Collection List and Library Inventory: Report Output:  Get Inventory for All Site Collections in a Web Application Before running the script, make sure you add a web application user policy with Full control for the web…

Read more

SharePoint Online: PowerShell to Download All Files from a Document Library

Requirement: PowerShell to download all files from a SharePoint Online document library. How to Download a Document Library in SharePoint Online? To download all files from a SharePoint Online document library, Navigate to your SharePoint Online document library >> Select all Files and folders Click on the “Download” button from the toolbar….

Read more

SharePoint Online: Get Content Type Inventory Report using PowerShell

Requirement: SharePoint Online PowerShell to get content types report. SharePoint Online: Get Content Types using PowerShell Let’s get all content types of a SharePoint Online site using PowerShell and export them to a CSV file This script generates a CSV file with all content types from the given site : Generate Content…

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

How to Use Choice Field in Lookup Columns in SharePoint?

Problem: Could not create lookup columns on Choice field in SharePoint list! Solution: Not all column types are supported in lookup column. Supported column types are: Single line of text,  Number, Date and Time,  Calculated (Single Line of text),  External Data So, what’s the trick? Well, in the parent lookup list, Create…

Read more

SharePoint Online: Update Choices in Choice Field using PowerShell

Requirement: Update choice field choices in SharePoint Online using PowerShell SharePoint Online: PowerShell to Update Choice Field If you want to append to existing choices, use: This adds value to choice field’s existing choices. PnP PowerShell to Add Choice to a Choice Column in SharePoint Online Here is my another post on…

Read more

SharePoint Online: Create a Document Library or List with New Experience UI using PowerShell-CSOM

The new list and library experience in SharePoint Online improves the user experience by providing many features such as navigation, fast response, mobile UI, easier to use, etc. You can switch between classic & new experiences anytime. Here is the PowerShell-CSOM script to create a document library in SharePoint online with new…

Read more