Comparing List with List | AppSheet Explained

In this video I show how you can compare two lists with each other, finding the common elements, to use as a logical filter statement (which could then be used in a slice or security filter, for example).
BASIC IDEA:
First use INTERSECT() to find the common elements between two lists
Then us IsNotBlank() to determine if that resultant list is NOT empty
IsNotBlank(Intersect([LIST_1], [LIST_2]))
If there are common elements, then the INTERSECT() will result in a list of those common elements; and by wrapping that in IsNotBlank() I can get a logical statement to use in other formulas.
Table of Contents |----------------------------------------------------------------------------------------
COMMING_SOON (someone help me out here...)
-----------------------------------------------------------------------------------------------------------------------
/////////////////////////////////////////////////////////////////////////////
/// SUPPORT THE CHANNEL
/////////////////////////////////////////////////////////////////////////////
//
// Answer Portal
// www.MultiTechV...
//
// Merch
// multitech-merc...
//
/////////////////////////////////////////////////////////////////////////
For more information about MultiTech Visions, visit
www.MultiTechVisions.com
#CitizenDeveloper #AppSheet

[@samariter4292]

Hi Matt. We all hope that you are well and just busy with new incredible projects. For me, your way of presenting information is the most interesting among such channels. Looking forward to new video. Best wishes

[@SportsCentreLo]

Thanks for the explanation! Just a heads up, at 4:41 there is a prompt from AppSheet with the X saying “Intersect takes two arguments of a type list “ I wonder if it still worked?

[@Hosteller]

Hi Matt,
I am Prasanth.
Could you please explain about
How to autosave in usersetting form in appsheet (Login page) with out clicking saving button???
Thanks in advance...

[@danielanavarroquintero1814]

Hi Matt!! Thanks for your videos... I have a question, I want to create a EnumList with a ref, and when I Select some opctions in that Enumlist bring me the email of those opctions... an send a push notification :D I hope I could is was clear..
Thanksss!!!

[@ericlam1109]

@multitech visions
Hello Matt! I have a question, i think what you teach here are the thing that can solve my problem. But i am still little Confused.
1. So i need to set if the user can see some of the rows. so the rows include [Userroles] (this USERROLES are lists,)
2. i need to compare two lists which is from different table which is HomePage[Userroles] & Employee[Department]
3. can you help me to solve my puzzle?
ISNOTBLANK(INTERSECT([USERROLES],SPLIT(ANY(SELECT(EMPLOYEE[DEPARTMENT],USEREMAIL()=[EMAIL])),_"_,_"))
Did i do something wrong here?

[@andreasangalli9597]

Hello Matt!!Thanks for the tips, what about if in one of the lists we have something like *** 344 Last name, Name *** in the first list but in the second list we have Last nameName. And we want show the value in the second list ? thanks

[@MultitechVisions]

Nice and complicated! (I love it!) (^_^) This situation is a bit different, as what's described in the video is how to create a slice formula, and your situation is more geared towards displaying the data.
In that situation, what you'd want to do is a 2-step process to get your answer.
1. Get your list of items (using a similar formula to what's in the video); this gives you the list of the "ref items" you're wanting
2. Use a list dereference formula to extract out of the first list the actual values you want.
- This is similar to what you can find in this video: th-cam.com/video/XP-gqeB9pFo/w-d-xo.html

[@andreasangalli9597]

@@MultitechVisions really appreciate!! And I’m so happy that is complicated because I’m stuck here for days 🙃. Thanks for your channel!! It is very very helpful

[@tom-greg]

Hi! Any new videos planned? There are many of us missing you and your amazing videos :) I hope you are fine!

[@chandralim5860]

Hi Matt i hope you're doing fine,we miss u and your superb video

[@samariter4292]

Hi Matt. How are you? We miss you, make new video please)

[@rm00l60]

I hope you are doing well

[@Midavok]

OR you can use the IN function:
if(
IsNotBlank (Index(Current_User[FiILTER_Construction_Type],1)),
IN(
[Construction_Type]],
Index(Current_User[FiILTER_Construction_Type],1),
),
true),

[@MultitechVisions]

This will work if you've got [Single_Value] and [List]... not if both are lists. (Thanks for pointing out something I forgot to mention!)

[@Midavok]

@@MultitechVisions no, you're wrong. It's works with 2 lists too. Just try

[@MultitechVisions]

@@Midavok If you say so....🤔 maybe keep exploring, you might find at some point that it fails; at which point you'll want to adjust the formula syntax. Cheers

[@Midavok]

@@MultitechVisions Just try

[@adiology_aditya]

Your contents are great but not reaching a wider audience, Your thumbnails are looking attractive. I have some suggestions for you, you should work on your video editing and writing an SEO-friendly description.