Update List/Library Columns With External Content Type Columns

Scenario: You have a column on a custom list or library that needs to be back-filled with data from an External Content Type (ECT). Solution: Create a list from the ECT and use PowerShell to update your custom list's column with the ECT's list column. Creating a list (assuming you already connected an ECT): Open SharePoint Designer 2013 … Continue reading Update List/Library Columns With External Content Type Columns

Update All List Items Using PowerShell

Scenario: You added a new column and need to update that column for every item in a list or library. Solution: Here is an example PowerShell script that can be used to update one or more columns for every single item in a list. Remember: change $WebURL to the URL of the site or subsite … Continue reading Update All List Items Using PowerShell

Unlock Documents With PowerShell

One of my users was constantly getting locked out of his own documents. Upon saving a document, he would receive the following error: "The file "filename" is locked for exclusive (or shared) use by "his username"" The issue was that his user only had "contribute" permissions. While that should be enough, he needed "edit" permissions to avoid … Continue reading Unlock Documents With PowerShell