ProblemYou receive error while creating custom List using Excel spreadsheet using SharePoint Online Modern interface.
Error occurs when you upload a file from device or choose file already on site, on the screen which says 'Check the column types below and choose a new type if the current selection is incorrect'.
Title is a required filed and can't be empty.
AnalysisLists have Title column as mandatory. The Title is clickable link which takes you to the list item details by opening the display form. Though you are allowed to select any column type, try keeping it as single line of text.
This error occurs when the excel column/header which is selected as Title contains empty entry.
Solution/FixMake sure your excel data is correct and in the format that SharePoint expects -
- Does not contain blank rows.
- More importantly, the column which you select as Title should not have blank cells/entries.
- Title is always mandatory, so you cannot have blank values here.
- Fix all blank entries in excel (for Title column) and re upload.
More Posts related to SharePoint,
- Setup synonyms or alias or thesaurus in SharePoint
- How to redirect SharePoint Site Collection to different URL
- How to hide quick launch in SharePoint
- SharePoint 2010 DataForm Unable to display this Web Part System.StackOverflowException
- SharePoint Server 2016 Preview installation error - This Product Key isn't a valid Microsoft Office 2016 Product Key. Check that you've entered it correctly.
- How to delete SharePoint List Item programmatically
- SharePoint Server 2016 IT Preview Deprecated Removed features
- Create SharePoint Site Collection using PowerShell New-SPSite
- How to create SharePoint List Item programmatically
- See actual SharePoint error exception modify web.config
- SharePoint Server 2016 installation System Hardware requirements
- [Solved] SharePoint Illegal operation attempted on a registry key that has been marked for deletion
- SharePoint Designer Workflow error - Coercion Failed: Input cannot be null for this coercion
- [Solved] SharePoint Access Denied error editing Document Name
- SharePoint 2016 error - Could not find file ManageUserProfileServiceApplicationTenantSimplified.xml
- Bypass domain name for IIS site (SharePoint)
- SharePoint PowerShell Merge-SPLogFile filter by time using StartTime EndTime
- Recover SharePoint if the SQL Server IP changes
- SharePoint CAML query error - The XML source is not correct
- How to enable disable SharePoint Developer Dashboard for tracing troubleshooting
- Change SharePoint search results FullTextSqlQuery RowLimit 10000
- Update Created By (Author) column of SharePoint document using PowerShell
- SharePoint Server 2016 error - Failed to connect to the configuration database
- The service instance
- SharePoint Managed Metadata Hidden Taxonomy List - TaxonomyHiddenList
- Android : Error in http connection java.net.SocketException: Permission denied - Android
- How to create Toast messages in Android - Android
- How to Search Something (string) in Android Studio Project like Eclipse - Android-Studio
- Free Unlimited Calls from MTNL & BSNL Landlines from 1st May 2015 - HowTos
- Adding internet permission to Android Project - Android
- How to turn off Facebook autoplay videos on timeline - Facebook
- Android : How to make TextView Scrollable - Android
- Sharepoint Server 2016 installation Prerequisites with download links - SharePoint
- Android Toast position top - Android
- How to submit website to dmoz directory - HowTos
- SharePoint Server 2016 setup error - A system restart from a previous installation or update is pending. Restart your computer and run setup to continue. - SharePoint
- Java XML-RPC 3.1.x based web service example - Java
- Plug-in com.android.ide.eclipse.adt was unable to lead class Error - Android