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

List.Union

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

About

Returns a list from a list of lists and unions the items in the individual lists. The returned list contains all items in any input lists. Duplicate values are matched as part of the Union.

List.Union(list as 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.

Examples

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