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.

1 Configure an Existing SharePoint list URL
2 Create a new SharePoint list
- 2.1 Customize the SharePoint name for the template list
3 Supported Data Types

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:

Open an existing SharePoint.
Select List from the New option.
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:

Click Administration
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
}
}
]
}

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.