How can I get the internal colum names of a SharePoint list to appear the same as the display name?

New Contributor

I uploaded a file in MS Lists. Here is an image of the how the tables and columns look like:

HamidBee_0-1664510893506.png

When I upload the file onto SharePoint it shows me different column names. If I navigate to list settings I would see the following columns along with some new columns:

 

HamidBee_1-1664511294156.png

Does anyone know why these new columns are created and how we can avoid this?

Now I'm mindful that the column names shown above are 'column display names' and may not be the same as the 'internal column names'. I clicked on the 'CustomerNumber' column inorder to view the 'internal column name' and this was the result:

HamidBee_2-1664511546032.png

 

So the display name is 'CustomerNumber' and the internal name (actual column name) is 'Title'. Why does SharePoint do this and how can we avoid this from happening.

 

This became an issue when I imported this data into PowerApps. Some of the functions would require me to use the display name and others would require me to use the columns internal name. This would require me to constantly refer back to SharePoint to check and was really time consuming.

 

Any help would be greatly appreciated.

1 Reply

@HamidBee When you create a list in SharePoint, "Title" is the only required column in a list and it is a default column in SharePoint with "item" content type.

 

So, when you import the excel to list, it must be automatically mapping one of your columns to this default column.

 

Try adding one more column at the start ("A" column) in your excel with column heading as "Title". You can use same value as CustomerNumber in Title column or use combination of FirstName LastName - as per your requirements. Then try importing the excel file to SharePoint list.


Please click Mark as Best Response & Like 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.