Infopath limitation

[suebr]

I've been told that Infopath does not pass more than 100 fields to Sharepoint
2007 - is that true? Any known workarounds?

thanks,

 

[Clay Fox]

I am not sure exactly what limitiation you are referring to.

By default SharePoint views only show 100 rows at a time. That means that
when a libray or list is queried in InfoPath you only get the first 100.
However turning off this default property in the view in Sharepoint resolves
this.

You may be referring to promoted properties in SharePoint. there is a limit
there but if you have that many fields you should be using SQL rather than SP
since it is not really built for that kind of use. There are much better
ways to aggregate and report on your form data.

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello

Please read this link on limitations on Promoted Columns in Sharepoint
http://support.microsoft.com/kb/823555