Edit

Share via


LISTOFFIRSTITEM ER function

Note

Community interest groups have now moved from Yammer to Microsoft Viva Engage. To join a Viva Engage community and take part in the latest discussions, fill out the Request access to Finance and Operations Viva Engage Community form and choose the community you want to join.

The LISTOFFIRSTITEM function returns a Record list value that consists of only the first record of the specified list.

Syntax

LISTOFFIRSTITEM (list)

Arguments

list: Record list

The valid path of a data source of the Record list data type.

Return values

Record list

The resulting list of records.

Example

The expression FIRST( LISTOFFIRSTITEM ( SPLIT ("ABC",1))).Value returns the text value "A".

Additional resources

List functions