Forum Discussion
Sharepoint list can't rename Column Address:City
Hi
When i create a list with a Location Column named Address it create an Adress:City Column that pulled the City from the Address field.
I can't find a way to remane the Address:City to City only.
Any way to do it ?
Andre
Hi AndyPeper ,
This is a little bit tricky.First you need to get the internal name of the column you want to rename.
In this example I assume that that is the field "Address: City"
1) Open this URL in your browserhttps://<yourtenant>.sharepoint.com/sites/<yoursite>/_api/web/lists/getbytitle('<yourlisttitle>')/fields?$select=InternalName&$filter=Title eq 'Address: City'You get a short XML Document.
Try to find the "Internal Name" property....<d:InternalName>City</d:InternalName>....So in this example the internal name for that field is "City"
2) Go to your list and select "Gear"->"List Settings" and then select any field from the columns section. In this example I choose "Title" (but it does not matter which field you choose)Now you are editing the "Title" field
Take a look at your URL. It will look like thishttps://<yourtentan>.sharepoint.com/sites/<yoursite>/_layouts/15/FldEdit.aspx?List=%7BC48CC4EF-BC51-44BB-BC4C-2FEC1F1EF370%7D&Field=TitleRemove the "Title" at the end and replace it with the internal name of your field (In my example "City").
https://<yourtentan>.sharepoint.com/sites/<yoursite>/_layouts/15/FldEdit.aspx?List=%7BC48CC4EF-BC51-44BB-BC4C-2FEC1F1EF370%7D&Field=City
Now you can rename that column to whatever you like.
Best Regards,
Sven
Hi,
You cannot rename projected fields that are coming from lookup columns
Hi AndyPeper ,
This is a little bit tricky.First you need to get the internal name of the column you want to rename.
In this example I assume that that is the field "Address: City"
1) Open this URL in your browserhttps://<yourtenant>.sharepoint.com/sites/<yoursite>/_api/web/lists/getbytitle('<yourlisttitle>')/fields?$select=InternalName&$filter=Title eq 'Address: City'You get a short XML Document.
Try to find the "Internal Name" property....<d:InternalName>City</d:InternalName>....So in this example the internal name for that field is "City"
2) Go to your list and select "Gear"->"List Settings" and then select any field from the columns section. In this example I choose "Title" (but it does not matter which field you choose)Now you are editing the "Title" field
Take a look at your URL. It will look like thishttps://<yourtentan>.sharepoint.com/sites/<yoursite>/_layouts/15/FldEdit.aspx?List=%7BC48CC4EF-BC51-44BB-BC4C-2FEC1F1EF370%7D&Field=TitleRemove the "Title" at the end and replace it with the internal name of your field (In my example "City").
https://<yourtentan>.sharepoint.com/sites/<yoursite>/_layouts/15/FldEdit.aspx?List=%7BC48CC4EF-BC51-44BB-BC4C-2FEC1F1EF370%7D&Field=City
Now you can rename that column to whatever you like.
Best Regards,
Sven
