Returns the intersection of the list values found in the input.
function (
lists
as list, optionalequationCriteria
as nullable any) as list
Returns the intersection of the list values found in the input list lists
. An optional parameter, equationCriteria
, can be specifed.
List.Set operations
Find the intersection of the lists {1..5}, {2..6}, {3..7}.
List.Intersect({ {1..5}, {2..6}, {3..7} })
{3, 4, 5}