Skip to main content

​
Prerequisites

  • A powersheet document open in Siemens Polarion ALM with a valid sheet configuration and domain model
  • The entity type you want to create must be defined in the domain model with a valid polarionType mapping
  • Your user account must have create permissions for the target work item type

​
Step 1: Add a New Row

Click the Add button (➕) in the sheet toolbar, or use the keyboard shortcut Ctrl+Space while a cell is selected. A new empty row appears in the sheet.
The new row is created at the current hierarchy level. If you have a multi-level sheet (e.g., UserNeed > SystemRequirement), the row is added at the level corresponding to the selected cell’s entity type.

​
Step 2: Enter Required Fields

Click into the new row and type directly into cells to populate field values. The cell that receives initial focus is determined by the hasFocus property in your sheet configuration: 
columns:
  title:
    title: Title
    width: 200
    hasFocus: true
Press Enter to commit the cell edit and move to the next cell.

​
Step 3: Configure Document Routing (Optional)

If your domain model defines constraints.create on the entity type, new work items are automatically routed to the correct Polarion document. For example: 
domainModelTypes:
  SystemRequirement:
    polarionType: sys_req
    constraints:
      create:
        document:
          moduleFolder: /System Requirements
          moduleName: SRS
          type: sys_req_spec
When a user creates a SystemRequirement, it is automatically placed in the document matching the specified folder, name, and type.
Use $context.source.document expressions to route new items based on the source entity’s document. This is useful when the same entity type should go to different documents depending on where it was created from.

​
Step 4: Review Before Saving

Before saving, use the review mode to inspect your pending changes:
  1. Click the Review toggle in the toolbar — it appears automatically when changes exist
  2. The sheet filters to show only rows with pending changes
  3. New rows are indicated with the Added state marker on the row header
Review FilterWhat It Shows
AddedNewly created rows not yet persisted
ModifiedExisting rows with changed values
DeletedRows marked for removal
ProblemsRows with validation errors

​
Step 5: Save Changes

Click the Save button in the toolbar. During the save operation:
  1. The sheet temporarily enters read-only mode to prevent concurrent edits
  2. Entities are saved in dependency order — parent entities before dependents
  3. Server-generated identifiers (such as objectId) are assigned to new items
  4. The undo stack is cleared on successful save
If the sheet is in an error state, the save operation is blocked. You will see a message instructing you to reload the browser. Resolve any errors before attempting to save.

​
Step 6: Verify

You should now see the new work item in the sheet with a server-assigned ID. The row header no longer shows the Added state indicator, and the Save button is disabled (no pending changes).
Open the corresponding Polarion LiveDoc to confirm the work item appears in the expected document location with the correct work item type.

​
See Also

Source Code
  • prod-powersheet-src/com.nextedy.powersheet.client/cypress/fixtures/models/permissions.yaml
  • prod-powersheet-src/com.nextedy.powersheet.client/cypress/fixtures/models/constraints_create_only.yaml
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/packages/sheet/commands/index.ts
  • DatabridgeMetadata.java
  • prod-powersheet-src/com.nextedy.powersheet.client/cypress/e2e/userFlows/multiple-entity-type-flow.cy.ts