SharePointSights

Author: SteveC

  • Lock Documents Labelled with Retention Labels Marked as Records in SharePoint Online

    —

    by

    SteveC
    in ,

    PnP PowerShell Script to set Record Status to Locked We needed a PnP PowerShell script to iterate over documents in a library to automatically re-label documents with our new Retention Labels. The method SetComplianceTagWithMetaInfo is used to replace the Retention Label preserving the labelled date. We needed the method with metadata as the Retention Labels…

  • Set Retention Label with Metadata PowerShell

    —

    by

    SteveC
    in

    ListItem.SetComplianceTagWithMeta Using PowerShell PnP to set Retention Label with labelled date. Not for use in Production but handy for testing. https://learn.microsoft.com/en-us/dotnet/api/microsoft.sharepoint.client.listitem.setcompliancetagwithmetainfo?view=sharepoint-csom connect-pnponline -url <url> -UseWebLogin $context = Get-PnPContext $files = get-pnplistitem -List <ListName> $file = $files[<id>] $complianceTagWrittenDate = (Get-Date -Month 1 -Day 1 -Year 2000) $file.SetComplianceTagWithMetaInfo($labelName, $isPolicyHold, $isPolicyRecord, $complianceTagWrittenDate, $userEmailAddress, $false) $context.ExecuteQuery()

  • Create an interactive FAQ from a SharePoint 2013 List

    —

    by

    SteveC

    A couple of different teams made a similar request for an interactive FAQ. One team actually went to the effort of finding an example on the internet they wanted :D. The FAQ looks like this clicking on a Question reveals the answer. The questions are split into sections clicking on the tab reveals that section.…

  • Cannot Activate Community Site Feature

    —

    by

    SteveC

    This was an issue with a Site migrated to SharePoint 2013 from 2010.  We had exported and then imported a Publishing Site to find we could not activate the Community Site Feature. The error in ULS was Feature Activation: Threw an exception, attempting to roll back.  Feature ‘CommunitySite’ (ID: ‘961d6a9c-4388-4cf2-9733-38ee8c89afd4’).  Exception: Microsoft.SharePoint.SPException: The file is…

  • Adding a confirmation pop-up for a new List Item in SharePoint 2013

    —

    by

    SteveC

    I was recently asked if we could ask the user for confirmation when a new Item is added to a List. The user needed to confirm that that the data entered was correct when clicking Save on the form. I added a short jQuery script to the List NewForm.aspx page to overwrite the default action…

  • Two SharePoint Instances Sharing the Same Address

    —

    by

    SteveC

    This post describes a solution where a SharePoint 2010 and a separate SharePoint 2013 environment share the same address. To be clear, we are talking here about the following scenario: http://sharepoint.company.com –> resolves to 2013 instance http://sharepoint.company.com/sites/sc1 –> resolves to 2010 instance http://sharepoint.company.com/sites/sc2 –> 2013 instance http://sharepoitn.company.com/SomeSite –> either 2013 or 2010 In our case…

  • Excel Macro to Open RDC Connections

    —

    by

    SteveC

    Simple macro in Excel to open a Remote Desktop Connection to the server name or IP address in a cell. The idea here is the spreadsheet contains all the names and IP addresses of each server. Set the macro to run as shortcut with a key combination so the RDC connection will open up directly.…