InfoPath Dev

Hi all, I have 2 Sharepoint lists connected to my infopath Form (secondary data connection). I would like compar both lists et display the result in the dropdown menu. exemple: Data connection list1: item1, item2, item3, item4, item5, item6 Data connection list2: item2, item3, item6 Display the result in the dropdown menu: item1, item4, item5

So - does list 1 have all the items you need? If so, something like the attached sample should work (save the file locally, right click & select design to open in design mode, preview to try out). Basically, I used the Filter Data button when selecting the items, changed the filter of field2 = field3 to an expression and used the not() operator to display only the items that were NOT in the second repeating group. If you actually need to merge data from the two list, unfortunately, you would need to use code.

Thank you for your help, that's exactly what I want to do!!! When I open your file, I can add "Extensible table" in "containers", but in my infopath, I have not it.. How do you add/active "Extensible table" ? Thank you in advance for your answer.

Oh - I used repeating tables so you'd have a sample that didn't have a data connection. You can do the exact same type of thing with your two SharePoint lists. If you need help setting up the filter for your dropdown, feel free to attach a copy of your form under the Options tab in a reply. Sounds like you are probably using a SharePoint List form if repeating tables aren't available in your controls.

In effect, I am using a SharePoint List form. So I can't use "Extensible table" ?

You will have repeating data in your data connections to the two lists. That gives you repeating data, just like in my example. I used repeating tables in the sample so the sample form wouldn't need any data connections. If your question has to do with controls allowed in List forms - no, you can't add main data source repeating tables unless when you create the form, you select manage multiple items.

Ok thank you. But can I compare 2 data list connection ? (like an extensible list?). If yes, can you help me to write the filter expression ?

Yes. Please attach your file under the Options tab in a reply & I can help you.

Thank you for your help. I add in attachment my InfoPath form. What language did you use to code the filter expression ?

InfoPath uses XPath, because it is XML based. Which of the two lists has all the items? Stock? So you only want to see things in your dropdown from Stock that are not in Reserved Material?

Oh, one more question. Is Tracmor number in "Reserved Material" a lookup?

Sorry for my lack of explanation. Tracmor is an item identification code. The "stock" list contain all "N°Tracmor" and the "Reserved material" list contain only the "Tracmor number" which are booked. I would like in (champ13 (in french) or field13 (in english)) the "N°Tracmor" from "stock" list less "Tracmor number" from"Reserved material" list. (field13=stock(N°Tracmor) - Reserved material(Tracmor number)). Thank you in advance for your help

I'm going to guess that Tracmor in the Reserved material list is a lookup, and that the Reserved material list data would actually be storing the item ID. I've modified your expression on the dropdown for that scenario. If you can give me additional info on the Tracmor column in the Reserved material list (like a screenshot of the column settings from the list settings in SharePoint) that would be helpful.

You think there is compatibility variable issue ?

Can you send the screenshot from the Reserved Materials instead? Is that column a lookup type in Reserved Materials?