The most basic task for a visual web part is to display data from a SharePoint list. For this example, I'm going to use the standard ASP.NET GridView control, but don't forget that SPGridView inherits from the GridView Next, In the pop-up window, make sure you select the "Deploy as a farm solution" option. For the field value, pick the value passed to the lookup column, tipically ID field. You should be getting something like this: ColumnA only shows items from List 1 which State field has the value Active. Hope you enjoyed it and if you want to see this working, download the following site template Someone asked me this morning when doing a code review of my code how I got a field value. They were not looking very closely. Here is how I do it, although there are 50,000 other ways of doing it. - Set and Get the SharePoint Lookup Field (Single/Multiple) values via Server. Get_Set_SharePoint_Lookup_SSOM.zip. I am using CSOM to retrieve data from sharePoint online. I need to get data from a document lib. here is syntax which I used to retrieve data. So I tried to get value as below, but it returns null. var itm = item.FieldValues["PONo"] as FieldUserValue; when try like this, var itm = item.FieldValues["PONo" A lookup column which refers to items from a whole different site collection does not work. But to create a lookup column programmatically and add an additional fields related to this lookup column 1) Accessing the list by c#. SPList pojectList; SPList itApplication; SPSite site = new SPSite("yoursite" here PONo is a lookup for another list item. So I tried to get value as below, but it returns null. var itm = item.FieldValues["PONo"] as FieldUserValue Email codedump link for SharePoint lookup field returning null value. Email has been send. In a lookup field SharePoint is looking up the ID of the list item. Now, once the workflow has completed that stage the value we want inserted into our lookup field is stored in our variable. When you reach the