Create Details Table

Create Details Table is a one-line activity you place near the start of your workflow. It outputs an empty DataTable with the exact column names and types that Send Report expects, so you don't need to remember the schema or build the table by hand.

Properties

Output

Property	Required	Type	Description
Details Table	Yes	`DataTable`	An empty table named `RPAWatchDetails` containing the six columns described below.

Table schema

Column	Type	Notes
`sequence_no`	`Int32`	1-based row number. Required by Send Report when the table is non-empty.
`record_id`	`String`	Optional unique identifier for the record (e.g. `INV-1001`).
`record_name`	`String`	Optional human-readable name.
`status`	`String`	`success` or `failed`. Used by Send Report to auto-calculate the overall run status.
`result`	`String`	Optional result message for successful records.
`error_message`	`String`	Optional error message for failed records.

You should always populate this table with Add Detail Row — that activity normalizes status to lowercase and ensures the column names match. If you fill it manually with Add Data Row, take care to match the column names exactly; otherwise Send Report will silently drop fields it cannot recognize.

Example

The classic shape: create the table once, then populate it row-by-row inside a For Each Row. Studio 2026 projects use C# expressions by default.

Create Details Table   →   detailsTable
For Each Row in Data Table  (excelDataTable → currentDataRow,
                             CurrentIndex → index)

    Add Detail Row
        Details Table = detailsTable
        Sequence No   = index
        Record ID     = currentDataRow["InvoiceNo"].ToString()
        Record Name   = currentDataRow["Vendor"].ToString()
        Status        = currentDataRow["Flow Status"].ToString() == "Completed"
                          ? "success" : "failed"
        Result        = currentDataRow["Log"].ToString()
        Error Message = currentDataRow["Error"].ToString()

The same detailsTable is then passed to Send Report at the end of the workflow. Binding Sequence No to For Each Row's CurrentIndex keeps your sequence numbers dense without a manual counter.