The RowId()
function returns the ID of the current row of a list.
Any database list also has a numeric [ID] field which holds the numeric primary key value for each row and gets automatically incremented on each add new row action. When you use that ID field in your expressions, you will see it in the form [12345: ID]
, which does not make it immediately clear which field (or rather, which list) you are pointing to. Other fields use the Technical Name in expressions, which helps to understand where they are coming from. When using the RowId(list) function in expressions, you will see immediately to which list you are referring, so this makes it far more usable.
A RowId of a List-item has multiple forms:
directly displaying in a label, will use the ToString() version, and yields the combined identifying information for the List and the Row;
with the ToNumber() function, it will yield the numeric id value - same as the numeric [ID] field;
This function is SQL compatible. For more information about SQL compatibility, see our documentation.
The Row ID value of one of the following:
The current row of a list (when using the List as parameter)
The referenced row of a reference field (when using a reference field as parameter)
Name | Type | Required | Description |
---|---|---|---|
list
List
a list from the data-model
reference
reference field
a reference field