InfoPath 2010

Re: Filter infopath drop down list based on previously used entries

d133294 — Sat, 23 Mar 2019 00:06:12 GMT

wow I cannot believe it was so simple. I just used expression when I applied the filter on the value that I wanted, and viola!! it worked. Thanks

Re: Filter infopath drop down list based on previously used entries

Hilary Stoupa — Fri, 22 Mar 2019 14:53:50 GMT

Here's a simplified sample of the filter you need on the dropdown - you'll need to have a data connection to list 2 in the form (so you know what all has been used) then on your dropdown you can add a simple field from list 1 = field from list 2 filter and wrap it in a not(). Save the attached file locally, right click and select design, then preview.

Filter infopath drop down list based on previously used entries

d133294 — Thu, 21 Mar 2019 20:44:38 GMT

Hello everyone,

I have a sharepoint (SharePoint list 1) list that has 2 columns: column A which has values of 1 - 99 and column B which has random names. I have another sharepoint list that uses the values from sharepoint list 1, which I pull into a form.

Here is my question, I want to know if it is possible to filter the drop down list values (pulled from sharepoint list 1) in the sharepoint list 2 form based on the stored values in sharepoint list 2. Lets say I'm filling out the form in sharepoint list 2 and I fill in some random fields and I get to the drop down selector that pulls the values from sharepoint list 1, and I select one of those fields then submit the form to post to sharepoint list 2. Next, I am creating another entry using sharepoint list 2 form and when I get to the drop down list, I want it to display the remaining values, minus the one(s) that I have already used from previous submissions.