Forum Discussion
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 date column but can't seem to figure out how to make that happen.
Thanks for any help.
16 Replies
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
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.TextWhen 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)
- One thing to keep in mind about the title column: If you delete a list item - this is the only information you see in the Recycle Bin. So it can be important to put information here that helps identify the item if you need to recover something you have deleted.
I often customise my list with a power app form and I have the Title field automatically populated with info concatenated from other fields.Fleur Williamson do you have a short video on this. 🙂
Fleur Williamson how do you auto-format your list like this? can you give information?
isa_osman When I customize the List form using PowerApps, I then set the default value of the Title datacard to a formula that pulls information from the other fields.
Eg: To show the app name and date:
"[application name] - " & Now()
You could include the ID field - but that wouldn't update until the second save as it doesn't yet exist until saved.
This is a default column in SharePoint lists which comes with the Item content type. You cannot change it's data type. As RobElliott said, if you need any other text column in your list then you can rename Title column and use it for that.
You can change the order of columns in list view and list form to show the date column as first column.
Also, if you don't want this field in your list then you can hide it from list form as well as from list view.
Please click Mark as Best Response if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Hello ganeshsanap,
Do you know if it is possible, somehow, to enforce unique values in this default column? I have been using it to assign unique ticket numbers for each issue that comes my way. Since I have many, many items in this list, it is tedious and prone to human error to make sure I don't assign the item an already used number. I can't see how to do this since there is no Edit option for the default column.
Thank you!
lriscald go to List Settings and you can enforce unique values for any column there:
But there's another approach you might want to consider. In our IT Ticket system we use the ID column. The ID number is set by SharePoint so you don't have to do it manually, it can't be changed and is always unique. And that is the number that is used as the ticket number throughout the system, for example when the user initially submits the ticket the list item is created and an email is sent back to the user by a flow in Power Automate with the details of what they submitted and their unique ticket number. And it's used in all other communications about the ticket as well.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
- It's a system column and the type cannot be changed
jcgonzalezmartin Thank you. So how do most people deal with it? Ignore it?
slohombre you can ignore it, rename it to something else where you want a single of text column, just not change the type as jcgonzalezmartin said.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
