Skip to main content

​
Set multiItem on a Column

Add multiItem: true to any column that represents a one-to-many or many-to-many relationship. The column binding path must point to a collection navigation property in the domain model: 
columns:
  validationTestCases.validationTestCase:
    title: Validation Test Cases
    multiItem: true
    minWidth: 200
PropertyTypeDefaultDescription
multiItembooleanFalseEnables multi-value display and editing for collection columns
When multiItem is true, the cell displays all linked entities and provides a multi-reference picker for adding or removing items.

​
Identify When multiItem Is Required

Use multiItem: true when the column binding path traverses a collection relationship — meaning the entity at the end of the path can have multiple linked items. Common scenarios include:
  • Verification test cases linked to a requirement
  • Validation test cases linked to a requirement
  • External references linked to a design output
  • Risk controls linked to a hazard
diagram
When a parent entity links to two different work item types (for example, a system requirement linked to both design outputs and design verifications), the second linked column must be declared with multiItem: true. This is a non-obvious requirement that consistently blocks new users during initial setup.

​
Configure the Sources Expansion

The sources section must include an expansion path for the collection relationship. Without this, the column will have no data to display: 
sources:
  - model: rtm
    query:
      from: UserNeed
      where: <WHERE>
      take: <TAKE>
    expand:
      - name: systemRequirements
        expand:
          - name: verificationTestCases
          - name: designRequirements
            expand:
              - name: verificationTestCases
Each expand entry corresponds to a relationship in the domain model. The column binding path must match the expansion hierarchy. For multi-item columns, configure the list.search property to define which fields users can search when selecting items: 
columns:
  systemRequirements.systemRequirement.verificationTestCases.verificationTestCase:
    title: Verification Test Cases
    multiItem: true
    list:
      search:
        - title
        - id
Begin with a minimal single-item configuration and verify it works before adding multi-item columns. Jumping straight to complex multi-item configurations leads to hard-to-diagnose errors.

​
Multi-Level Multi-Item Columns

Multi-item columns can appear at multiple levels of the hierarchy. For example, verification test cases can be linked both at the system requirement level and the design requirement level: 
columns:
  systemRequirements.systemRequirement.verificationTestCases.verificationTestCase:
    title: SR Verification
    multiItem: true
    columnGroup: sysreq
  systemRequirements.systemRequirement.designRequirements.designRequirement.verificationTestCases.verificationTestCase:
    title: DR Verification
    multiItem: true
    columnGroup: desreq

​
Complete Example

sources:
  - model: rtm
    query:
      from: UserNeed
      where: <WHERE>
      take: <TAKE>
    expand:
      - name: systemRequirements
        expand:
          - name: verificationTestCases
          - name: designRequirements

columns:
  outlineNumber:
    title: "#"
    width: 80
    isreadOnly: true
  title:
    title: Title
    width: "*"
    hasFocus: true
  systemRequirements.systemRequirement.verificationTestCases.verificationTestCase:
    title: Verification
    multiItem: true
    minWidth: 200
    list:
      search:
        - title
        - id

​
Verify

After saving the sheet configuration, reload the powersheet document. You should now see multi-item columns displaying all linked entities per row. Clicking a cell opens the multi-reference picker, allowing you to search, add, and remove linked items.

​
See also

KB ArticlesSupport TicketsSource Code
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/packages/common/types/api/document.ts
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/packages/sheet/commands/exportXlsx.tsx
  • powersheet.yaml
  • prod-powersheet-src/com.nextedy.powersheet.client/src/modules/Powersheet/Powersheet.tsx
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/packages/sheet/SheetComponent.tsx