List.Intersect
ListReturns the intersection of a list of lists, containing only items that appear in every list.
Syntax
List.Intersect(lists as list, optional equationCriteria as any) as listParameters
| Name | Type | Required | Description |
|---|---|---|---|
lists | list | Yes | A list of lists to intersect. |
equationCriteria | any | No | An optional equation criteria value to control how values are compared for equality. |
Return Value
list — A list of distinct items that appear in all of the provided lists.
Remarks
List.Intersect takes a list of lists as its first argument — not two separate list arguments — and returns a new list containing only items that appear in every one of the provided lists. The result is automatically deduplicated (distinct values only).
This function is useful for finding common values across multiple datasets: customers who appear in all sales regions, product codes active in every store, or employees on every team. The result preserves the relative order of first-appearing values from the first list.
Note the argument shape: you must wrap your lists in an outer list — {listA, listB} — not pass them as separate arguments. If any input list is empty, the result is immediately an empty list (nothing can be in all lists if one is empty). Comparison is case-sensitive for text by default; pass Comparer.OrdinalIgnoreCase as the optional second argument for case-insensitive matching.
Examples
Example 1: Intersect two lists
List.Intersect({{1, 2, 3, 4}, {2, 4, 6}})Result | |
|---|---|
| 1 | {2, 4} |
Example 2: Intersect three lists
List.Intersect({{"A", "B", "C"}, {"B", "C", "D"}, {"C", "D", "E"}})Result | |
|---|---|
| 1 | {C} |
Example 3: Find common customers across regions
let
RegionA = {"Cust-01", "Cust-02", "Cust-03"},
RegionB = {"Cust-02", "Cust-03", "Cust-04"},
RegionC = {"Cust-02", "Cust-05", "Cust-03"},
CommonCustomers = List.Intersect({RegionA, RegionB, RegionC})
in
CommonCustomersResult | |
|---|---|
| 1 | {Cust-02, Cust-03} |