Unable to edit or save List View in SharePoint - "Phantom Column"

%3CLINGO-SUB%20id%3D%22lingo-sub-979411%22%20slang%3D%22en-US%22%3EUnable%20to%20edit%20or%20save%20List%20View%20in%20SharePoint%20-%20%22Phantom%20Column%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-979411%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20site%20that%20is%20made%20up%20primarily%20of%20several%20lists.%20Late%20last%20week%2C%20I%20stumbled%20upon%20an%20issue%20with%20one%20of%20the%20lists%20that%20prevented%20me%20from%20editing%20the%20list's%20View%2C%20or%20saving%20the%20current%20view%20under%20a%20new%20name.%20This%20is%20the%20screen%20I%20get%20when%20I%20click%20on%20the%20dropdown%20%22edit%20view%3A%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F154710i9898383DA0CFC3A5%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22error.JPG%22%20title%3D%22error.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83And%20this%20is%20the%20error%20I%20get%20when%20trying%20to%20save%20the%20current%20view%20under%20a%20new%20name%20(the%20view's%20name%20is%20the%20default%20%22All%20Items%2C%22%20and%20my%20new%20name%20is%20%22TestView%22)%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F154711i241DD32F948EB1E2%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22column%20does%20not%20exist.JPG%22%20title%3D%22column%20does%20not%20exist.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83The%20thing%20that%20struck%20me%20was%20the%20note%20%22Column%20'Listapprovaldateby_x005b_jobtitl0'%20does%20not%20exist.%22%3CBR%20%2F%3EAt%20one%20point%20I%20had%20two%20%22approval%22%20columns%20in%20my%20list.%20One%20was%20titled%20%22List%20Approval%20Date%20by%20%5B%20job%20title%201%20%5D%22%2C%20and%20the%20other%20titled%20%22List%20Approval%20Date%20by%20%5B%20job%20title%202%20%5D%22.%20I%20then%20decided%20that%20two%20separate%20columns%20were%20not%20needed%2C%20so%20I%20deleted%20%22List%20Approval%20Date%20by%20%5B%20job%20title%202%20%5D%22%20and%20renamed%20the%20first%20column%20to%20%22List%20Approval%20Date%20by%20Both%20Job%20Titles.%22%3CBR%20%2F%3EAfter%20the%20deletion%20of%20one%20and%20renaming%20of%20the%20other%2C%20the%20issue%20began%20occurring.%3CBR%20%2F%3E%3CBR%20%2F%3EMy%20guess%20is%20that%20I%20have%20somehow%20left%20a%20%22phantom%20column%22%20somewhere%20on%20this%20list%20but%20have%20no%20access%20to%20it%2C%20and%20neither%20does%20SharePoint%2C%20so%20it%20freaks%20out%20whenever%20it%20tries%20to%20look%20at%20a%20view.%20But%20I%20have%20no%20idea%20of%20how%20to%20clear%20out%20the%20phantom%20or%20how%20to%20save%2Fedit%20the%20view%20otherwise.%3CBR%20%2F%3E%3CBR%20%2F%3E(note%3A%20as%20far%20as%20i%20can%20tell%2C%20no%20other%20functions%20on%20the%20list%20or%20site%20have%20been%20affected%20apart%20from%20editing%20the%20view%20of%20this%20particular%20list.%20Also%20there%20is%20no%20evidence%20of%20the%20%22phantom%22%20column%20in%20any%20advanced%20setting%20or%20column%20list%20in%20the%20settings.)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-979411%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESites%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-983492%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20edit%20or%20save%20List%20View%20in%20SharePoint%20-%20%22Phantom%20Column%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-983492%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F442125%22%20target%3D%22_blank%22%3E%40Wesley_Hotzfeld%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22Listapprovaldateby_x005b_jobtitl0%22%20is%20the%20internal%20column%20name.%20I'm%20guessing%20for%20%22List%20Approval%20Date%20by%20%5B%20job%20title%202%20%5D%22.%20When%20you%20rename%20a%20column%20the%20the%20internal%20name%20remains%20the%20same.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAssuming%20the%20list%20has%20not%20exceeded%20thresholds%2C%20you%20should%20be%20able%20to%20edit%20or%20create%20a%20new%20view%20via%20%22List%20Properties%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20this%20persists%20I%20would%20contact%20MS%20support.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20its%20not%20much%20but%20I%20hope%20this%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENorm%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a site that is made up primarily of several lists. Late last week, I stumbled upon an issue with one of the lists that prevented me from editing the list's View, or saving the current view under a new name. This is the screen I get when I click on the dropdown "edit view:"

 

error.JPG

 And this is the error I get when trying to save the current view under a new name (the view's name is the default "All Items," and my new name is "TestView"):

column does not exist.JPG

 The thing that struck me was the note "Column 'Listapprovaldateby_x005b_jobtitl0' does not exist."
At one point I had two "approval" columns in my list. One was titled "List Approval Date by [ job title 1 ]", and the other titled "List Approval Date by [ job title 2 ]". I then decided that two separate columns were not needed, so I deleted "List Approval Date by [ job title 2 ]" and renamed the first column to "List Approval Date by Both Job Titles."
After the deletion of one and renaming of the other, the issue began occurring.

My guess is that I have somehow left a "phantom column" somewhere on this list but have no access to it, and neither does SharePoint, so it freaks out whenever it tries to look at a view. But I have no idea of how to clear out the phantom or how to save/edit the view otherwise.

(note: as far as i can tell, no other functions on the list or site have been affected apart from editing the view of this particular list. Also there is no evidence of the "phantom" column in any advanced setting or column list in the settings.)

1 Reply

Hi @Wesley_Hotzfeld,

 

"Listapprovaldateby_x005b_jobtitl0" is the internal column name. I'm guessing for "List Approval Date by [ job title 2 ]". When you rename a column the the internal name remains the same.

 

Assuming the list has not exceeded thresholds, you should be able to edit or create a new view via "List Properties".

 

If this persists I would contact MS support.

 

I know its not much but I hope this helps.

 

Norm