12 columns - maximum number of list columns in the view of the specific type: people, lookup, and managed metadata. 3 000 items+ - number of items with unique permissions that could impact the performance. 250 MB - maximum size of the list attachment.
- Is there a column limit in SharePoint lists?
- How many lookup columns are allowed in SharePoint list?
- How do I get more than 5000 items from a SharePoint list?
- How do I allow more than 255 characters in SharePoint?
Is there a column limit in SharePoint lists?
With Windows SharePoint Services, you can create the following numbers of each column type for each list or library: 64 Single line of text and Choice (drop-down menu or radio buttons) 31 Multiple lines of text and Choice (check boxes (allow multiple sections)) 32 Number and currency.
How many lookup columns are allowed in SharePoint list?
In the Modern SharePoint online list, a view can contain the maximum number of 12 lookup columns. Yes, the default value is also used for SharePoint Online, where the default value is increased from 8 to 12. We cannot use more than 12 lookup columns in a SharePoint online list view.
How do I get more than 5000 items from a SharePoint list?
If you genuinely need to process more than 5000 items at a time, you'd want to call the SharePoint batch API to speed things up and even then need to create a loop with the do until action as a batch call can't have more than 1000 operations.
How do I allow more than 255 characters in SharePoint?
Refer to Multiple lines of text, A Multiple lines of text column can store up to 63,999 characters by default. There's no settings you need to change to allow more than 255 characters.