Table of contents
TOC
Collapse the table of content
Expand the table of content

List.Intersect

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

About

Returns a list from a list of lists and intersects common items in individual lists. Duplicate values are supported.

List.Intersect(list as list /* { List } */,optional equationCriteria as any) as list  

Arguments

ArgumentDescription
listThe List of lists to check.
optional equationCriteriaAn optional equation criteria value to control equality comparisons. For more information about equality comparisons, see Parameter Values.

Remarks

  • If nothing is common in all lists, an empty list is returned.

Examples

List.Intersect({ {1..5}, {2..6}, {3..7} }) equals {3..5}  
List.Intersect({ {1..5}, {4..8}, {7..11} }) equals {}  
List.Intersect({ {1, 1, 1, 2}, {1, 1, 2, 2} }) equals {1, 1, 2}  
© 2018 Microsoft