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%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%3CLINGO-SUB%20id%3D%22lingo-sub-1978042%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20SharePoint%20List%20Column%20Names%20Corrupted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1978042%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F168897%22%20target%3D%22_blank%22%3E%40Bill%20Kuhn%3C%2FA%3E%26nbsp%3B%3B%26nbsp%3B%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%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F356092%22%20target%3D%22_blank%22%3E%40Tausif_Jamkhandi%3C%2FA%3E%26nbsp%3B%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%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWell%2C%20from%20October%202018%20to%20December%202020%20and%20this%20has%20still%20not%20been%20fixed.%20I%20have%20just%20moved%20over%20to%20Office%20365%20from%20SharePoint%20on-Premise%20so%20was%20not%20aware%20of%20this%20problem%20until%20I%20created%20a%20list%20with%201%2C984%20items!%20Tried%20to%20create%20a%20power%20automate%20workflow%20and%20a%20power%20BI%20report%20and%20now%20from%20reading%20your%20posts%20(Thank%20YOU)%20I%20have%20to%20create%20a%20new%20column%20and%20copy%20everything%20over%20into%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20is%20Microsoft%20going%20to%20get%20their%20systems%20sorted!!%3C%2FP%3E%3C%2FLINGO-BODY%3E
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? 

 

 

 

 

8 Replies

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.

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

@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?

@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.

@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.

 

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

@Bill Kuhn ; @Lori Hanley @Tausif_Jamkhandi @Beau Cameron 

 

Well, from October 2018 to December 2020 and this has still not been fixed. I have just moved over to Office 365 from SharePoint on-Premise so was not aware of this problem until I created a list with 1,984 items! Tried to create a power automate workflow and a power BI report and now from reading your posts (Thank YOU) I have to create a new column and copy everything over into it.

 

When is Microsoft going to get their systems sorted!!