Filter A Collection With OR Condition

Input collection: myTrucks41

Year	Make	Model
2020	Ford	F150
2018	Chevy	Silverado
2019	Ford	F150
2020	Chevy	Avalanche
2017	Chevy	Silverado
2016	GM	Yukon

Output collection: mySolution41 (filter on Model equals ‘Silverado’ or ‘Yukon’)

Year	Make	Model
2018	Chevy	Silverado
2017	Chevy	Silverado
2016	Ford	Yukon

Solution code:

//Create a collection
ClearCollect(myTrucks41,
{Year: 2020, Make: "Ford", Model: "F150"},
{Year: 2018, Make: "Chevy", Model: "Silverado" },
{Year: 2019, Make: "Ford", Model: "F150" },
{Year: 2020, Make: "Chevy",Model: "Avalanche"},
{Year: 2017, Make: "Chevy", Model: "Silverado"},
{Year: 2016, Make: "GM", Model: "Yukon"}
);

//Filter collection code
ClearCollect(
    mySolution41,
    Filter(myTrucks41,Model="Silverado" Or Model="Yukon")
);