Forum Discussion
jcurrie94
Aug 04, 2021Copper Contributor
Imported Excel File Columns not showing in form
Recently imported an excel file into a SP List everything imported successfully. However when I go to enter a new entry the columns that I imported aren't showing in the form. I tried to go to config...
kim_williams_kdub
Aug 10, 2021Copper Contributor
I'm seeing the same issue and haven't found any resolutions online yet. Has anyone else?
Couple notes:
1. Issue was not present a couple of weeks ago
2. After importing my excel document I only see the Title and Attachment fields on the new and edit forms. None of my imported excel fields are showing.
Couple notes:
1. Issue was not present a couple of weeks ago
2. After importing my excel document I only see the Title and Attachment fields on the new and edit forms. None of my imported excel fields are showing.
- Chris_McCannAug 10, 2021Copper Contributor
Okay - I have the answer:
- Go into the list Advanced settings and set 'Allow management of content types?' to YES
- When you leave the Advanced settings you'll see the Content type(s) showing on the screen above the columns you have
- Click on the content type (it's a link) - for me it was 'Item'
- Once into 'Item' I was able to add the columns imported via Excel, to the content type 'Item'
- After that - they showed up in the 'form view'
I hope it helps!
Chris
- Hobbes7373Aug 17, 2021Copper ContributorThank you Chris, worked like a charm.
- jcurrie94Aug 11, 2021Copper Contributor
Chris_McCann Hey Chris, After I enabled Allow Management of content types, my form is still not showing all the columns.
- ssh_SonyOct 13, 2021Copper ContributorI'm also still seeing this issue, even with "Allow Management of content types" enabled.
Any other considerations here Chris_McCann ?
- ldsimmonsswhrAug 10, 2021Copper ContributorThank you so much!!! This worked beautifully!