150 Columns

Discussions about Forms Designer for SharePoint 2013 / 2016 and Office 365.
Locked
Cloud.Ed
Posts: 40
Joined: Fri Dec 04, 2015

26 Jun 2016

We started converting some InfoPath forms to lists forms. The new list has 150 columns and opens fine in the SharePoint form. When we add all of the columns to the Designer form we start getting load errors.

TYPE ERROR: Object expected

The errors are intermittent and we are at our wits end. Is there some limit we are not aware of? We know we can break up the list and use the related items, we would like to avoid this approach to make reporting on this data easy.

User avatar
Dmitry Kozlov
Site Admin
Posts: 1524
Joined: Thu Jun 07, 2012

27 Jun 2016

Hi,

Most likely, the issue relates to the number of fields on the form. There is a limit of about 70 fields per form:

http://sharepoint.stackexchange.com/que ... -edit-form

But you can put any number of fields in the read-only mode. So, you can create a general form with all fields in read-only mode and put links to separate forms containing less than 70 fields per form with the help of form sets.

Locked
  • Information
  • Who is online

    Users browsing this forum: No registered users and 4 guests