First

This Flow Script tutorial explains how to use the First function with syntax and examples.

Description‌

The First function returns the first record in the table. If the table is empty, an error is thrown.

Syntax

‌The syntax for the First function is:

First(table)

‌Parameters

table - the table with the data from which the first row is to be taken.

Returns

‌The First function returns a record.

Example‌

Let's look at some First function examples and explore how to use the First function.‌

Example table: colors

First(colors)
Result: Id: C1, Color: red - as Record

colors.First()
Result: Id: C1, Color: red - as Record

First([col: "A"] & [col: "B"])
Result: [col: "A"] - as Record