Use the NAME function to convert a list item to a text data type.

NAME(List item)

ArgumentData typeDescription
List itemListThe list item to convert to a text data type.

The NAME function returns a text result.

NAME(Month period)

This formula converts the value in the Month period line item into text.

T

NAME function converts list items and time-formatted list items to text.

Source list

This example uses a list named Employees, shown below in the Grid View.


ParentCodeStart monthStart year
Alice

Jan 21FY21
Bob

Jul 25FY25
Carol

Sep 22FY22
Dan

Jan 24FY24
Ellie

Apr 23FY23
Felix

Aug 25FY25

Here, the properties Start month and Start year are in Month and Year format, respectively.

Target module

The target module Employee details is dimensioned over the above list, Employees. The module has the list Employees on the columns. It has five line items on the rows:

  • Name, Text data type.
    • This line item has the formula NAME(ITEM(Employees)). Here, ITEM(Employees) returns the list items from the Employees list, and NAME() converts those items to Text.
  • Start month, Text data type.
    • This line item has the formula NAME(Employees.Start month). Here, Employees.Start month returns the list items from the Start month property of the Employees list, and NAME() converts those items to Text.
  •  Start year, Text data type.
    • This line item has the formula NAME(Employees.Start year). Here, Employees.Start year returns the list items from the Start year property of the Employees list, and NAME() converts those items to Text.

AliceBobCarolDanEllieFelix
Name
NAME(ITEM(Employees))
AliceBobCarolDanEllieFelix
Start month
NAME(Employees.Start month)
Jan 21Jul 25Sep 22Jan 24Apr 23Aug 25
Start year
NAME(Employees.Start year)
FY21FY25FY22FY24FY23FY25