Sharepoint List reordering issue

%3CLINGO-SUB%20id%3D%22lingo-sub-2681289%22%20slang%3D%22en-US%22%3ESharepoint%20List%20reordering%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2681289%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20having%20an%20issue%20with%20a%20list%20I%20am%20trying%20to%20format.%20It%20has%20around%20100%20fields.%20When%20I%20view%20it%20in%20Sharepoint%2C%20it%20appears%20correctly%2C%20with%20the%20columns%20in%20the%20correct%20order.%20When%20I%20export%20the%20list%20to%20Excel%2C%20it%20appears%20identically.%3CBR%20%2F%3E%3CBR%20%2F%3EHowever%20when%20someone%20clicks%20%22New%22%2C%20to%20create%20a%20new%20entry%20in%20the%20list%2C%20the%20fields%20are%20in%20a%20completely%20different%20order%20(they%20appear%20to%20be%20in%20the%20order%20I%20created%20them%20in).%20I%20can%20drag%20and%20drop%2C%20or%20manually%20%22Move%20Up%22%20or%20%22Move%20Down%22%20each%20item%2C%20but%20when%20I%20click%20%22Save%22%20it%20doesn't%20appear%20to%20save%20them.%20The%20fields%20remain%20in%20the%20wrong%20order%20in%20the%20%22New%20item%22%20view%2C%20and%20exiting%20and%20re-entering%20this%20view%20doesn't%20help.%3CBR%20%2F%3E%3CBR%20%2F%3EDoes%20anyone%20know%20what%20might%20be%20causing%20this%20issue%3F%20It%20makes%20data%20entry%20effectively%20impossible%20and%20highly%20error%20prone%2C%20as%20my%20users%20have%20to%20scroll%20up%20and%20down%20the%20list%20constantly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers.%3CBR%20%2F%3E%3CBR%20%2F%3ERob.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEDIT%3A%20It%20appears%20that%20if%20I%20click%20New%20to%20create%20a%20new%20item%20in%20the%20list%2C%20then%20edit%20the%20columns%20in%20the%20form%20from%20the%20item%2C%20then%20save%20the%20item%20and%20open%20it%2C%20it%20will%20SOMETIMES%20remember%20the%20fact%20that%20I've%20made%20these%20changes%20and%20permanently%20save%20them.%20Keen%20to%20know%20if%20there%20is%20a%20better%20solution%20than%20this%20though.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2681289%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi all,

 

I'm having an issue with a list I am trying to format. It has around 100 fields. When I view it in Sharepoint, it appears correctly, with the columns in the correct order. When I export the list to Excel, it appears identically.

However when someone clicks "New", to create a new entry in the list, the fields are in a completely different order (they appear to be in the order I created them in). I can drag and drop, or manually "Move Up" or "Move Down" each item, but when I click "Save" it doesn't appear to save them. The fields remain in the wrong order in the "New item" view, and exiting and re-entering this view doesn't help.

Does anyone know what might be causing this issue? It makes data entry effectively impossible and highly error prone, as my users have to scroll up and down the list constantly.

 

Cheers.

Rob.

 

EDIT: It appears that if I click New to create a new item in the list, then edit the columns in the form from the item, then save the item and open it, it will SOMETIMES remember the fact that I've made these changes and permanently save them. Keen to know if there is a better solution than this though.

1 Reply

@RobBirnie in the list click +New and then click the pen & paper icon in the top right and select Edit columns. You can then drag columns to re-order them and de-select any that you don't want the user to see when they are adding the new item.

 

editColumns1.png

 

editColumns2.png

 

But... a health warning: I believe there is a column number limit after which this option won't be available and the adding or editing of items will revert to classic mode for the form. It has happened on one of my list forms. Trouble is I don't know what the maximum number of columns is before that  happens.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)