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
//
// Merch
//
/////////////////////////////////////////////////////////////////////////

For more information about MultiTech Visions, visit

#CitizenDeveloper #AppSheet

[samariter]

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...

[danielanavarroquintero]

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!!!

[andreasangalli]

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

[ericlam]

@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?

[samariter]

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

[tom-greg]

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

[chandralim]

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

[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.

[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),