SharePoint List

Overview

A SharePoint list is a data collection. A list is made up of three parts: items, fields, and views. An item is analogous to a record in a database, such as customer information; Fields are similar to columns in a database or metadata. Fields can include the customer's name, email address, mobile number, and so on.

CAM allows the user to create and configure the SharePoint list in the teams through the Template Editor.

Configure an Existing SharePoint list URL

To configure an existing SharePoint list URL in the template editor and create an exact copy for the team using the clone:

  1. Open an existing SharePoint.

  2. Select List from the New option.

  3. Click Blank list to create a new list.

Create a new SharePoint list

To create a new SharePoint list in the team, specify a list of columns and items in the Config JSON in the template editor.

Steps to configure the SharePoint List:

  1. Click Administration

  2. Click Template Editor

The following screen displays:

 

Fields

Description

Fields

Description

Folder Name

Enter a folder name.

Folder type

Select the folder type as “SharePoint list“ from the list.

Config JSON

Enter config JSON. Sample Config JSON provided for existing sharepoint list URL and New Sharepoint List.

Default Security

Select security from the list.

Show as

Select an option.

Prefix/Suffix

Select an option.

Sample Config JSON - Existing SharePoint List URL

{ "listURL" : "https://camofficesync.sharepoint.com/sites/9800-004LegoCorpAdvice/Lists/Issues%20tracker/Alltems.aspx" }

Sample Config JSON - New SharePoint List

{ "columns" : [ { "name" : "Id", "text" : { "allowMultipleLines" : true, "appendChangesToExistingText": false, "maxLength": 300, "textType" : "plain", "linesForEditing" : 6 } }, { "name" : "name", "text" : { "allowMultipleLines" : true, "appendChangesToExistingText": false, "maxLength": 300, "textType" : "plain", "linesForEditing" : 6 } } ] }
  1. Click the Save button to create a SharePoint list.

Customize the SharePoint name for the template list

It is possible to customize the template name for the SharePoint list. Use the following JSON.

Sample JSON

{ "template": "genericList" }

Supported Data Types

Property Name

Type

Description

Property Name

Type

Description

Boolean

BooleanCloumn

Stores boolean value. e.g True or false

Calculated

CalculatedColumn

Calculated data based on other column data.

Choice

ChoiceColumn

Stores data from a list of choices.

Currency

CurrencyColumn

Stores Currency value.

DateTime

DateTimeColumn

Stores Date Time value.

Defaultvalue

DefaultColumnValue

Stores default value.

GeoLocation

Geolocationcolumn

Stores Geolocation.

LookUp

LookUpColumn

Stores the lookup’s data from another source in the site.

Number

NumberColumn

Stores number column.

PersonorGroup

PersonorGroupColumn

Stores person or group values

Text

TextColumn

Stores text values.

 

Let's Connect📌

☎ +1 630.598.1100
☎ ‪+44 20 3880 1550‬
📧 support@litera.com
💻 https://www.litera.com/support/

📝 Support is available:
4 am - 8 pm US Eastern
(9 am - 1 am GMT/BST
7 pm - 11 am AET) on normal business days (excluding holidays)

© 2024 Litera