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.