Custom Quick Edit Button

To add a custom Quick Edit button to a page or view, add a Script Editor Web Part and embed the following code. Make sure you change the number in [WPQ2SchemaData] to the ID of the Web Part you want to Quick Edit. You can find that by inspecting the list or library Web Part using …

Internal Column Names

Document Library Fields: Display Name Internal Name GUID Type ID ID {1d22ea11-1e32-424e-89ab-9fedbadb6ce1} Counter Content Type ID ContentTypeId {03e45e84-1992-4d42-9116-26f756012634} ContentTypeId Content Type ContentType {c042a256-787d-4a6f-8a8a-cf6ab767f12d} Text Created Created {8c06beca-0777-48f7-91c7-6da68bc07b69} DateTime Created By Author {1df5e554-ec7e-46a6-901d-d85a3881cb18} User Modified Modified {28cf69c5-fa48-462a-b5cd-27b6f9d2bd5f} DateTime Modified By Editor {d31655d1-1d5b-4511-95a1-7a09e9b75bf2} User Has Copy Destinations _HasCopyDestinations {26d0756c-986a-48a7-af35-bf18ab85ff4a} Boolean Copy Source _CopySource {6b4e226d-3d88-4a36-808d-a129bf52bccf} Text Approval Status …

Audit Web Part Locations

Through PowerShell, you can export a csv list of every single app and web part and the URLs where they exist. This is useful for keeping track of where apps are visible and who has access to them. The script will prompt you for the URL. Enter the entire URL of the top site collection site. For …

Excel 2016 – “We didn’t find anything to print.”

Error message: "We didn't find anything to print." Symptoms and Testing: Opened an Excel document we use as a template from SharePoint and saved it as a new document. Tried to print the new document and received the message "We didn't find anything to print." in the print preview pane. Tried to print the original template …

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 …

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 …

Hidden User List

There's a hidden User List that shows all users brought over by the User Profile Sync service. You can even edit the view to include different columns such as User name, Title, Department, etc. Just add this path to end of your top level site's URL. /_catalogs/users/simple.aspx  

Write PowerShell Output To Text File

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.

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 …

Filter Items By First Letter

Copy the following JavaScript into notepad and save it as a .txt file. Upload this text doc to the Site Assets library. Create a calculated column on the library you want to filter and name it "FL". Add this to the Formula field: =IF(ISNUMBER(INT(LEFT(Title,1))),"0-9",LEFT(Title,1)) Add a Content Editor web part to the page and open …