Posts

Showing posts from 2017

Validate Email Address Columns in SharePoint

=AND(      ISERROR(FIND(" ", [Email],1)),      IF(ISERROR(FIND("@", [Email],2)),          FALSE,          AND(              ISERROR(FIND("@",[Email], FIND("@", [Email],2)+1)),              IF(ISERROR(FIND(".", [Email], FIND("@", [Email],2)+2)),                  FALSE,                  FIND(".", [Email], FIND("@", [Email],2)+2) < LEN([Email])              )          )      ) ) =OR(ISBLANK([YourColumn]),AndStatementFromAbove)

Error when opening site in SharePoint Designer 2013

Image
https://www.brightwork.com/product-blog/error-when-opening-site-in-sharepoint-designer-2013#.Wd8YiWiCzDc This week we came across an interesting error which took us some time to troubleshoot. There is a lot of conflicting information on the error online so I thought I would give you my experience. The error occurs when you attempt to open a site using SharePoint Designer 2013. You receive the following.  The server could not complete your request. For more specific information, click the Details button.  Designer will also crash hand you will need to kill the task in your task manager. On a side note when you choose the details button for more specific information you are returned a blank form which is unhelpful. The solution was to enable some authentication options on the SharePoint Web Services site in iis. I enabled Anonymous Authentication, Asp.net Impersonation, Forms Authentication and Windows authentication.  I found these were disabled...

https://blog.victorvogelpoel.nl/2014/02/03/powershell-recreate-sharepoint-web-services-web-application-bindings/

# Recreate web bindings for the SharePoint 2013 webservice webapp "SharePoint Web Services" # Victor Vogelpoel Feb 2013   $webappName = "SharePoint Web Services"   if (!( Get-WebBinding -name $webappName -protocol "https" -port 32844)) {    New-WebBinding -name $webappName   -ip "*" -port 32844 -protocol "https" }   # Bind SharePoint's own "SharePoint Services" certificate to the webbinding for HTTPS 32844 $b = Get-WebBinding -name $webappName -protocol "https" -port 32844 if ( $b ) {    $cert = get-childitem cert:\\localmachine\sharepoint | where { $_ .subject -match "^CN=SharePoint Services" }    if (! $cert )    {      throw "Cannot find `"SharePoint Services`" certificate in SharePoint certificate store"    }      [void] $b .AddSslCertificate( $cert .ThumbPrint, "SharePoint" ) } else {    thro...