SharePoint Lookup Field Multiple Values Via C#

In this article, we will explain How to programmatically

  • Set a SharePoint Lookup Field (Single Value) via SSOM C#.
  • Set a SharePoint Lookup Field (Multiple Values) via SSOM C#.
  • Get a SharePoint SharePoint Lookup Field (Single Value) via SSOM C#.
  • Get a SharePoint SharePoint Lookup Field (Multiple Values) via SSOM C#.

 Continue reading “SharePoint Lookup Field Multiple Values Via C#”

Advertisements

Get the Update Level In SQL Server 2016

Consider you need to install a new Cumulative Update or Service Pack on your current SQL Server, but you don’t know what’s the current update level that already installed on your environment!!

In this article, we will explain

How to detect the current Cumulative Update / Service Pack that was installed on SQL Server.


Detect the Current Cumulative Update / Service Pack Installed

You can use the ServerProperty as a system defined function to return the SQL Server Instance information like the ProductLevel and ProductUpdateLevel

The ProductLevel returns the version level of the SQL Server instance as the following.

  • RTM‘ = Original release version
  • SPn‘ = Service pack version
  • CTPn‘, = Community Technology Preview version

Example 


select SERVERPROPERTY('ProductLevel') as 'Product Level'

Continue reading “Get the Update Level In SQL Server 2016”

Detect the Installed SKU of SharePoint 2016

In this article, I will show

How to detect the SharePoint 2016 Edition and the Farm Build Number via Server Side Object Model – C#.


Get SharePoint 2016 Edition

The below function “Get_SPEdition” is used to detect the SharePoint 2016 Edition, based on the installed product SKU it shows the corresponding edition.

Continue reading “Detect the Installed SKU of SharePoint 2016”

Detect the Installed SharePoint Edition Using PowerShell

In this article, I will explain

How to detect the installed SharePoint Edition Using PowerShell?


Prerequisites

Before you run this script, you should make sure that the current user has sufficient privilege to run PowerShell Script in SharePoint, Read more at Add-SPShellAdmin

Note: You can directly use the farm account to run this script.


Script Functions

There is a lot of articles talk about this topic, but the new here is detecting the SharePoint 2016 Edition based on the SKU ID. Continue reading “Detect the Installed SharePoint Edition Using PowerShell”

Get SharePoint List items in Power BI

In this article, I will show

How to query data from SharePoint List / Library in Power BI.


Get SharePoint List/Library Using OData Feed

First, let’s briefly define the OData?

  • The Open Data Protocol (OData) is a data access protocol for the web.
    • OData provides a uniform way to query and manipulates datasets through CRUD operations (create, read, update, and delete).
    • OData defines an abstract data model and a protocol that let the client access information exposed by SharePoint.

Steps

Continue reading “Get SharePoint List items in Power BI”

Project Server 2016: Can’t change the Site Title in Seattle Master Page

In this article, I will talk about the below bug in Project Server 2016.

The Site Title can not be changed in Seattle Master Page in Project Server 2016.


Scenario

By default in Project Server 2016, the assigned Master Page for the PWA Instance is Seattle with Home word as a Site Title.

The Site Title is not changed in Seattle Master Page in Project Server 2016. 177

So I have tried to change the PWA Site Title through

  • Site Settings > Look and Feel > Title, Description and Logo.

But unfortunately, The new Site Title is not changed as shown below:

The Site Title is not changed in Seattle Master Page in Project Server 2016.


Cause

Actually, I didn’t face this issue before in Project Server 2013 with Seattle Master Page, and I think it’s a bug in Project Server 2016. So I raised this bug in Project User Voice.

[Bug] The Site Title can not be changed in Seattle Master Page in Project Server 2016

Please don’t forget to upvote this voice to get this issue solved as soon as possible!

By the way, The farm has been updated with the latest Cumulative update (Sept 2017) for SharePoint 2016 and looks like the issue still not solved!

SPFx for SharePoint Server 2016


Workaround

Continue reading “Project Server 2016: Can’t change the Site Title in Seattle Master Page”

Export Data View To Excel In SharePoint 2016 / 2013

In this article, I will show How to

Export Data View Web Part To Excel In SharePoint 2013 / 2016

Scenario

In SharePoint 2013, I created a Data View Web Part with an external database connection as a data source via SharePoint designer.

Export Data View to Excel In SharePoint Continue reading “Export Data View To Excel In SharePoint 2016 / 2013”