Hii,
I have one list of project Credit Application, its column exceeds above 300 so now i can’t create any more new columns in it. Does anybody know how much is the exact limitation of creating columns in custom list of Sharepoint on premise?
If it exceeded, what will be the best solution to resolve this?
Best answer by Garrett
Hi
Both SharePoint on-Prem and SharePoint Online have a limitation of 8,000 bytes per row.
Different column types have sizes.
Google for “SharePoint 2019 Limitations Column Limit”
| Limit | Maximum # columns | Size per column |
|---|---|---|
| Single line of text | 255 | 30 bytes |
| Multiple Lines of Text | 350 | 22 bytes |
| Choice | 255 | 30 bytes |
| Choice (multiple selection) | 350 | 22 bytes |
| Number | 550 | 14 bytes |
| Currency | 550 | 14 bytes |
| Date and Time | 55 | 14 bytes |
| Lookup | 750 | 10 bytes |
Try to reduce the number of columns.
+16Hi
Both SharePoint on-Prem and SharePoint Online have a limitation of 8,000 bytes per row.
Different column types have sizes.
Google for “SharePoint 2019 Limitations Column Limit”
| Limit | Maximum # columns | Size per column |
|---|---|---|
| Single line of text | 255 | 30 bytes |
| Multiple Lines of Text | 350 | 22 bytes |
| Choice | 255 | 30 bytes |
| Choice (multiple selection) | 350 | 22 bytes |
| Number | 550 | 14 bytes |
| Currency | 550 | 14 bytes |
| Date and Time | 55 | 14 bytes |
| Lookup | 750 | 10 bytes |
Try to reduce the number of columns.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
