Author: Andrew Toh
Calculated field to split File Path
Requirement: Created a calculated field in a SharePoint list/library to split a filepath and store the first 3 folder levels in 3 separate metadata fields. For example: C:\Users\Admin\Desktop\test.txt Level 1 Level 2 Level 3 Users Admin Desktop Solution Assuming MigrationSourceURL is the column in SharePoint that stores the file path: Level 1 formula =IF(MigrationSourceURL="","N/A",LEFT(RIGHT(MigrationSourceURL,LEN(MigrationSourceURL)-3),SEARCH("\",RIGHT(MigrationSourceURL,LEN(MigrationSourceURL)-3))-1))=IF(MigrationSourceURL="","N/A",LEFT(RIGHT(MigrationSourceURL,LEN(MigrationSourceURL)-3),SEARCH("\",RIGHT(MigrationSourceURL,LEN(MigrationSourceURL)-3))-1)) Level […]
Continue Reading...Get list of Site Collection Admins (SCA) using PowerShell
Requirement Generate a list of SCAs across all your SharePoint site collections. Solution function Get-SCA { param($site) $link = $site+"/_layouts/mngsiteadmin.aspx" $result = Invoke-WebRequest $link -UseDefaultCredentials $value = $result.AllElements | Where id -eq "ctl00_PlaceHolderMain_ctl00_PeopleEditorAdmins_OriginalEntities" | Select value $value = $value.value.split(">") | where { $_ -match "displaytext" } $value = $value.split("`"") | where { $_ […]
Continue Reading...Automatically download versions of a file in SharePoint to your computer
Requirement Download all versions of a file in SharePoint to a local folder on your computer. Solution Use the PowerShell script below to do this. You can run this script as a normal user as long as you have access to the GetVersions webservice method. Usage: Run the script in PowerShell or PowerShell ISE. Parameters: […]
Continue Reading...SharePoint 2010 Service Pack 2 no longer allows unresolvable e-mail addresses
Problem: Before Service Pack 2, you could specify an e-mail address in the cc’ field of a workflow form. After installing Service Pack 2, this is no longer possible and you will get the following error message and will not be able to submit the form: No exact match was found. Click the item(s) that […]
Continue Reading...SharePoint 2010 Service Pack 2 breaking scripts using SPServices / jquery
Problem: We have some scripts that use jQuery Library for SharePoint Web Services. After installing Service Pack 2 for SharePoint 2010, several of the scripts stopped working. Cause: We found that the script renamed the form control titles if the field was a mandatory field. For example: If you have a required /mandatory field called […]
Continue Reading...