SharePoint On-Premises: How to create new set of Lists for Archival

Creating List Schema for archival feature

Applies To: SharePoint On-Premises 2013/2016 /SharePoint Server Subscription Edition

(For SPOnline case, please refer:

Please follow below steps to prepare the Lists for archival.

Please note that Archive related lists should not have any workflow instances or event receivers attached to them. After creating the lists as described in this article, refer #2 and #3 from this article:

1. Take list templates for Tickets, Email Tickets, Associated Tasks, Calendar and Time Tracking lists

 Go to Site Contents –>Tickets list –>List Settings –>Click on ‘Save list as Template’ link:

— Give File name,Template Name and click on “Ok”

Similarly, take list templates for other lists.

2. Create Archive Lists

— Create archival lists (Archived Tickets, Archived Email Tickets, Archived Associated Tasks, Archived Calendar, Archived Time Tracking lists) using these list templates created in step 1

(The idea behind creating Archived Email Tickets, Arichived Time Tracking, Archived Calendar and Archived Associated Tasks lists is to move email history and related tasks along with tickets during the archival process).

— Creating Archived tickets list: Go to Site Contents –> Add an App –> Select Tickets list Template –> name it as Archived Tickets list

— Similarly create Archived Email Tickets, Archived Time Tracking,Archived Calendar and Archived Associated Tasks lists using their correspoinding list templates

3. Verify Lookup and Associated Items Fields

Once archive lists are created, we need to verify the lookup fields. Also, some lookup fields have to be recreated so that they refer archive lists instead of the original lists.

— For some lookup fields like Category and Issue Type, they will continue to refer the same lists as the original Tickets list. We need to navigate to the field settings of these lookups and just verify that they are having the correct settings

— For other lookups, such as ‘Related Ticket Id’ in Email Tickets list, we need to recreate this lookup so that it refers to Archive Tickets list instead of the original Tickets list. Correspondingly, we need to recreate the Associated Items fields that are referring these recreated lookup fields. Please refer the details given below to verify and recreate these fields

Fields in Archived Email Tickets list:

Internal name: RelatedTicketID

Display name: Related Ticket ID

Fields in Archived Time Tracking list:

Internal name: TicketID

Display name: Related Ticket ID

Fields in Archived Assoicated Tasks list:

Internal name: RelatedTicketID

Display name: Related Ticket ID

Fields in Archived Calendar list:

4. Reconfigure Associated Items columns

— Delete all ‘Crow Canyon Associated Items’ columns from Archived Tickets list and re-create using the newly created lookup fields so that they they show items from corresponding archive lists

Delete Time Tracking, Email History, Appointments, and Associated Tasks fields from Archived Ticekts list.

— Create below fields in Archived Tickets list

Go to Site Contents –> Archived Tickets list –> List Settings –> Create associated columns like shown below.

Internal Name : TimeTracking

Display name: Time Tracking

Internal Name: IT Associated Task
Display Name: IT Associated Task

Internal Name: Email History
Display Name: Email History

Internal Name: Appointments
Display Name: Appointments

After creating the list schema, please configure Archival settings with newly created list like shown below

Please refer this article for more details regarding Archival functionality.

Leave a Reply