Forum Discussion

slohombre's avatar
slohombre
Brass Contributor
Jan 29, 2021

Role of "Title" Column in SharePoint Lists - Can't change column type?

When I start a new list in Sharepoint, I always get a "Title" column and I can't change the type from the default "Text" type. What is the role of the "Title" column? I'd like my first column to be a...
Lists
SharePoint Online
Todd Lane's avatar
Todd Lane
Brass Contributor
May 23, 2022

Is there a way to make this column (Title Column) calculated based off of other fields in the list?

 

My use case is the title column would be full name and I have 2 other text columns called First Name and last Name.

The same formula that works in a calculated column is throwing an error when trying to use the Calculated Value.

 

Thanks

  • RobElliott's avatar
    RobElliott
    Silver Contributor
    May 23, 2022

    Todd Lane you can't change the column type to be a calculated column. But if you change the form settings so that you are using a Power Apps customised form you can get the Title column automatically populated with the data in the FirstName and LastName columns.

     

    I've changed the names of the FirstName and LastName controls in the form to dataFirstname and dataLastname. Then in the Title control I've set the default property to
    dataFirstname.Text&" "&dataLastname.Text

     

     

    When you save the form it will automatically save the Title column as well with the firstname and lastname.

     

     

    Rob
    Los Gallardos
    Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Resources