Louis-Charles Gagnon

Sometimes after deployment or data manipulation, a list is left not connected to a list.

With powershell you can fix individual column to update it's lookup list:

 Function Fix-LookupColumn ($webURL, $listName, $columnName, $lookupListName)
 {
     #Get web, list and column objects
     $web = Get-SPWeb $webURL
     $list = $web.Lists[$listName]
     $column = $list.Fields[$columnName]
     $lookupList = $web.Lists[$lookupListName]
 
     #Change schema XML on the lookup column
     $column.SchemaXml = $column.SchemaXml.Replace($column.LookupWebId.ToString(), $web.ID.ToString())
     $column.SchemaXml = $column.SchemaXml.Replace($column.LookupList.ToString(), $lookupList.ID.ToString())
     $column.Update()
 
     #Write confirmation to console and dispose of web object
     write-host "Column" $column.Title "in list" $list.Title "updated to lookup list" $lookupList.Title "in site" $web.Url
     $web.Dispose()
 }

In order to use this function, simply call the following:

Fix-LookupColumn -webURL <URL> -listName "<List name containing the lookup column>" -columnName "<Lookup column name>" -lookupListName "<List used by the lookup column>"

For example:

Fix-LookupColumn -webURL http://mysite/site -listName "Clients" -columnName "Company" -lookupListName "Company"

Sometimes the search services gets stuck, following an index reset or a problem with the search component.
When Search service application shows crawl status as “Paused by system” or “External Request”, it can be fixed below:

Display search component status:
$ssa = Get-SPEnterpriseSearchServiceApplication
get-spenterprisesearchstatus -SearchApplication $ssa -Detailed -Text

Resume search component:

(Optional) If not running SharePoint Management:

Add-PSSnappin "Microsoft.SharePoint.PowerShell"

Then:

$ssa = Get-SPEnterpriseSearchServiceApplication
Resume-SPEnterpriseSearchServiceApplication $ssa

Force a index reset (if stuck):

Make sure to reset the Search Host Controller service and timer service before running theses commands.

(Optional) If not running SharePoint Management:

Add-PSSnappin "Microsoft.SharePoint.PowerShell"

Then:

$ssa = Get-SPEnterpriseSearchServiceApplication
$disableAlerts = $true
$ignoreUnreachableServer = $true
$ssa.reset($disableAlerts, $ignoreUnreachableServer)

In a recent development for a consulting client. In a custom page, we wanted to send an email with the from a given user and allow the user to reply to email directly to the given user.

We noticed that the reply-to email was the SharePoint Admin Email and not the from displayed in the email.

We tried:

//Set E-mail Header Variables
var messageHeaders = new StringDictionary
{
    {"to", emailTo},                     
    {"from", emailFrom},
    {"replyto", emailFrom},
    {"subject", emailSubject},
    {"content-type", "text/html"}
};
//Send Email by SharePoint
SPUtility.SendEmail(Web, messageHeaders, emailBody);

This did send an email, but the replyto is not overrided.

We used the .NET Send Email method to make this work.

This method retrieves the SharePoint Central Admin smtp server defined in the farm:

var smtpServer = SPContext.Current.Web.Site.WebApplication.OutboundMailServiceInstance.Server.Address;

With that information we can send the email as follow:

var message = new System.Net.Mail.MailMessage();
message.To.Add(emailTo);
message.Subject = emailSubject;
message.From = new System.Net.Mail.MailAddress(emailFrom);
message.Body = emailBody;
message.IsBodyHtml = true;
System.Net.Mail.SmtpClient smtp = new System.Net.Mail.SmtpClient(smtpServer);
smtp.Send(message);

How to use it?

• Login to Azure Portal
• Add a ressource "Redis Cache"

High Performance - Output Cache

<caching>
  <outputCache defaultProvider="RedisOutputCache">
    <providers>
          <add name="RedisOutputCache" 
               type="Microsoft.Web.Redis.RedisOutputCacheProvider" 
                port="6380" 
                host="MYID.redis.cache.windows.net" 
                accessKey="MYACCESSKEYINAZURE" 
                ssl="true" />
    </providers>
  </outputCache>
</caching>

<%@ OutputCache Duration="60" VaryByParam="*" %>

<sessionState mode="Custom" customProvider="RedisSessionProvider">
 <providers>
         <add name="RedisSessionProvider" 
   type="Microsoft.Web.Redis.RedisSessionStateProvider" 
   port="6380" 
   host="MYHOST.redis.cache.windows.net" 
   accessKey="MYAZUREKEY" 
   ssl="true" />
      </providers>
</sessionState>

• Log-in to your Azure Portal
• Click on your App Service
• Click on Application Settings

var web = clientContext.Web;

var file = web.GetFileByServerRelativeUrl(web.ServerRelativeUrl + "/SitePages/Home.aspx");

var wpm = file.GetLimitedWebPartManager(PersonalizationScope.Shared);

web.Context.Load(wpm.WebParts, wps => wps.Include(wp => wp.WebPart.Title));

web.Context.ExecuteQueryRetry();

for(var i=0;i<wpm.WebParts.Count;i++)

{

    if (wpm.WebParts[i].WebPart.Title.Equals("Get started with your site"))

    {

        wpm.WebParts[i].DeleteWebPart();

        web.Context.ExecuteQueryRetry();

    }

}