Skip to content

Flow action

Add the action Compare Lists. Each run compares one pair of lists.

List 1 is apple;banana;cherry. List 2 is banana;date. They share banana.

SettingIs Matched
Exact Match is trueFalse. The lists are not the same set.
Exact Match is false, minimum is 1True. One shared value meets the minimum.
Exact Match is false, minimum is 2False. Only banana is shared.

When Exact Match is true, Number of Required Matches is ignored. A blank minimum is treated as zero.

InputWhen to set it
List 1One value, or several separated by semicolons. A multi-select picklist already looks like this.
List 1 CollectionA text collection. Combined with List 1 when both are set.
List 2Same as List 1. Leave it empty when you only want the distinct values of List 1.
List 2 CollectionSame as List 1 Collection.
Exact Match?Always. True when both lists must contain the same values, ignoring order.
Number of Required MatchesWhen Exact Match is false. Is Matched is true when the shared count is at least this number. A blank number is treated as zero.

A collection item is one value, even when the text contains a semicolon. The text input splits on semicolons.

OutputWhat you get
Is MatchedTrue when the exact-match or required-match condition is met.
Number of MatchesHow many distinct values appear in both lists. This is the count compared with the minimum.
Matching ValuesThose shared values, sorted.
Unique Values List 1Values in the first list that are not in the second.
Unique Values List 2Values in the second list that are not in the first.

Spaces around a value are removed. Blank values are dropped. Duplicates count once. Red and red stay separate.