Creating List And Columns Using SharePoint Hosted Add-ins

How to create a list and column using SharePoint-self hosted Add-ins

Introduction

 

In this blog, I have described step by step how to create a list and column using SharePoint self hosted Add-ins. To create the List and List Columns using SharePoint Hosted Apps, you have to follow the below steps.

 

Step 1 - Create a SharePoint Hosted App project.

Step 2 - Write HTML code under Default.aspx.

Step 3 - Add Javascript code under App.js file.

Step 4 - Deploy the Project.

 

Create a sharePoint Hosted App project

• Open Visual Studio to create a SharePoint hosted Add-In. First, click the file menu option then click the new item. After that we can see the option for Project item, now click on the same option.
• Expand the office/SharePoint tab and select SharePoint Add-in. Enter the project name & location of the project then hit the OK button.

• Select the SharePoint site URL & Hosted add-in as shown below and then click on the Next button.

• Now it will ask for your credentials. Enter the user Credentials (Username & Password) and Click the "Sign-in" Option.
• Once the SharePoint hosted App is created, then we can add our code.

Write HTML code under Default.aspx

 

Go to Default.aspx page. Create a label and a button inside the div class as shown below.

<tr>
         <td><label id="btnCreate" style="font-size:large;font-style:normal">Enter The List Name You Want To    Give</label></td>
         <td><input type="text" id="txtListName" name="txtListName" /></td>
         <td><input type="button" id="crtBtn" value="CreateList" /></td>
   </tr>

Add Javascript code under App.js file

 

Go to App.js . Add your coding.

function initializePage() {
    var context = SP.ClientContext.get_current();
    var user = context.get_web().get_currentUser();
    $(document).ready(function() {
                $("#crtBtn").on('click', function() {
                    CreateList();
                });

                function getURLParameters(param) {
                    var params = document.URL.split('?')[1].split('&');
                    var strParams = '';
                    var plength = params.length;
                    for (var i = 0; i < plength; i = i + 1) {
                        var singleParam = params[i].split('=');
                        if (singleParam[0] == param) {
                            return singleParam[1];
                        }
                    }
                }

                function CreateList() {
                    var hostUrl = decodeURIComponent(getURLParameters("SPHostUrl"));
                    var clientContext = new SP.ClientContext.get_current();
                    var hostContext = new SP.AppContextSite(clientContext, hostUrl);
                    var oWeb = hostcontext.get_web();
                    var value = document.getElementById("txtListname").value.toLowerCase();
                    var listCreation = new SP.ListCreationInformation();
                    xlistCreation.set_title(value);
                    listCreation.set_templateType(SP.ListTemplateType.genericList);
                    var mySpList = oWeb.get_lists().add(listCreationInfo);
                    var fieldColl = mySpList.get_fields();
                    var spTxtField = fieldColl.addFieldAsXml('<Field Type="Text" DisplayName="Employee Name" Name="Employee Name" />', true, SP.AddFieldOptions.addToDefaultContentType);
                    spTxtField.set_title("Employee Name");
                    var spDescripField = fieldCol.addFieldAsXml('<Field Type="Note" DisplayName="Address" Name="Address" />', true, SP.AddFieldOptions.addToDefaultContentType);
                    spDescripField.set_title("Address");
                    mySpList.update();
                    clientContext.executeQueryAsync(function() {
                        alert("successfully Created The List and List Field");
                    }, function(sender, args) {
                        alert('Error: ' + args.get_message() + '\n' + args.get_stackTrace());
                    });
                }
            }

Deploy the Project

• Go to the "Solution Explorer", right-click on the project and click on Deploy.

• Once you deploy it, enter your office365 credentials.
• Now you can see your App page.

• Enter the list name and click on the CreateList button.
• Now you can see the list in your sitecollection.

• And the NewList which contains two columns as shown below.