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
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
Here is an example of how I use the Write-Output command to log every update my PowerShell script made. The $output variable needs to wrap the collection of items being updated (the foreach statement) if you want to combine all outputs into the same file. Then use the Write-Output function to state what needs to logged.
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
Sometimes your users don't need to see every single SharePoint library when they're in file explorer. Here is a bit of PowerShell that will hide necessary libraries from file explorer. Make sure you change the URL to your SharePoint site's URL and the folder name to the library you want to hide.