Mastering Array Filtering in Make App: A Comprehensive Guide

Over view, read an excel file, check the email doesn’t already exist in my clickup list, if not continue to add them etc. My issue is when I try and use the filter with “Does not equal” or even “Does not contain” the filter compares each one, then if any one of the item is false, it will contiue. I noticed I was using Text version and not array so tried that too. For example, say the below already already existed: 1. batman@batman.com [batman@batman.com] 2. spiderman@spiderman.com [spiderman@spiderman.com] 3. ironman@ironman.com [ironman@ironman.com] 4. wonder@women.com [wonder@women.com] 5. Captain@america.com [Captain@america.com] It would compare batman@batman.com [batman@batman.com] against each one, first one would be false, then the next one would be true, then it would add it again. When I try other filters, it doesn’t add it at all. over all [https://europe1.discourse-cdn.com/business20/uploads/make/optimized/2X/d/da33f5b2cfb0f9257a070da5964c037a7c13c848_2_690x404.png]over all2404×1411 254 KB [https://europe1.discourse-cdn.com/business20/uploads/make/original/2X/d/da33f5b2cfb0f9257a070da5964c037a7c13c848.png] I tried to filter before it hads to the array and also after. I get the same results. I use the aggreagtor since when searching through clickup list, if I didn’t use aggregator, it would just search agaist one result. filter one: filter one [https://europe1.discourse-cdn.com/business20/uploads/make/optimized/2X/8/8f7c72af19f8a35715ff992c0dfbada6bb75b591_2_587x500.png]filter one889×756 51.4 KB [https://europe1.discourse-cdn.com/business20/uploads/make/original/2X/8/8f7c72af19f8a35715ff992c0dfbada6bb75b591.png] Filter one output: filter 1 resul [https://europe1.discourse-cdn.com/business20/uploads/make/optimized/2X/3/30f5e1c558a3ef183c408a1973f6d651f65718e2_2_418x499.png]filter 1 resul1245×1489 132 KB [https://europe1.discourse-cdn.com/business20/uploads/make/original/2X/3/30f5e1c558a3ef183c408a1973f6d651f65718e2.png] Filter two: filter 2 [https://europe1.discourse-cdn.com/business20/uploads/make/optimized/2X/1/1164a5b63a374f52fe0f97a74f6ce4a06047e742_2_513x500.png]filter 2801×780 72.8 KB [https://europe1.discourse-cdn.com/business20/uploads/make/original/2X/1/1164a5b63a374f52fe0f97a74f6ce4a06047e742.png] Filter 2 results: filter 2 results [https://europe1.discourse-cdn.com/business20/uploads/make/optimized/2X/9/90d40c2edf22826934ef20701e345f8bfa4565d9_2_630x500.png]filter 2 results1023×811 76.9 KB [https://europe1.discourse-cdn.com/business20/uploads/make/original/2X/9/90d40c2edf22826934ef20701e345f8bfa4565d9.png] I know the answer must be simple, but really struggling. Appricate any help I can get. Many thanks.

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.