Skip to main content
WEBCON BPS
Documentation
2025 R2
  • 2025 R2
  • 2025 R1
  • 2024 R1
  • 2023 R3
  • 2023 R2
English
  • English
  • Polski
ctrlK
  • Introduction
  • Getting started
  • Designer Studio
    • Licenses
    • Main menu
    • Designer Studio Toolbar
    • Applications
    • Processes
    • Workflows
    • Actions
      • Sequence of action execution
      • OCR and scanning
      • Notifications
      • Form
        • Change value of single field
        • Hyperlink
        • Validate form
        • Change values of multiple fields
        • Update item list values
        • Clear item list
        • Replace item list
        • Remove item list row
        • Add item list rows
      • Task assignment
      • Privileges and public access
      • Workflow control
      • Substitutions
      • Reports and printouts
      • Digital signatures and certificates
      • Barcodes
      • BPS users and groups
      • Exchange
      • Active Directory
      • SharePoint content
      • SharePoint users and privileges
      • Integration
      • Attachments
      • Database retention
      • OneDrive
      • Performance indicators
      • AI
    • Automations
    • Importing and exporting applications
    • Variables
    • Business rules
    • Form rules
    • Administration tools
    • Data sources
    • System settings
    • Reports
    • SDK plugin packages
  • Portal
  • Mobile application
  • MS Office Add-Ins
  • Guides
  • Designer Studio
  • Actions
  • Form
  • Replace item list
Version: 2025 R2

Replace item list

The action removes all rows of the Item list and replaces them with new ones with the specified values in the selected columns.
Unlike the Update item list values action, the configuration window for this action does not have a section dedicated to Unique value mapping.

Replace item list

The action log displays information about the number of rows added or removed.

1. Item list​

Allows you to specify the Item list to be changed.

2. Data source​

Data source in the context of which the query will be executed.

3. SQL query​

An SQL query should return columns corresponding to the columns in the Item list.

4. Columns mapping​

This option is used to map data source columns to Item list columns. Based on this mapping configuration, Item list columns will be filled according to their order on the form in the given step.
If column mapping is not configured, the column will be skipped when setting values.
If the data source fails to return a column (despite mapping), the column will be skipped as if it was not configured. Item list initialization and the action will be logged as missing column configuration.

7. Get columns​

Gets a list of columns corresponding to the current SQL query.

info

For further details, refer to the article Actions on the Item list on our technical blog.

Previous
Clear item list
Next
Remove item list row
  • 1. Item list
  • 2. Data source
  • 3. SQL query
  • 4. Columns mapping
  • 7. Get columns
WEBCON is the leading European-based provider of a complete Low-code Application Platform for mass delivering business solutions. Companies choose WEBCON to dramatically reduce time and cost of app development. The platform allows them to automate and manage business processes across the entire organization – using a single, unified platform. Thanks to its unique InstantChange™ technology, WEBCON embraces change like no other platform on the market.
  • Copyright © 2025 WEBCON
Platform
  • The latest version
  • InstantChange™ Technology
  • WEBCON BPS overview
Community
  • WEBCON Community
  • Developer portal
Meet us
  • About WEBCON
  • News
  • Contact
Copyright © 2023 WEBCON

Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪.

Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.