Browser Forms

Re: Search does not filter the desired results

jun_barbosa — Fri, 16 May 2014 03:46:59 GMT

Sorry again for the late reply,

Attached is a simple form, you can see how I did it.

Please at the properties of the drop down list. It gets it values from a secondary data source IPD01Counties

Then take a look at the rules I created for the Title and Address fields from the secondary data source IPD01Address

I hope this helps,

Jun

Re: Search does not filter the desired results

jun_barbosa — Tue, 13 May 2014 09:11:13 GMT

Sorry for the late reply, I'll take a look at your form

Re: Search does not filter the desired results

darogael — Fri, 09 May 2014 23:44:06 GMT

Hi Jun,

Thank you for your response.

Attached is my InfoPath 2013 form.

Re: Search does not filter the desired results

jun_barbosa — Fri, 09 May 2014 04:41:30 GMT

Hi, would you mind attaching the form so I can take a look?

- jun

Search does not filter the desired results

darogael — Thu, 08 May 2014 20:04:07 GMT

Hello,

I have been struggling with getting the search filter to work on a web-based InfoPath form.

I have a SharePoint list A with a choice column called Counties of all the counties of a state. I also have setup a another SharePoint list B that has thousands of address items which include address1, address2, city, state and county columns.

Now I need to setup a search form such that when a user selects a county from list A and clicks on the search button, all the matching addresses from list B should displayed below.

So far here is what I have done-

I opened InfoPath designer from the SharePoint list A where I see the Counties look-up or choice column. In the form I also added a data connection to SharePoint list B.

I then added an action to the SharePoint List A column to query using a data connection. The condition is such that on the left I have setup any occurence of County (from List B) equals Counties (from List A).

Right beneath the search button I added a Repeating section with controls using List B.

From here onwards is where I am confused-

Do I need to add another Action to the button to query List B again?

Do I need to add filters to each field of the repeating section (i.e. List B)?

Currently, I have added a added only a query action to the button for List B with no conditions. On the web form, wether the Counties is selected or not, if I hit the search button, it takes a good 10 seconds for the results to appear and it gives me all the results. Not the filtered results I am looking for.

Can anyone give me a step-by-step instruction?

Thanks in advance.