Feb 27 2020 01:01 AM - edited Feb 27 2020 04:28 AM
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
What I see (View)
What I see (List settings)
What they see (View)
What they see (List settings)
Feb 27 2020 10:01 PM
Feb 28 2020 01:50 AM
Thanks @Chris Webb.
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!