O365 SharePoint List Column Names Corrupted

%3CLINGO-SUB%20id%3D%22lingo-sub-192410%22%20slang%3D%22en-US%22%3EO365%20SharePoint%20List%20Column%20Names%20Corrupted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-192410%22%20slang%3D%22en-US%22%3E%3CP%3EWhile%20trying%20to%20import%20a%20list%20into%20Power%20BI%2C%20I%20discovered%26nbsp%3Bthat%20most%20of%20the%20column%20names%20in%20one%20of%20the%20lists%20in%20one%20of%20our%20SharePoint%20team%20sites%20are%20corrupted.%20The%20display%20names%20are%20intact%2C%20it's%20the%20internal%20names%20that%20are%20affected.%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20attached%20a%20screenshot%20of%20what%20I%20was%20seeing%20in%20Power%20BI.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20the%20URL%20for%20what%20should%20be%20the%20%22Location%22%20column.%20The%20internal%20column%20name%20is%20showing%20up%20as%20%22uwbz%22%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmycompany.sharepoint.com%2Fsitecollection%2Fsitename%2F_layouts%2F15%2FFldEdit.aspx%3FList%3D%257BGUIDGUID-G...Field%3Duwbz%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmycompany.sharepoint.com%2Fsitecollection%2Fsitename%2F_layouts%2F15%2FFldEdit.aspx%3FList%3D%257BGUIDGUID-G...Field%3Duwbz%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20suspicion%20is%20that%20there%20was%20some%20sort%20of%20update%20going%20on%20when%20the%20list%20and%20columns%20were%20originally%20created.%20Because%20this%20is%20O365%20and%20evergreen%20by%20design%2C%20we%20have%20no%20real%20idea%20when%20updates%20are%20being%20applied%20and%20won't%20see%20these%20issues%20until%20we%20try%20to%20do%20something%20with%20them%2C%20like%20import%20into%20Power%20BI%20or%20Flow.%20In%20this%20case%20I%20re-created%20the%20list.%20That's%20not%20something%20we%20would%20want%20or%20should%20have%20to%20do...%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThoughts%2C%20Microsoft%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-192410%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EColumns%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-319714%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20SharePoint%20List%20Column%20Names%20Corrupted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-319714%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3ELori%3C%2FSTRONG%3E%20-%20Have%20you%20received%20input%20from%20Microsoft%20(or%20anyone%20else)%20on%20this%20subject%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20a%20topic%20I've%20pushed%20for%20almost%20a%20year%20(first%20reported%20in%20February%2C%202018)%20and%20have%20grown%20old%20and%20weary%20finding%20anyone%20willing%20to%20investigate%20it%2C%20much%20less%20discuss%20its%20resolution.%20If%20you%20have%20any%20news%20to%20share%20about%20your%20experience%2C%20please%20do.%20I%20can%20tell%20you%20the%20problem%20is%20quite%20real%2C%20often%20repeatable%2C%20and%20easily%20verifiable%20with%20web%20traffic%20traces%20of%20API%20communication%20between%20PowerBI%20and%20SPO.%20If%20and%20when%20you%20have%20the%20chance%20to%20discuss%20this%20with%20a%20Microsoft%20decision-maker%2C%20please%20let%20me%20know.%20I'll%20do%20the%20same.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-633917%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20SharePoint%20List%20Column%20Names%20Corrupted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-633917%22%20slang%3D%22en-US%22%3E%3CP%3EJust%20discovered%20this%20problem%20as%20well.%20This%20really%20needs%20to%20be%20corrected%2C%20since%20recreated%20sharepoint%20lists%20is%20such%20a%20pain.%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F145811%22%20target%3D%22_blank%22%3E%40Lori%20Hanley%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-710535%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20SharePoint%20List%20Column%20Names%20Corrupted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-710535%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F145811%22%20target%3D%22_blank%22%3E%40Lori%20Hanley%3C%2FA%3E%26nbsp%3B%20This%20is%20unbelievable.%26nbsp%3B%20This%20just%20happened%20to%20me%20in%20my%20SharePoint%20list%20and%20it%20is%20connected%20to%20PowerApps.%26nbsp%3B%20An%20internal%20column%20name%20called%20%22InternalStepNumber%22%20was%20changed%20to%20%22_x0076_gj5%22.%26nbsp%3B%20This%20is%20cause%20for%20serious%20concern.%26nbsp%3B%20Now%20in%20my%20PowerApps%20app%2C%20all%20my%20formulas%20reference%20these%20obscure%20internal%20column%20names%20and%20I%20am%20not%20able%20to%20tell%20what%20I'm%20looking%20at.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20are%20enterprise%20customers%20going%20to%20do%20when%20they%20start%20building%20apps%20and%20their%20naming%20conventions%20are%20built%20on%20sound%2C%20well%20thought%20out%20internal%20column%20names%20and%20Microsoft%20code%20changes%20the%20internal%20column%20names%3F%26nbsp%3B%20What%20is%20Microsoft%20going%20to%20do%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-711354%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20SharePoint%20List%20Column%20Names%20Corrupted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-711354%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89592%22%20target%3D%22_blank%22%3E%40Bill%20Kuhn%3C%2FA%3E%26nbsp%3BHow%20are%20you%20adding%20the%20columns%3F%20Are%20you%20using%20Quick%20Edit%20view%20and%20using%20the%20%2B%20symbol%3F%20If%20so%2C%20this%20would%20generate%20the%20internal%20columns%20as%20you%20describe.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-712429%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20SharePoint%20List%20Column%20Names%20Corrupted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-712429%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F39836%22%20target%3D%22_blank%22%3E%40Beau%20Cameron%3C%2FA%3E%26nbsp%3B%20Yup%20i%20have%20also%20noticed%20the%20same%2C%20If%20we%20create%20column%20being%20in%20Quick%20Edit%2C%20this%20type%20of%20weird%20internal%20name%20is%20stamped.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-745464%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20SharePoint%20List%20Column%20Names%20Corrupted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-745464%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F39836%22%20target%3D%22_blank%22%3E%40Beau%20Cameron%3C%2FA%3E%26nbsp%3B%20Ahhhh...that%20was%20it.%26nbsp%3B%20I%20learn%20something%20new%20everyday%2C%20this%20one%20just%20happened%20to%20be%20in%20the%20%22not%20fun%22%20learning%20category.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

While trying to import a list into Power BI, I discovered that most of the column names in one of the lists in one of our SharePoint team sites are corrupted. The display names are intact, it's the internal names that are affected. 

I've attached a screenshot of what I was seeing in Power BI. 

 

Example: 

This is the URL for what should be the "Location" column. The internal column name is showing up as "uwbz" 

https://mycompany.sharepoint.com/sitecollection/sitename/_layouts/15/FldEdit.aspx?List=%7BGUIDGUID-G...

 

My suspicion is that there was some sort of update going on when the list and columns were originally created. Because this is O365 and evergreen by design, we have no real idea when updates are being applied and won't see these issues until we try to do something with them, like import into Power BI or Flow. In this case I re-created the list. That's not something we would want or should have to do... 

 

Thoughts, Microsoft? 

 

 

 

 

6 Replies
Highlighted

Lori - Have you received input from Microsoft (or anyone else) on this subject?

 

This is a topic I've pushed for almost a year (first reported in February, 2018) and have grown old and weary finding anyone willing to investigate it, much less discuss its resolution. If you have any news to share about your experience, please do. I can tell you the problem is quite real, often repeatable, and easily verifiable with web traffic traces of API communication between PowerBI and SPO. If and when you have the chance to discuss this with a Microsoft decision-maker, please let me know. I'll do the same.

Highlighted

Just discovered this problem as well. This really needs to be corrected, since recreated sharepoint lists is such a pain.@Lori Hanley 

Highlighted

@Lori Hanley  This is unbelievable.  This just happened to me in my SharePoint list and it is connected to PowerApps.  An internal column name called "InternalStepNumber" was changed to "_x0076_gj5".  This is cause for serious concern.  Now in my PowerApps app, all my formulas reference these obscure internal column names and I am not able to tell what I'm looking at. 

 

What are enterprise customers going to do when they start building apps and their naming conventions are built on sound, well thought out internal column names and Microsoft code changes the internal column names?  What is Microsoft going to do?

Highlighted

@Bill Kuhn How are you adding the columns? Are you using Quick Edit view and using the + symbol? If so, this would generate the internal columns as you describe.

Highlighted

@Beau Cameron  Yup i have also noticed the same, If we create column being in Quick Edit, this type of weird internal name is stamped.

 

Highlighted

@Beau Cameron  Ahhhh...that was it.  I learn something new everyday, this one just happened to be in the "not fun" learning category.