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:
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 |
---|---|
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 |
---|---|---|
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