Skip to main content

​
Prerequisites

  • A powersheet document with at least two entity types connected by a relationship in the domain model
  • The relationship must be defined with a valid linkRole and storage: linkedWorkItems
  • Your user account must have permissions to create links between the target work item types

​
Step 1: Define the Relationship in the Domain Model

Before linking, ensure your domain model has the relationship configured: 
relationships:
  - from: UserNeed
    to: SystemRequirement
    cardinality: many-to-many
    storage: linkedWorkItems
    linkRole: requires
    direct:
      name: systemRequirements
    back:
      name: userNeeds
This creates bidirectional navigation properties: systemRequirements on UserNeed and userNeeds on SystemRequirement.

​
Step 2: Enter Linking Mode

There are two methods to create links in Powersheet:
  1. Select a cell in the source row (the entity you want to link from)
  2. Click the Link button in the toolbar to activate linking mode
  3. The source row becomes read-only and the sheet switches to row-selection mode
  4. A visual indicator (CSS class ltc-mode--link) highlights that linking mode is active

​
Method B: Use the Picker in a Multi-Item Column

For many-to-many columns, double-click the cell to open the entity picker:
  1. The picker dropdown shows available target entities
  2. Use the search field to filter entities by title or ID
  3. Select an entity from the list to create the association
diagram

​
Step 3: Select the Target

In linking mode (Method A), click on the target row to establish the link. The sheet validates that:
  • The target entity type matches the relationship definition
  • The link does not duplicate an existing association
  • The link is not self-referencing (source and target are different entities)
Powersheet prevents creating duplicate links between the same two entities and blocks self-referencing links. If you attempt either, the link will not be created.
To remove an existing link without deleting the work items:
  1. Locate the linked entity in the multi-item column
  2. Click the Unlink button next to the entity
  3. The association is marked for deletion but both entities remain intact
Both linking and unlinking operations support undo/redo. Press Ctrl+Z to reverse a link creation or removal before saving.

​
Step 5: Save

Click Save to persist the new links to Polarion. The save operation creates the appropriate link role associations in Polarion’s work item linking system.

​
Step 6: Verify

You should now see the linked entity displayed in the corresponding multi-item column. If your sheet uses expansion paths, the linked entity also appears in the hierarchical tree structure.
Open the source work item in Polarion and check the Linked Work Items section to confirm the link role and target are correct.

​
See Also

Source Code
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/packages/sheet/commands/index.ts
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/packages/sheet/SheetComponent.tsx
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/cypress/e2e/Sheet/parameters-in-document.spec.ts
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/packages/sheet/commands/link.ts
  • prod-powersheet-src/com.nextedy.powersheet.client/cypress/fixtures/models/constraints-base.yaml