Use the NAME function to convert a list item to a text data type.
Syntax
NAME(List item)
Arguments
| Argument | Data type | Description |
| List item | List | The list item to convert to a text data type. |
The NAME function returns a text result.
Syntax example
NAME(Month period)
This formula converts the value in the Month period line item into text.
Excel Equivalent
Examples
Convert list items to a Text data type
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.
| Parent | Code | Start month | Start year | |
| Alice | Jan 21 | FY21 | ||
| Bob | Jul 25 | FY25 | ||
| Carol | Sep 22 | FY22 | ||
| Dan | Jan 24 | FY24 | ||
| Ellie | Apr 23 | FY23 | ||
| Felix | Aug 25 | FY25 |
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, andNAME()converts those items to Text.
- This line item has the formula
- Start month, Text data type.
- This line item has the formula
NAME(Employees.Start month). Here,Employees.Start monthreturns the list items from the Start month property of the Employees list, andNAME()converts those items to Text.
- This line item has the formula
- Start year, Text data type.
- This line item has the formula
NAME(Employees.Start year). Here,Employees.Start yearreturns the list items from the Start year property of the Employees list, andNAME()converts those items to Text.
- This line item has the formula
| Alice | Bob | Carol | Dan | Ellie | Felix | |
NameNAME(ITEM(Employees)) | Alice | Bob | Carol | Dan | Ellie | Felix |
Start monthNAME(Employees.Start month) | Jan 21 | Jul 25 | Sep 22 | Jan 24 | Apr 23 | Aug 25 |
Start yearNAME(Employees.Start year) | FY21 | FY25 | FY22 | FY24 | FY23 | FY25 |