Forum Discussion
SharePoint Online List connector - column names change depending on user
Hi Anonymous ,
What are the ”display names“ and ”internal names“ of the list's custom columns you mentioned?
The result of my own test is that if I choose a language other than English (such as Polish) when creating my SharePoint site, then when using the 2.0 connector to connect to the site, except for some data I created in English in the site, the other column names are displayed in Polish, and the content in the column is displayed in the language set by my browser, and the column names of the data columns I created myself are in English.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous,
when you add a column to a SharePoint list and give it a name, that name becomes the internal name of the column. As far as I know, you cannot change the internal name of the column. Of course, you can change the (display) name of the column, and it will appear in the list under the new name, but it's internal name will always be the same.
For example, if you add a column and name it FxRate, this will be the internal name of the column. If you then rename the column to, say, Exchange Rate (I refer to this changed name as the display column name), it will appear in the SharePoint list (and most other applications) under the changed name, but in some applications it will still be referenced by its internal name. For instance, if you sort the column, you should notice that it is referenced by its internal name in the URL.
So, my issue is that when a (member) user runs the report, Power Query returns the display name. However, when a guest user runs the same query, internal names are returned. There is also that issue with the list system columns being translated for a (member) user.
This happens in implementation 2.0. In implementation 1.0, only internal names are returned.