Re: Auto-Populating Fields in InfoPath Forms Services from a SharePoint List

Jo-Anne Alfafara — Thu, 30 Jul 2009 15:08:51 GMT

Hi Aaron,

Welcome to our forum!

You may want to try our QuerySharePoint Web Service:

Video: http://www.infopathdev.com/files/folders/video_demos/entry39774.aspx
User Manual: http://www.infopathdev.com/files/folders/sharepoint/entry33873.aspx
Performance Analysis: http://www.infopathdev.com/blogs/ernesto/archive/2009/01/07/dbxl-v2-3-performance-analysis.aspx

The benefits of QuerySharePoint Web Service are:

Performance: The Web service executes the filter on the server and only sends you the matches
Quick and Easy: Use our Query Builder Tool to build your queries
Low Cost: No need to write and maintain code

This Web Service is available in package with Qdabra DBXL and WSSP which you can download on a free trial basis at Qdabra.com. You can check out on our download page here.

Let us know if you have any questions.

Auto-Populating Fields in InfoPath Forms Services from a SharePoint List

agreen29 — Wed, 29 Jul 2009 13:48:28 GMT

I am new to this forum and I am looking for some guidance here, what I a trying to accomplish is to query a SharePoint list that has a lot of data (2000 items with 45 or so columns) and auto-populate fields with the data that matches the SharePoint ID from the list item. I have gotten this to work correctly using a data connection and filtering the "Set a field's value" action when I run the form in the client application (InfoPath 2007). However when I run the form in the browser I get the pop-up script errors warning the user about the script causing browser to run slowly and eventually it freezes. I know this has to do with the size of the list, but I am looking for some type of work-around to be able to return the values that are needed to populate those fields. I am not a real strong programmer, but I do have a little bit of knowledge, so any guidance would be greatly appreciated.

Here is the system information

InfoPath 2007 & MOSS 2007 Enterprise with InfoPath Forms Services configured and enabled.

Thanks in Advance - Aaron

Data Connections

Re: Auto-Populating Fields in InfoPath Forms Services from a SharePoint List

Auto-Populating Fields in InfoPath Forms Services from a SharePoint List