---
title: "Set Up List-to-List Import"
slug: "set-up-list-to-list-import"
description: "Learn how to configure List-to-List imports, mapping data types between Lists, and manage permissions for seamless data transfer in your application."
updated: 2026-05-26T11:53:02Z
published: 2026-05-26T11:53:02Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Set Up List-to-List Import

List-to-List import is a type of Block-to-Block import. It allows you to import from one List to another by mapping source and target properties that share the same data type. These imports can be saved and triggered by an Action widget or set up as a scheduled import. This article discusses how to configure and use List-to-List imports.

## What is a List-to-List Import?

A List-to-List import allows you to use data from one List Block as the source for importing into another List. This type of Block-to-Block import supports both Transaction Lists and Dimension Lists as either the source or the target.

Imports can be saved and then either scheduled or triggered via an Action Button on a Board. They can also be used to manually transfer data between Lists by mapping properties that share the same data type.

The source List can reside in the same Application as the target List or come from a shared Block. Additionally, you can apply filters to the source using the same filtering options available in View-filtered modes.

> [!WARNING]
> ⚠️ Important
> 
> Members must have the [**Import Data**](/v1/docs/pigment-access-rights-basics) Permission to trigger a List-to-List import.
> 
> - The **Read access rights** of the Member triggering the List-to-List import will be applied to the source List.
> - The **Write access rights** of the user triggering the List-to-List import will be applied to the target List.
> - The **Delete Item permission** will be required if the Clear Items prior to import option is toggled to On.

## Set up a List-to-List Import

When setting up a List-to-List import:

- The target List is the List that will receive the imported data.
- The source List is the List from which the data will be pulled.

> [!WARNING]
> ⚠️ Important
> 
> Members must have the Import Data permission and Read access rights on the source List to import data into the target List.

To set up the List-to-List import:

1. Open the target List.
2. Select **Import Data.**
3. Select **Pigment List**.
4. Select a List from the **source List** drop-down menu.
5. *(Optional)* Select **Use a List from a Snapshot,**then select a **Snapshot**from the source list drop-down menu.
6. Select **Set up import**.

## Step 1: Filter the Source List

You can configure and preview the data to be imported at this stage of the import. Data can be filtered or enriched using constant values.

By default, no filters are applied, so all Items from the source List are included in the import.

> [!NOTE]
> **ℹ️ Note**
> 
> When the source is a Snapshot, only Lists with the same structure as the target, including matching Properties and data types, are available.

![Step 1 of the List to List import configuration](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/Documentation - List to List copy - Step 1.jpg)

### Add a filter

To filter the source data for import:

1. Go to **Filter Data**, then select **+ Add a filter**.
2. Select the **Property** you want to filter on.
3. Choose a **filter operator**. The available operators will vary depending on the Property type.

*List of available operators:*

| **Operator** | **Data Type** |
| --- | --- |
| Is blank / Is not blank | All |
| Is in / Is not in | Dimension |
| Contains / Does not contain | Text |
| = , ≠ | Text, Boolean, Date, Number and Integer |
| > , < , **≥ , ≤** | Date, Number and Integer |
| Range (Min < N < Max), etc. | Date, Number and Integer |

1. Select **+ Add filter** and repeat steps 1 - 3 to add multiple filters. When you apply multiple filters, you can combine them using the **AND** or **OR** logical operator. The preview panel on the left updates automatically to show the data that will be imported.
  1. > [!WARNING]
> ⚠️**Important**
> 
> The source List is always filtered based on the **Read access rights** of the Member triggering the import. If the Member configuring the List-to-List import has limited access to the source data, only the records they can access will be included in the import.
2. When your data is filtered, select **Map Data**.

### Add a constant value

You can enrich imported data with constant values. Once configured, constant values are available in **Step 2 - Map Data**and can be mapped like any other source field.

To add a constant value:

1. Go to **Enrich data.**
2. Select **+ Add a constant value**and configure the following options:
  - **Source name**. The name of the constant value. The name must not conflict with an existing Property name in the source list.
  - **Data type**. Select the data type. A constant value can only be mapped to Properties with the same data type.
  - **Value.**The value that is imported once the data is mapped.
3. When your data is filtered, select **Map Data**.

> [!WARNING]
> ⚠️ Important
> 
> If a constant value is configured but not mapped in **Step 2 - Map data**, the configuration is automatically cleared.

## Step 2: Map Data for import

Map the Properties from the source List to the corresponding properties in the target List to define how the data will be imported. Only Properties with compatible data types can be mapped.

![Step 2 in list-to-list import is to map the data.](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/step 2.webp)

### Properties mapping

For each Property in the target List, select the corresponding Property from the source List to import data from.

- Only Properties with the same data type can be mapped (e.g., an Integer Property can only be mapped to another Integer Property).
- Autogenerated or formula-based target Properties cannot be mapped.
- Any target Property left unmapped will not be updated during the import.
- A single source Property can be mapped to multiple target Properties.

> [!NOTE]
> ℹ️ Note
> 
> To optimize property mapping, select **Autofill source fields** to automatically link Properties that have identical names and matching data types.

### Error handling

For List-to-List imports, you can define what happens if a Member doesn’t have Write access rights or the required permissions to write to the target List.

To import data to a target List, you must have the following access depending on the operation:

- **To update existing items**. You must have Write access rights on all mapped Properties.
- **To create new Items**. You must have Write access rights on all mapped Properties and the Add Items permission on the target List.
- **To delete items**. You must Delete Items permission on the target List. This option is available when Clear items prior to import is toggled to On.

Two options are available if access rights or permissions are missing:

- **Fail import**. The entire import will be canceled if the user triggering it lacks the required access rights or permissions. This ensures an all-or-nothing import—no items will be partially imported due to insufficient access.
- **Reject rows**. Only the affected rows will be skipped. The rest of the data will be imported, which may result in a partial import.

### Additional options

> [!WARNING]
> ⚠️ Important
> 
> This option is only available when the target List is a Transaction List. For more information, see [Clear Items prior to import in Transactions Lists](/v1/docs/clear-items-prior).

In Transaction Lists, use the **Clear items prior to import** option to remove existing Items before import. This replaces the current Items with those from the imported data.

When this setting is enabled, you can use the following options to define how Items are deleted from the List:

- Delete the entire List
- Define a specific set of Items to be deleted

To use **Clear Items prior to import**:

1. Select **Additional** **options** and toggle **Clear Items prior to import** to **On**.
2. Toggle on **All items** to delete the entire List or **Limited scope** to delete a specific set of Items. If using Limited scope, select the source List to define which Items should be deleted and replaced.
3. Select **Import**.

## Import summary

When the import is complete, a report will display the number of Items created, updated, or deleted in the target List.

The report also highlights any rows that were skipped, such as those the user didn’t have permission or access rights to modify, or rows that existed in the source data but not in the target List.

![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/image(210).png)

### Save configuration

If you plan to run this import multiple times, you can save the configuration by selecting Save as new. This option is available before launching the import when mapping data and after the import completes in the import summary.

To reload a saved configuration, select Edit in the first step of the import process. This will restore the settings for both Step 1 and Step 2.

Saving the import configuration is needed in order to be able to:

- Trigger the import from a Board using an Action button.
- Schedule an import in the import scheduling page.