SharePoint Online: Remove a Field from List Content Type using PowerShell

Requirement: Remove a field from SharePoint list content type in SharePoint Online. How to Remove a Field from List content type in SharePoint Online? Here are the steps on how to remove a field from a content type in SharePoint Online list: Navigate to the List >> Click on Settings >> List…

Read more

Fix “MissingAssembly” Errors of Test-SPContentDatabase in SharePoint 2013 Migration

Problem:During SharePoint 2013 migration, we ran the Test-SPContentDatabase cmdlet, and the output report contains several MissingAssembly errors! Category        : MissingAssemblyError           : TrueUpgradeBlocking : FalseMessage         : Assembly [DealEventEventhandler, Version=1.2.6.0, Culture=neutral, PublicKeyToken=b4122bae67581526] is referenced in the database [wss_content], but is not installed on the current farm. Please install any feature/solution which contains this assembly.Remedy         …

Read more

Remove a Web Part from All Pages in SharePoint Site Collection using PowerShell

Requirement: After the SharePoint migration from SharePoint 2013 to SharePoint 2016, we decided to remove a broken web part from all pages wherever it’s being used. How to Remove a Web Part from Page in SharePoint? To remove a web part from the page, you can edit the page and simply delete…

Read more

SharePoint Online: How to Add a Site Column to Content Type using PowerShell?

Requirement:  Add a site column to a content type in SharePoint Online using PowerShell. How to add a field to an existing content type in SharePoint? Site columns are reusable fields that can be added to content types, lists, and libraries. By adding site columns to your content types, you can make…

Read more

Test-SPContentDatabase: Fix MissingWebPart Issue in SharePoint 2013 Migration

Problem: MissingWebPart Issues when running Test-SPContentDatabase cmdlet on SharePoint content database during SharePoint 2013 migration project. Category                : MissingWebPartError                      : TrueUpgradeBlocking  : FalseMessage                : WebPart class [9a43cf43-4500-d748-6385-09e622f28c01] is referenced [3] times in the database [WSS_Content_Database], but is not installed on the current farm. Please install any feature/solution which contains this web part.Remedy                …

Read more

Fix MissingSetupFile Error of Test-SPContentDatabase in SharePoint Migration

Problem: Getting “MissingSetupFile” errors when you run the “Test-SPContentDataBase” cmdlet on SharePoint content databases during a migration process. [MissingSetupFile] File [Features\Feature-folder\feature-artifact] is referenced [1] times in the database [SharePoint_Content_database], but is not installed on the current farm. Please install any feature/solution which contains this file. One or more setup files are referenced…

Read more

SharePoint Online: Enable Content Types using PowerShell

As the name suggests, content type defines the type of content, such as an item or document. In a real-world scenario, A content type could refer to an invoice template, project plan document, etc. Content types provide an effective method of grouping relevant columns (metadata), document templates, workflows, and policies together and…

Read more

Test-SPContentDatabase: Cannot open database [Database Name] requested by the login. The login failed.

Problem: In a SharePoint 2013 to SharePoint 2016 migration, I got this error message on testing the content database with Test-SPContentDatabase cmdlet  to identify possible issues:“Cannot open database [Database Name] requested by the login. The login failed” Troubleshooting: If your databases are hosted on a different SQL Server or instance, other than the…

Read more

SharePoint Online: How to Hide a Column in Content Type using PowerShell?

Requirement: Hide a Column from Content Type in SharePoint Online. How to Hide a Column using Content types in SharePoint Online? Columns can be hidden at the content type or the list level in SharePoint. You can hide a column from appearing in list forms, such as: NewForm.aspx, EditForm.aspx, DispForm.asxp using the…

Read more

Power Query to Extract SharePoint List Data using Excel

Microsoft Power Query is a free add-in for Excel – Part of PowerBI that provides self-service Business Intelligence features. Let’s see how to extract SharePoint list data using Power Query for Excel. Step 1: Download & Install Power Query Add-in To start with, Download the Power Query Add-in for Excel from: https://www.microsoft.com/en-us/download/details.aspx?id=39379…

Read more