https://www.infopathdev.com:443/forums/40.aspxFor browser form specific questionsenCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/118713.aspxMon, 09 Apr 2018 13:06:40 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118713Guillaume0https://www.infopathdev.com:443/forums/thread/118713.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=40&PostID=118713I find the solution !! You can compare both lists only if it has the same variable. I tested : number with formula (number type) = KO, Number with choice = KO, number with number =OK. So I have created a new column (number type) in my sharepoint list and with Nintex I have copied the data in. Now, I can compare my both lists beacause I compare the same variable type. Thank you for your support !!https://www.infopathdev.com:443/forums/thread/118697.aspxThu, 05 Apr 2018 16:18:19 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118697Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118697.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=40&PostID=118697I don't understand why you would do this. What you want to do as it stands is perfectly possibly, as demonstrated in my sample form. Is there a reason you don't want to use a lookup column in your Reserved Materials list?https://www.infopathdev.com:443/forums/thread/118696.aspxThu, 05 Apr 2018 16:13:26 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118696Guillaume0https://www.infopathdev.com:443/forums/thread/118696.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=40&PostID=118696I have an idee !! if I can write all elements of my list1 in Multiple lines field, so I will be able to test if this Multiple lines field contain the elements of my list 2. Is it possible to write all list elements in Multiple lines field ?https://www.infopathdev.com:443/forums/thread/118690.aspxWed, 04 Apr 2018 21:03:42 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118690Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118690.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=40&PostID=118690I really think the issue is that your data types don't match across your lists. If you use a lookup for the column in the reserved materials, then you can filter on the ID (lookups store the ID for the parent list).https://www.infopathdev.com:443/forums/thread/118687.aspxWed, 04 Apr 2018 15:51:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118687Guillaume0https://www.infopathdev.com:443/forums/thread/118687.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=40&PostID=118687I am testing many combinaison to try to filter 2 sharepoints lists. When I will find solution, I will write it in this post.https://www.infopathdev.com:443/forums/thread/118662.aspxFri, 30 Mar 2018 21:59:51 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118662Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118662.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=40&PostID=118662In Reserved Material, on SharePoint, in the list settings, I would make Tracmor number a lookup column that looks up the Tracmor number from the Stock list. That way you can only select valid numbers. After you do that, walk through the data connections in the form again to update them. Then, your comparison for the dropdown where you wish to only display stock(N°Tracmor) would be able to compare on the ID.https://www.infopathdev.com:443/forums/thread/118658.aspxFri, 30 Mar 2018 14:50:00 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118658Guillaume0https://www.infopathdev.com:443/forums/thread/118658.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=40&PostID=118658The Reserved material(Tracmor number) is a data connection (with filter) to stock(N°Tracmor). So this column content the same data that stock(N°Tracmor). I am developing all lists and forms, so I can add modifications if need.https://www.infopathdev.com:443/forums/thread/118657.aspxFri, 30 Mar 2018 14:38:58 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118657Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118657.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=40&PostID=118657The second screenshot doesn't make sense to me - is the column really a choice with the default values you show? Based on the screenshot of the list data, though, I can see the Reserved Materials list has text entered for the number & the stock list has a number value. This could be causing the comparison issue. Are these lists in use currently? Or are you still developing them? I ask because it seems to me that you'd want to use a lookup for this column in the Reserved Materials list.https://www.infopathdev.com:443/forums/thread/118654.aspxFri, 30 Mar 2018 09:44:13 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118654Guillaume0https://www.infopathdev.com:443/forums/thread/118654.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=40&PostID=118654And sorry, I don't see that I can't attache more than one document. See in attachment the Reserved material(Tracmor number) details.https://www.infopathdev.com:443/forums/thread/118653.aspxFri, 30 Mar 2018 08:17:52 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118653Guillaume0https://www.infopathdev.com:443/forums/thread/118653.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=40&PostID=118653the SharePoint listshttps://www.infopathdev.com:443/forums/thread/118652.aspxFri, 30 Mar 2018 08:16:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118652Guillaume0https://www.infopathdev.com:443/forums/thread/118652.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=40&PostID=118652I attached the form of "reserved material" and picture with the SharePoint lists. The Reserved material(Tracmor number) is a data connection (with filter) to stock(N°Tracmor). Thank you in advance for your replyhttps://www.infopathdev.com:443/forums/thread/118651.aspxThu, 29 Mar 2018 18:05:15 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118651Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118651.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=40&PostID=118651Can you send the screenshot from the Reserved Materials instead? Is that column a lookup type in Reserved Materials?https://www.infopathdev.com:443/forums/thread/118649.aspxThu, 29 Mar 2018 16:15:45 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118649Guillaume0https://www.infopathdev.com:443/forums/thread/118649.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=40&PostID=118649You think there is compatibility variable issue ?https://www.infopathdev.com:443/forums/thread/118646.aspxThu, 29 Mar 2018 14:35:27 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118646Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/118646.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=40&PostID=118646I'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.https://www.infopathdev.com:443/forums/thread/118642.aspxThu, 29 Mar 2018 08:18:39 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:118642Guillaume0https://www.infopathdev.com:443/forums/thread/118642.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=40&PostID=118642Sorry 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