Microsoft Sharepoint Online - total size of the columns in this list exceeds the limit

Hi parthup ,

each  SharePoint list item can max. occupy 8,000 bytes per row (see software boundaries here: https://learn.microsoft.com/en-us/sharepoint/install/software-boundaries-and-limits#list-and-library-limits). 300 Bytes are reserved, so you can use 7,700 bytes

You can get all columns from your list if you use the SharePoint REST api in your browser. Simply open

<Yoursiteurl>/_api/web/lists/getbytitle('<your list name>')/fields

and save the XML. You can transfrom that result into an Excel file using Power Query

Now you can count the fields and determine their type (i.e. using the field "TypeAsString" Property).
For the size of each field type refer to this table
https://learn.microsoft.com/en-us/sharepoint/install/software-boundaries-and-limits#Column
Sum that up to calculate your list size.

Best Regards,
Sven