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 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”

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”

DataView is disabled in SharePoint Designer 2013

In this article, I will be fixing this issue

Adding Data View is grayed out in SharePoint Designer 2013.


Scenario

In SharePoint Designer 2013, I tried to add DataView in a web part page but unfortunately,  the Data View is grayed out as shown below:

DataView is grayed out in SharePoint Designer 2013


Cause Continue reading “DataView is disabled in SharePoint Designer 2013”

The Supported and Unsupported Columns In SharePoint Calculated Column Formula

In this article, I will list

The Supported and Unsupported Fields in SharePoint Calculated Column Formula

The Supported and Unsupported Columns in SharePoint Calculated Column Formula Continue reading “The Supported and Unsupported Columns In SharePoint Calculated Column Formula”

Using Lookup Field in SharePoint Calculated Column Formula

In this article, I will explain

How to use Lookup Field in SharePoint Calculated Column Formula

Scenario

I have a list with a lookup field, I would like to use this lookup field in in SharePoint Calculated Column Formula but unfortunately, it’s not listed in the available formula column as shown below:Using Lookup Field in SharePoint Calculated Column Formula

Cause

It’s by design, The lookup column can’t be used in SharePoint Calculated Column Formula and SharePoint Column Validation.

Check The Supported and Unsupported Columns in SharePoint Calculated Column Formula.

Workarounds

Continue reading “Using Lookup Field in SharePoint Calculated Column Formula”

Using ID Field in Calculated Column in SharePoint

In this article, I will explain

How to use The ID field in Calculated Column in SharePoint?

Scenario

I have tried to add ID field in a calculated column that added successfully without any error in the formula.

But I noticed that the calculated column is not calculated on the item added or updated!

Cause

Continue reading “Using ID Field in Calculated Column in SharePoint”