Find Matching Values Within Two Collections

Input collection: myFruit27a

Value

Apples

Oranges

Bananas

Kiwis

Grapes

Pears

Input collection: myFruit27b

Value

Apples

Plum

Oranges

Pears

Cherries

Mangos

Output collection: mySolution27a

Month

Apples

Oranges

Pears

Solution code:

//create collections
ClearCollect(myFruit27a,["Apples","Oranges","Bananas","Kiwis","Grapes","Pears"]);
ClearCollect(myFruit27b,["Apples","Plum","Oranges","Pears","Cherries","Mangos"]);

//get matches stored in a Collection
ClearCollect(
    mySolution27a,
        ShowColumns(
            Filter(
                AddColumns(
                   myFruit27a,
                  "MatchFound",
                  If(!IsBlank(LookUp(myFruit27b,Value=myFruit27a[@Value])),true,false)
            ),
           MatchFound=true),
       "Value")
);

Output value: mySolution27b (in a text string)

Apples,Oranges,Pears

Solution code:

//create collections
ClearCollect(myFruit27a,["Apples","Oranges","Bananas","Kiwis","Grapes","Pears"]);
ClearCollect(myFruit27b,["Apples","Plum","Oranges","Pears","Cherries","Mangos"]);

//get matches stored in a Collection
ClearCollect(
    mySolution27a,
        ShowColumns(
            Filter(
                AddColumns(
                   myFruit27a,
                  "MatchFound",
                  If(!IsBlank(LookUp(myFruit27b,Value=myFruit27a[@Value])),true,false)
            ),
           MatchFound=true),
       "Value")
);