Re: How to set up complex query to query a large amount forms in SharePoint form library.

Hilary Stoupa — Thu, 21 Jun 2018 15:36:42 GMT

So, yeah, the data set is updated each time. But you can set more query fields, as long as you are using equivalence (i.e. Status = Submitted and CurrentApprover = userName()). What helped me understand query fields better was dragging the query and data fields onto the form canvas, and adding a button to run the query. Then I could try various things and run the query and see the results.

How to set up complex query to query a large amount forms in SharePoint form library.

SundayCat — Thu, 14 Jun 2018 18:21:58 GMT

Hi,

We have an InfoPath form library which holds more than 1200 forms, recently we got data connection error which says data connection has exceeded the maximum limit. I'm trying to set up a predefined query to reduce the data, but not sure if it's doable.

Currently we query data using form status, I would like to add some other search criteria which is kind of dynamic, like if current user is an approver or the form creator etc,

If I query multiple times using same data connection, will the last one overwrite the previous query?

Really appreciate any suggestion.

Data Connections

Re: How to set up complex query to query a large amount forms in SharePoint form library.

How to set up complex query to query a large amount forms in SharePoint form library.