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

List.Difference

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

About

Returns the items in list 1 that do not appear in list 2. Duplicate values are supported.

List.Difference(list1 as list, list2 as list,optional equationCriteria as any) as list  

Arguments

ArgumentDescription
list1The List to check with.
list2The List to check against.
optional equationCriteriaAn optional equation criteria value to control equality comparisons. For more information about equality comparisons, see Parameter Values.

Examples

List.Difference({1..10}, {2..3,5..7}) equals {1,4,8,9,10}  
List.Difference({1}, {1,2,3}) equals {}  
List.Difference({1, 1, 1}, {1}) equals {1, 1}  
© 2018 Microsoft