Skip to main content

Set Data List Action

Use the Set Data List workflow action to add, update, or delete records in a data list.

Use Set Data List when a workflow needs to write to a data list. For example, create a project record when an approval workflow finishes.

The action can add one record, update matching records, or delete matching records in the selected list.


Add Set Data List action.

Open the workflow designer. In the left Actions toolbox, find Set Data List and drag it onto the canvas. Connect it to the branch where the record change should occur.

Workflow Designer example. Choose Set Data List from the Actions toolbox, connect the action on the canvas, and open its Settings.

Select the action and click the Settings gear beneath it to open its properties on the right.


Configure Set Data List action.

Action Name: Set the display name of this action.

Description: Set a short description of this action.

Under Select data list, choose the target that should receive the changes.

  • Application: Select the application from the dropdown list.

  • Data source: Select the existing data list under the selected application.

Target selector with Sales Management as the application and Contacts as the data source.

Under Execute type, choose Add, Update, or Delete.

  1. Add creates one record in the selected list.

    Select Add, then click Field Settings to open the field mapping dialog.

    List Field shows the fields in the selected list. For example, the Contacts list includes First Name, Last Name, and Email.

    Field Type shows the format each field expects. In Value, enter the value to write.

    Select the checkbox for each field you want to set, including required fields without a default. Use the expression editor in the Value column to build the value.

    Enter a fixed value or select a dynamic value from workflow variables or the workflow context.

    Click OK to save the field mapping.

    Add contact example. First Name maps to Buyer First Name, Last Name to Buyer Last Name, and Email to Buyer Email.

  2. Update changes records in the selected list. Click Field Settings and map the fields you want to change.

Update project example. Set the list field Id to Equals with the Project ID workflow variable, and check the condition before saving.

Click Condition to choose which records to update.


​For example, in a Projects list, set Id to Equals and choose the Project ID workflow variable to target one project.

Review the filter before saving. Use a unique record ID when only one record should change.

Caution:

Without a condition, the action does not update any records.

The action can update up to 500 matching records per execution.

Delete removes matching records from the selected list. Click Condition and use a unique record ID when you intend to delete one record.

Delete project example. Choose Delete, open Condition, and match Id to the Project ID workflow variable. Verify the intended matching record.

Caution:

Without a condition, the action does not delete any records.

The action can delete up to 500 matching records per execution. Test the filter against disposable records in a test application before using it in production.


​


​

Did this answer your question?