SharePoint Online List View Operations, Using PnP Core CSOM Library

Introduction

In this article, you will learn about list view operations performed on SharePoint Online, using PnP Core CSOM library.


The main advantage of using PnP Core libraries is the reduced code to get the required information. The required object can be retrieved with a very small piece of code, once the client context is set.


Prerequisite

  • PnP Core CSOM documentation can be found on the office site here.

  • PnP Core CSOM library packages can be downloaded here.

The code, given below, is being tested, using Visual Studio console application. Once the console application is created, the packages can be installed, using Install-Package SharePointPnPCoreOnline command on Package Manager console of Visual Studio. Once installed, the references and packages will be imported to the solution.


The references used in the sample are given below-

  • Microsoft.SharePoint.Client

  • OfficeDevPnP.Core 

Connect to SharePoint online site

The Authentication Manager is used to retrieve the client context of the site. To connect to SharePoint Online site, the below method is used.

  • GetSharePointOnlineAuthenticatedContextToken 

The parameters required are -

  • SharePoint Online site URL

  • Tenant UserId

  • Tenant Password (or secured string)

The following operations explain the list view methods in details.


Create List View

The list view can be created using PnP Core library. The steps involved are -

  • Input the site detail, user details for authentication, existing list name, and new view name.

  • Authenticate and get the client context of the site.

  • Get the list by using GetListByTitle method with the list name.

  • Then, create view by passing the input parameters like View name, View type, View fields, row limit, query. 

  • Output the required result on the console. 

The code snippet, given below, shows the list view creation operation, using existing list. 

  1. // Input Parameters  

  2. string siteUrl = "https://nakkeerann.sharepoint.com";  

  3. string userName = "abc@nakkeerann.onmicrosoft.com";  

  4. string password = "***";  

  5. // PnP component to set context  

  6. AuthenticationManager authManager = new AuthenticationManager();   try {  

  7. // Get and set the client context

  8. // Connects to SharePoint online site using inputs provided

  9. using (var clientContext = authManager.GetSharePointOnlineAuthenticatedContextTenant(siteUrl, userName, password))      

  10. {     

  11. // List Name         

  12. string listName = "TestList";  

  13. // Get List         

  14. List list = clientContext.Site.RootWeb.GetListByTitle(listName);  

  15. // Input for creating view         

  16. string viewName = "customview";          

  17. string[] viewFields = { "Title", "Author" };  

  18. bool defaultView = true;  

  19. // Creates New View         

  20. View newView = list.CreateView(viewName, ViewType.None, viewFields,30, defaultView, null, falsefalse);  

  21. // Output         

  22. Console.WriteLine("The view has been created.");          

  23. Console.WriteLine("View Name : " + newView.Title);          

  24. Console.WriteLine("View ID : "+newView.Id);          

  25. Console.ReadKey();      

  26. }  

  27. }  

  28. catch (Exception ex)  

  29. {      

  30. Console.WriteLine("Error Message: " + ex.Message);      

  31. Console.ReadKey();  

  32. }  


Retrieve List View

The list view can be retrieved using two ways with PnP Core library - by name and by Id.


By Name

The list view can be retrieved by the view name, using PnP Core library. The steps involved are -

  • Input the site detail, user details for an authentication, list name and view name.

  • Authenticate and get the client context of the site.

  • Get the list by using list retrieval method.

  • Then, retrieve the view by view name. 

  • Output the required result on the console. 

The code snippet, given below, shows the list retrieval operation using list view name. 

  1. // Input Parameters  

  2. string siteUrl = "https://nakkeerann.sharepoint.com";  

  3. string userName = "abc@nakkeerann.onmicrosoft.com";  

  4. string password = "***";  

  5. // PnP component to set context  

  6. AuthenticationManager authManager = new AuthenticationManager(); 

  7.  try

  8. {  

  9. // Get and set the client context

  10. // Connects to SharePoint online site using inputs provided

  11. using (var clientContext = authManager.GetSharePointOnlineAuthenticatedContextTenant(siteUrl, userName, password))      

  12. {  

  13. // Input Parameters

  14. // List Name         

  15. string listName = "TestList";  

  16. // View Name         

  17. string viewName = "customview";  

  18. // Get View By Name         

  19. View view = clientContext.Site.RootWeb.GetListByTitle(listName).GetViewByName(viewName) 

  20. // Output         

  21. Console.WriteLine("View Url  : " + view.ServerRelativeUrl);          

  22. Console.ReadKey();      

  23. }  

  24. }  

  25. catch (Exception ex)  

  26. {      

  27. Console.WriteLine("Error Message: " + ex.Message);      

  28. Console.ReadKey();  

  29. }  

By Id The list view can be retrieved by the view Id, using PnP Core library. The steps involved are, 

  • Input the site detail, user details for an authentication, list name and view name.

  • Authenticate and get the client context of the site.

  • Get the list by using list retrieval method and then retrieve the view object by view Id.

  • Output the required result on the console. 

The code snippet, given below, shows the list view retrieval operation using list view Id. 

  1. // Input Parameters  

  2. string siteUrl = "https://nakkeerann.sharepoint.com";  

  3. string userName = "abc@nakkeerann.onmicrosoft.com";  

  4. string password = "***";  

  5. // PnP component to set context  

  6. AuthenticationManager authManager = new AuthenticationManager();  

  7. try

  8. {  

  9. // Get and set the client context

  10. // Connects to SharePoint online site using inputs provided

  11. using (var clientContext = authManager.GetSharePointOnlineAuthenticatedContextTenant(siteUrl, userName, password))      

  12. {  

  13. // Input Parameters

  14. // List Name         

  15. string listName = "TestList";   // View Id         

  16. Guid viewId = new Guid("xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx");  

  17. // Get View By Id         

  18. View view = clientContext.Site.RootWeb.GetListByTitle(listName).GetViewById(viewId);  

  19. // Output         

  20. Console.WriteLine("View Name : " + view.Title);          

  21. Console.WriteLine("View Url  : " + view.ServerRelativeUrl);          

  22. Console.WriteLine("View Id   : " + view.Id);          

  23. Console.ReadKey();      

  24. }  

  25. }  

  26. catch (Exception ex)  

  27. {      

  28. Console.WriteLine("Error Message: " + ex.Message);      

  29. Console.ReadKey();  

  30. }  

Note - To test the code, press F5 and wait for the console.  Summary Thus, you have learned how to add and retrieve list view to/from the SharePoint Online list, using PnP Core CSOM Component library.