Feb 27 2020 01:01 AM - last edited on Nov 09 2023 11:09 AM by
Hi community,
I noticed that in a recent created SharePoint Online site, that when I rename columns, I (as creator) see the new names, but every other site member see the original column names.
What I did:
Because SharePoint stores column names that contain spaces as "_x0020_", which is very annoying when trying to read data from the back-end. I create new list- and content type columns in lowercase format without spaces. When I'm done creating content types and columns, I rename the columns to a friendly name and create the views.
I searched online, but I can't find similar topics. Any idea or help is appreciated.
Regards,
Paul
Feb 27 2020 10:01 PM
Feb 28 2020 01:50 AM
Thanks @ChrisWebbTech.
I tried clearing browser and the shift F5 with a user. I also tried inviting a new user, the same results there. Going to try out your suggestion to change the column name in the content type and to create a new view.
Feb 28 2020 02:33 AM
Feb 28 2020 03:06 AM
Feb 28 2020 08:57 AM
Mar 03 2020 05:23 AM
Thanks for thinking along Chris. I submitted this issue to Microsoft. Maybe it's a problem on my end, or I'm doing something wrong.
Mar 10 2020 02:10 AM
I spent several hours on the phone with Microsoft to look into the problem and we manage to solve it. We looked at a number of solutions:
Solution 1: Forcing and executing column indexing
Solution 2: Creating a search scheme
This option re-indexes columns. Check if other members of this site see the new column names.
Solution 3: Check site features
When I create a new site in SharePoint I turn off unnecessary features by default. Features like "create new pages", "site notepad", "social features", and some more unnecessary features.
Apparently, column names are not updated for other site members and visitors if a feature (I suspect the "create new pages" option) is not enabled. In the end, this was the solution for me.
Mar 10 2020 08:12 AM
Jul 24 2020 12:48 AM
SolutionUpdate July 2020:
I still had this issue with new sites and almost gave up on troubleshooting. I had a brainstorm with another SharePoint minded person and it became clear that the language template might be a thing.
When you visit a website, the language in which the browser is set determines the language in which the content is displayed. If the website offers content based on language of course. With modern browsers you have the option to support multiple languages, like spell check and browser interface. My native language is Dutch, but I set my browser to English to read Microsoft Docs in English (the machine translation is absolutely horrible).
Now back to SharePoint. I create a site, make content types and columns, create libraries and lists and all that in my English browser. Most of my colleagues all have browsers with their interface set to Dutch. And here's where things go wrong. All Dutch visitors see the columns in their old ("ugly") name. When I change the user's UI language to English, *poof* all columns are in the correct "fancy" names.
So in conclusion, I have to rename all columns in two different languages, and more if we want to support other languages for our visitors as well....
Jul 29 2020 07:21 AM
Jul 30 2020 06:24 AM
I am having the same issue here. Could you explain how and where do users need to change the language to display the correct names? I tried changing mine in the browser and in myaccount.microsoft.com to recreate the problem but I keep viewing everything correctly.
Also I was wondering if this issue could cause other problems. In my case, the sharepoint list is connected to some flows and the from is customized using powerapps.There are some weird bugs that happened only to the one user who sees the internal names of the columns...
thanks!
Sep 02 2020 03:03 AM
Dec 15 2020 02:35 AM
Hi, just noticed your question, sorry. Don't change the language settings on the back-end (i.e. SharePoint, Office.com or Delve).
In Edge/Chrome you can change the language settings of your browser. The first language is used to tell the website that you visit in what language you want the content presented in. So if Dutch is your primary language, set it to Dutch.
If you have, for example, English branches of your office, and you want to create/rename columns, you have to change the language from Dutch to English and rename the columns again. I set Edge language to Dutch and Firefox (my main browser) language to English. This is the only way I know of to make sure that columns have the same visual name in both languages.
Dec 16 2020 11:42 PM
Jun 24 2022 05:21 AM
@Minus50DKP Thanks for sharing this info, it really helped me a lot! I changed the primary language to English, and everything works fine now!
Aug 16 2022 09:16 PM
@Minus50DKP Thanks for sharing this here saved lot of time for us am also facing same issue
I created List and columns without spaces in English and renamed it to user friendly in Japanese, but problem is Japanese clients are not able to see actual renamed column name its showing old English names for them please guide me solution if you found any latest. Thanks again
Feb 08 2023 04:34 AM
I think Microsoft is aware of this issue. In newly created SharePoint sites there are options available to set the navigation links for specific languages, and also for new columns:
When I hover over the information icon, you see this:
But this is only for quick navigation links (the menu on the left) and is far from perfect. I noticed Microsoft is working on columns too, but it's not general available (as far as I know).
In Powershell you can create columns like this:
$Url = #URL of the site you want to modify
$FieldName = #The name of your column that you want to present to the visitor
$InternalName = #The name you give to create your column (and can't be modified)
$DataType = #What kind of datatype you want to use for your column, ie 'Choice' to create a choicefield
$Group = #The group (if applicable) that this column will belong to
$Connection = Connect-PnPOnline -Url $Url -Interactive -ReturnConnection
Add-PnPField -List $List -Type $Datatype -DisplayName $FieldName -InternalName $InternalName -Group $Group -Connection $Connection
(More info: https://pnp.github.io/powershell/cmdlets/Add-PnPField.html
But this will only be useful for one language. I haven't found a way to do this for N>1 languages
2 Years later, this is still a pain in the rear-end to manage.
Jun 25 2023 01:41 PM - edited Jun 26 2023 01:44 PM
I think, I ran into another strange symptom of this bug. The problem itself is the same. I create new columns without blanks and special characters, then rename them afterwords. Never had an issue with that, up until this one new list. It surfaces in three different ways:
1. Like all the others here, new colums are shown only with their first name. Renaming is not displayed
2. Now it gets strange. I also renamed the very first column "Title", then renamed it again, as i repurposed that column. Guess what, it sticks to the first rename now all the time.
3. Really strange. Same for the list name. Left out the blank initially, renamed it with blank. Gets only displayed without blank.
So testing with other colleagues might also hint into the language/regional settings corner. I am German working on an english laptop. But my fellow Germans on german laptops have the same issue. My IT support from India does not have the issue. Couldn´t get a real pattern here.
BUT what I could figure out: Once I clear the browser cache, I get all the renamed column names. Once I hit refresh, all the initial names are back. Also, when opening the list, for a very very brief moment the correct names are displayed, then instantly overwritten with the initial name. Same behavior on Edge and Firefox. So it is somehow down to the Cache, but I have no better means then clearing it. Any idea?
Jun 26 2023 01:43 PM
Jul 24 2020 12:48 AM
SolutionUpdate July 2020:
I still had this issue with new sites and almost gave up on troubleshooting. I had a brainstorm with another SharePoint minded person and it became clear that the language template might be a thing.
When you visit a website, the language in which the browser is set determines the language in which the content is displayed. If the website offers content based on language of course. With modern browsers you have the option to support multiple languages, like spell check and browser interface. My native language is Dutch, but I set my browser to English to read Microsoft Docs in English (the machine translation is absolutely horrible).
Now back to SharePoint. I create a site, make content types and columns, create libraries and lists and all that in my English browser. Most of my colleagues all have browsers with their interface set to Dutch. And here's where things go wrong. All Dutch visitors see the columns in their old ("ugly") name. When I change the user's UI language to English, *poof* all columns are in the correct "fancy" names.
So in conclusion, I have to rename all columns in two different languages, and more if we want to support other languages for our visitors as well....