General

Re: How many columns can we publish to SharePoint Form Library using InfoPath

David@linksoftware.co.uk — Thu, 19 Jun 2008 15:32:52 GMT

Hi,

If you are publishing a new infopath 2007 form it does seem that you can publish as many fields as you wish, i have forms with several hundred promoted fields, though displaying them in one view is not a good idea.

The problem seems to be making changes to a form with high numbers of promoted fields, after a certain limit, typically around 100, the publishing of a new modified template seems to time out and give the updating content type failed message.

So it should be possible to promote as many form fields as you like, however this can severely restrict any further form development, unless of course you choose to remove some of the promoted fields or create a new library and re-link forms, and re-design and filters or default values in any forms that look at the original form library.

Re: How many columns can we publish to SharePoint Form Library using InfoPath

Dave Beckman — Thu, 13 Dec 2007 15:09:26 GMT

Is this limitation with both Infopath 2003 and 2007? Or is the limitation on SharePoint? I keep getting the error "Updating Content Type Failed". Looking at the other posts, there's no clear answer. I am wondering if the problem is truly a column limit.

Thanks, Dave

Re: How many columns can we publish to SharePoint Form Library using InfoPath

Patrick Halstead — Wed, 08 Aug 2007 02:19:21 GMT

The numbers are limited based on datatype. 32 ints, 64 strings, 8 datetimes, etc. Something like that I don't remember the exact limitations, but they make it very hard.

Why not just save your data to SQL - then you can have unlimited promoted properties.

Re: How many columns can we publish to SharePoint Form Library using InfoPath

nukkumatti — Tue, 07 Aug 2007 13:40:26 GMT

Hi, i do not exactly know how many you can have but i do know that sharepoint limits the colums you can use. i guess only option you have is to reduce somehow your colums. if possible use some repeating section and use the merge function to have more than one value in one column.

How many columns can we publish to SharePoint Form Library using InfoPath

praveen.prabhakaran — Tue, 07 Aug 2007 06:17:30 GMT

Hi all,

I'm trying to publish 162 columns to a SharePoint form libarary using InfoPath form. But i can see onlt 110 columns in it. Can anybody help me out in this?

Regards,

Praveen